Overview
PJM real-time locational marginal prices, one row per interval and location. 991.1M rows, 2018-01 to now. Carries price_usd_mwh plus energy_usd_mwh, congestion_usd_mwh and loss_usd_mwh. Locations are load, generator, aggregate, bus, interface, zone, hub; location_id joins atg.pjm_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 real-time 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/pjm_prices_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.
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-28 02:00:00.000000 | 112586095 | load | 60.87 | 53.66 | 8.01 | -0.8 |
| 2026-08-28 02:00:00.000000 | 112586097 | load | 61.03 | 53.66 | 7.98 | -0.62 |
| 2026-08-28 02:00:00.000000 | 112586099 | load | 61.03 | 53.66 | 7.98 | -0.62 |
| 2026-08-28 02:00:00.000000 | 112586101 | load | 60.88 | 53.66 | 8.05 | -0.83 |
| 2026-08-28 02:00:00.000000 | 112586103 | load | 60.88 | 53.66 | 8.05 | -0.83 |
| 2026-08-28 02:00:00.000000 | 112586105 | load | 59.65 | 53.66 | 7.2 | -1.21 |
| 2026-08-28 02:00:00.000000 | 112586107 | load | 61.06 | 53.66 | 8.07 | -0.67 |
| 2026-08-28 02:00:00.000000 | 112586109 | load | 60.96 | 53.66 | 8 | -0.69 |
| 2026-08-28 02:00:00.000000 | 112586111 | load | 112.45 | 53.66 | 60.4 | -1.6 |
| 2026-08-28 02:00:00.000000 | 112586113 | load | 112.45 | 53.66 | 60.4 | -1.6 |
| 2026-08-28 02:00:00.000000 | 112586115 | load | 112.45 | 53.66 | 60.4 | -1.6 |
| 2026-08-28 02:00:00.000000 | 112586117 | load | 111.36 | 53.66 | 59.3 | -1.6 |
| 2026-08-28 02:00:00.000000 | 112586119 | load | 111.31 | 53.66 | 59.3 | -1.65 |
| 2026-08-28 02:00:00.000000 | 112586121 | load | 99.33 | 53.66 | 46.73 | -1.06 |
| 2026-08-28 02:00:00.000000 | 112586123 | load | 99.33 | 53.66 | 46.73 | -1.06 |
| 2026-08-28 02:00:00.000000 | 112586125 | load | 99.19 | 53.66 | 46.73 | -1.19 |
| 2026-08-28 02:00:00.000000 | 112586235 | generator | 71.62 | 53.66 | 19.33 | -1.37 |
| 2026-08-28 02:00:00.000000 | 112586129 | load | 99.21 | 53.66 | 46.73 | -1.18 |
| 2026-08-28 02:00:00.000000 | 112586131 | load | 99.21 | 53.66 | 46.73 | -1.18 |
| 2026-08-28 02:00:00.000000 | 112586147 | generator | 26.13 | 53.66 | -27.63 | 0.1 |
| 2026-08-28 02:00:00.000000 | 112586153 | generator | 27.24 | 53.66 | -26.72 | 0.29 |
| 2026-08-28 02:00:00.000000 | 112586127 | load | 99.19 | 53.66 | 46.73 | -1.19 |
| 2026-08-28 02:00:00.000000 | 112586207 | generator | 99.19 | 53.66 | 46.73 | -1.19 |
| 2026-08-28 02:00:00.000000 | 112586205 | generator | 99.33 | 53.66 | 46.73 | -1.06 |
| 2026-08-28 02:00:00.000000 | 112586189 | generator | 67.87 | 53.66 | 12.39 | 1.82 |