Overview
Which transmission facilities bound in NYISO's real-time market and what each one cost, one row per interval and constraint. 2.07M rows, 2015-01 to now. Columns: event_time, constraint_name, shadow_price_usd_mwh, plus contingency. The shadow price is the marginal cost of the binding limit — what the market would have saved from one more megawatt of capability on that element. This is the table that answers WHY congestion appeared; a price spread between two locations shows that they separated but not which facility separated them.
Use with MCP
This table is readable two ways, over the same guarded boundary. Over HTTP: POST /api/v1/datasets/nyiso_constraints_rt/query, described in the API reference. Or from an MCP client: connect a market below, then use search_data or describe_data to load its query contract before calling query_data.
Schema4
event_timeDateTime64(6, 'UTC')constraint_nameLowCardinality(String)contingencyLowCardinality(String)shadow_price_usd_mwhNullable(Float64)Sample rows
| event_time | constraint_name | contingency | shadow_price_usd_mwh |
|---|---|---|---|
| 2026-08-28 01:15:00.000000 | FARRAGUT 138 PLYMTHST 138 1 | BASE CASE | -0.02 |
| 2026-08-28 00:50:00.000000 | E13THSTA 345 FARRAGUT 345 1 | BASE CASE | 0.06 |
| 2026-08-28 00:25:00.000000 | E13THSTA 345 FARRAGUT 345 1 | BASE CASE | 0.06 |
| 2026-08-28 00:05:00.000000 | FARRAGUT 138 PLYMTHST 138 1 | BASE CASE | -0.02 |
| 2026-08-28 00:05:00.000000 | E179THST 138 HELLGATE 138 1 | BASE CASE | -0.02 |
| 2026-08-28 00:05:00.000000 | E13THSTA 345 FARRAGUT 345 1 | BASE CASE | 0.06 |
| 2026-08-28 00:00:00.000000 | E13THSTA 345 FARRAGUT 345 1 | BASE CASE | 0.06 |
| 2026-08-28 00:00:00.000000 | FARRAGUT 138 PLYMTHST 138 1 | BASE CASE | -0.02 |
| 2026-08-28 00:00:00.000000 | E179THST 138 HELLGATE 138 1 | BASE CASE | -0.02 |
| 2026-08-27 23:45:00.000000 | E179THST 138 HELLGATE 138 1 | BASE CASE | -0.02 |
| 2026-08-27 23:40:00.000000 | E179THST 138 HELLGATE 138 1 | BASE CASE | -0.02 |
| 2026-08-27 23:35:00.000000 | E179THST 138 HELLGATE 138 1 | BASE CASE | -0.02 |
| 2026-08-27 23:25:00.000000 | GOETHALS 230 LINDEN 230 1 | TSA:CE113 Y88&77&76&SUG_BK1112 | 600 |
| 2026-08-27 23:15:00.000000 | E13THSTA 345 FARRAGUT 345 1 | BASE CASE | 0.06 |
| 2026-08-27 23:15:00.000000 | FARRAGUT 138 PLYMTHST 138 1 | BASE CASE | -0.02 |
| 2026-08-27 23:15:00.000000 | E179THST 138 HELLGATE 138 1 | BASE CASE | -0.02 |
| 2026-08-27 23:10:00.000000 | E13THSTA 345 FARRAGUT 345 1 | BASE CASE | 0.06 |
| 2026-08-27 23:10:00.000000 | FARRAGUT 138 PLYMTHST 138 1 | BASE CASE | -0.02 |
| 2026-08-27 23:10:00.000000 | E179THST 138 HELLGATE 138 1 | BASE CASE | -0.02 |
| 2026-08-27 23:00:00.000000 | E13THSTA 345 FARRAGUT 345 1 | BASE CASE | 0.06 |
| 2026-08-27 23:00:00.000000 | FARRAGUT 138 PLYMTHST 138 1 | BASE CASE | -0.02 |
| 2026-08-27 23:00:00.000000 | E179THST 138 HELLGATE 138 1 | BASE CASE | -0.02 |
| 2026-08-27 22:55:00.000000 | FARRAGUT 138 PLYMTHST 138 1 | BASE CASE | -0.07 |
| 2026-08-27 22:55:00.000000 | E179THST 138 HELLGATE 138 1 | BASE CASE | -0.02 |
| 2026-08-27 22:55:00.000000 | E13THSTA 345 FARRAGUT 345 1 | BASE CASE | 0.06 |