Ask the Grid
Create free workspace

Prices

Real-time and day-ahead wholesale electricity prices across U.S. power markets, from system prices and hubs to zones, buses, nodes, and settlement points.

79 datasetspublished by ATG DataISONE21US reference14NYISO11CAISO9ERCOT8SPP7PJM5MISO4

Prices datasets
DatasetRows
AESO Daily Average Pool PriceATG Data·US reference·AESO's daily average, on-peak and off-peak pool price for each Alberta day.——
AESO Hourly Pool PriceATG Data·US reference·Alberta's hourly pool price, the settlement price for energy, with the 30-day rolling average AESO publishes beside it. Alberta's reference price for an hour.——
AESO Pool Price ForecastATG Data·US reference·AESO's own forecast of the hourly pool price. A forecast, not a day-ahead market: Alberta clears no day-ahead energy market.——
AESO System Marginal PriceATG Data·US reference·Alberta's system marginal price: the price of the last energy block dispatched, with the volume at that price. A step series: each row holds from its event_time until the next row. Alberta has one system price; there are no nodal or zonal prices and no day-ahead market.——
ISO-NEAMSATG Data·ISONE·ISO-NE's published AMS source feed. This catalog page exposes the physical schema, coverage, and latest source rows without inventing a normalized grain for publisher-shaped snapshot fields. Use the documented key and event time when comparing revisions or vintages.1.7K2026
CAISOCAISO Day-Ahead PricesATG Data·CAISO·CAISO day-ahead locational marginal prices, one row per interval and location. 1.21B rows, 2016-01 to the next delivery day. Carries price_usd_mwh only. The component columns exist in the raw CAISO day-ahead feed but are entirely NULL in it, so this table carries no decomposition rather than four empty columns. Locations are node (26k — including the TH_ trading hubs such as TH_SP15_GEN-APND; CAISO has no 'hub' kind), interface (the ties), zone (6 aggregates only); location_id joins atg.caiso_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.1.23B2016
CAISOCAISO Real-Time PricesATG Data·CAISO·CAISO real-time locational marginal prices, one row per interval and location. 15.76B rows, 2016-01 to now. Carries price_usd_mwh plus energy_usd_mwh, congestion_usd_mwh, loss_usd_mwh and ghg_usd_mwh — CAISO is the only market here that publishes a greenhouse-gas component. Locations are node (26k — including the TH_ trading hubs such as TH_SP15_GEN-APND; CAISO has no 'hub' kind), interface (the ties), zone (6 aggregates only); location_id joins atg.caiso_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.16.1B2016
CENACE Nodal Prices (PML)ATG Data·US reference·Hourly locational marginal prices (precios marginales locales) at each of CENACE's roughly 2,600 pricing nodes in all three systems, with energy, losses and congestion components. Nodes are named in atg.cenace_locations.——
CENACE Zonal PricesATG Data·US reference·Hourly load-zone prices for Baja California (Tijuana, Mexicali, Ensenada, San Luis Rio Colorado), Baja California Sur and the mainland's zones, day-ahead (MDA) from 2016 and real-time (MTR) from 2017, with energy, losses and congestion components.19.4M2016
NYISOCoordinated Transaction Scheduling PricesATG Data·NYISO·NYISO Coordinated Transaction Scheduling prices by generator PTID and RTC timestep, including NYISO generator LBMP and the paired external RTO CTS price for PJM / ISO-NE coordination analysis.1.3M2026
ISO-NEDaily Offer Threshold PriceATG Data·ISONE·ISO-NE's published Daily Offer Threshold Price source feed. This catalog page exposes the physical schema, coverage, and latest source rows without inventing a normalized grain for publisher-shaped snapshot fields. Use the documented key and event time when comparing revisions or vintages.01970
ERCOTDAM Settlement Point PricesATG Data·ERCOT·Hourly settlement point prices cleared in the ERCOT Day-Ahead Market, covering every settlement point in Texas (load zones, hubs, and resource nodes). These are the prices at which energy is bought and sold a day in advance of delivery, set the afternoon before each operating day. They are the day-ahead counterpart to real-time locational prices, and the gap between the two reflects how the market expected conditions to differ from how they actually unfolded. Traders use them to position and hedge, generators and loads use them to plan commitments, and researchers use them to study how congestion and scarcity show up across the grid.92.7M2014
ERCOTDAM System LambdaATG Data·ERCOT·ERCOT's hourly day-ahead system lambda, the system-wide marginal energy component in the cleared Day-Ahead Market. For the same delivery hour and settlement point, day-ahead SPP minus DAM system lambda is the point's cleared day-ahead congestion component. Paired with SCED system lambda and real-time LMP, it supports day-ahead-versus-real-time congestion basis by point. It does not identify a binding constraint's effect on a point without direct attribution evidence.109.3K2014
ERCOTDAM Total Energy SoldATG Data·ERCOT·This dataset reports the total energy sold in ERCOT's Day-Ahead Market, in megawatt-hours, for each delivery hour. It represents the system-wide quantity of energy that cleared the day-ahead auction, where buyers and sellers commit to next-day positions before real-time operations. The hourly shape across a day shows how much of expected Texas demand is locked in financially a day ahead, and tracking it over time reveals shifts in day-ahead market participation and how forward commitments line up against eventual real-time conditions. The figures come from ERCOT report NP4-193-CD.85.8K2017
SPPDay-Ahead Bus LMPATG Data·SPP·Cleared hourly day-ahead bus prices and MEC/MCC/MLC components, preserving BAA and the native GMT interval end. The DA bus archive exists separately from settlement-location LMP. A component does not identify the causing constraint. Complete views require a matching receipt and mirrored row count; empty results are unknown coverage. Raw sources retain publication history internally.2.9M2026
MISODay-Ahead Ex-Post LMPATG Data·MISO·MISO's day-ahead ex-post locational marginal prices for the full nodal set of roughly 2,600 generator nodes, load zones, hubs, and interfaces, one row per node per operating hour. Each row carries total LMP with its congestion (mcc) and marginal-loss (mlc) components in dollars per MWh; the energy component is lmp less mcc and mlc. event_time is hour-beginning UTC. These are the day-ahead prices a node settles at, published the morning after the operating day and restated when MISO re-runs settlement, so read the latest load per node and hour. A congestion component does not by itself identify which constraint bound. Unlike miso.live_lmp, a consolidated snapshot of 325 locations, this covers every node and is addressable by market date.388.8M2005
NYISODay-Ahead Generator LBMPATG Data·NYISO·NYISO hourly day-ahead generator-level LBMP by generator PTID, with energy, congestion, and loss components. It is the generator-level day-ahead companion to zonal day-ahead LBMP.146.9M1999
PJMDay-Ahead Hourly LMPATG Data·PJM·Cleared day-ahead locational marginal prices for each PJM pricing node by delivery hour, with total LMP and its system-energy, congestion, and marginal-loss components in dollars per MWh. The table supports the posted next-day hourly curve, day-ahead-to-real-time basis, and node-level component attribution. A congestion component does not by itself identify which facility is expected to bind or establish a node-to-constraint relationship. Source: PJM Market Data.2.26B2000
CAISODay-Ahead LMPATG Data·CAISO·Hourly locational marginal prices from CAISO's day-ahead market for pricing nodes across the California ISO footprint. These are cleared market outcomes for future delivery, not forecasts. Comparing the exact same delivery hour and pricing node with five-minute RTD prices shows day-ahead versus real-time divergence. The official source is CAISO OASIS.1.71B2016
SPPDay-ahead market-clearing reportATG Data·SPP·SPP's Day-ahead market-clearing report. Each row preserves a publisher record, workbook row, or report document with its source member and row index. Source timestamps, units, geographic scope, and revision qualifiers are retained in record_json; event_time is collection time; completed_at is when the entire document became available.4902026
NYISODay-Ahead Zonal LBMPATG Data·NYISO·Hourly day-ahead locational-based marginal prices (LBMP) for NYISO load zones. These prices clear before the operating day and provide the day-ahead companion to real-time zonal LBMP, useful for DA/RT spreads, congestion expectations, and load-zone market analysis.3.9M1999
ISO-NEDR Threshold PriceATG Data·ISONE·ISO-NE's published DR Threshold Price source feed. This catalog page exposes the physical schema, coverage, and latest source rows without inventing a normalized grain for publisher-shaped snapshot fields. Use the documented key and event time when comparing revisions or vintages.592022
ERCOTERCOT Day-Ahead PricesATG Data·ERCOT·ERCOT day-ahead locational marginal prices, one row per interval and location. 66.7M rows, 2017-01 to the next delivery day. Carries price_usd_mwh plus energy_usd_mwh and congestion_usd_mwh, with energy taken from ERCOT's DAM system lambda. No loss component: ERCOT does not publish one. Locations are node, zone, hub, interface; location_id joins atg.ercot_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.82.2M2014
ERCOTERCOT Real-Time PricesATG Data·ERCOT·ERCOT real-time locational marginal prices, one row per interval and location. 979.1M rows, 2014-05 to now. Carries price_usd_mwh plus energy_usd_mwh and congestion_usd_mwh. ERCOT publishes no marginal-loss component and this table has no loss column: energy is ERCOT's own SCED system lambda and congestion is price minus lambda, an exact identity rather than an estimate. Locations are node (resource nodes), zone (load zones), hub, interface (the four DC ties); location_id joins atg.ercot_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.996.8M2014
ISO-NEFRM DTPATG Data·ISONE·ISO-NE's published FRM DTP source feed. This catalog page exposes the physical schema, coverage, and latest source rows without inventing a normalized grain for publisher-shaped snapshot fields. Use the documented key and event time when comparing revisions or vintages.1.9K2020

About prices data

These datasets cover locational marginal prices (LMPs) and their energy, congestion, and loss components at the locations each market publishes. Use them to compare day-ahead and real-time outcomes, trace price separation across the grid, and pair power prices with the natural-gas benchmarks that inform generators’ marginal fuel costs.