Overview
NYISO day-ahead locational marginal prices, one row per interval and location. 63.4M rows, 2015-01 to the next delivery day. Carries price_usd_mwh plus energy_usd_mwh, congestion_usd_mwh and loss_usd_mwh. Locations are zone and generator; location_id joins atg.nyiso_locations for the readable name, and kind is carried inline so a hub-only or zone-only question needs no join at all. Every market's day-ahead price table in this catalog has these same column names, so a cross-market price comparison is a UNION rather than a per-ISO rewrite. Revisions are already collapsed — read it plainly.
Use with MCP
This table is readable two ways, over the same guarded boundary. Over HTTP: POST /api/v1/datasets/nyiso_prices_da/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.
Schema7
event_timeDateTime64(6, 'UTC')location_idLowCardinality(String)kindLowCardinality(String)price_usd_mwhNullable(Float64)energy_usd_mwhNullable(Float64)congestion_usd_mwhNullable(Float64)loss_usd_mwhNullable(Float64)Sample rows
| event_time | location_id | kind | price_usd_mwh | energy_usd_mwh | congestion_usd_mwh | loss_usd_mwh |
|---|---|---|---|---|---|---|
| 2026-08-29 03:00:00.000000 | 61752 | zone | 39.55 | 42.16 | 0 | -2.61 |
| 2026-08-29 03:00:00.000000 | 61754 | zone | 41.16 | 42.169999999999995 | 0 | -1.01 |
| 2026-08-29 03:00:00.000000 | 61753 | zone | 40.48 | 42.169999999999995 | 0 | -1.69 |
| 2026-08-29 03:00:00.000000 | 61760 | zone | 44.23 | 42.16 | 0 | 2.07 |
| 2026-08-29 03:00:00.000000 | 61755 | zone | 42.68 | 42.17 | 0 | 0.51 |
| 2026-08-29 03:00:00.000000 | 61756 | zone | 43.14 | 42.17 | 0 | 0.97 |
| 2026-08-29 03:00:00.000000 | 61757 | zone | 43.18 | 42.17 | 0 | 1.01 |
| 2026-08-29 03:00:00.000000 | 61758 | zone | 43.73 | 42.169999999999995 | 0 | 1.56 |
| 2026-08-29 03:00:00.000000 | 61761 | zone | 44.53 | 42.17 | 0 | 2.36 |
| 2026-08-29 03:00:00.000000 | 61759 | zone | 44.02 | 42.17 | 0 | 1.85 |
| 2026-08-29 03:00:00.000000 | 61762 | zone | 50.07 | 42.17 | 4.74 | 3.16 |
| 2026-08-29 03:00:00.000000 | 61847 | zone | 41.62 | 42.169999999999995 | 0 | -0.55 |
| 2026-08-29 03:00:00.000000 | 61845 | zone | 43.18 | 42.17 | 0 | 1.01 |
| 2026-08-29 03:00:00.000000 | 61846 | zone | 39.13 | 42.17 | 0 | -3.04 |
| 2026-08-29 03:00:00.000000 | 61844 | zone | 42.29 | 42.16 | 0 | 0.13 |
| 2026-08-29 03:00:00.000000 | 24234 | generator | 44.53 | 42.17 | 0 | 2.36 |
| 2026-08-29 03:00:00.000000 | 24248 | generator | 44.15 | 42.17 | 0 | 1.98 |
| 2026-08-29 03:00:00.000000 | 24250 | generator | 44.23 | 42.16 | 0 | 2.07 |
| 2026-08-29 03:00:00.000000 | 24247 | generator | 44.15 | 42.17 | 0 | 1.98 |
| 2026-08-29 03:00:00.000000 | 24246 | generator | 44.15 | 42.17 | 0 | 1.98 |
| 2026-08-29 03:00:00.000000 | 24245 | generator | 44.15 | 42.17 | 0 | 1.98 |
| 2026-08-29 03:00:00.000000 | 24244 | generator | 44.15 | 42.17 | 0 | 1.98 |
| 2026-08-29 03:00:00.000000 | 24243 | generator | 44.53 | 42.17 | 0 | 2.36 |
| 2026-08-29 03:00:00.000000 | 24251 | generator | 44.23 | 42.16 | 0 | 2.07 |
| 2026-08-29 03:00:00.000000 | 24242 | generator | 44.53 | 42.17 | 0 | 2.36 |