Ask the Grid
Open live grid

Prices

Locational marginal prices and their system-wide components — real-time and day-ahead, by node, bus, hub, and zone — across every market in the catalog, plus the natural-gas benchmarks that set generators' marginal fuel cost.

55 datasetspublished by ATG DataISONE21NYISO10ERCOT8CAISO5PJM5SPP4MISO1US reference1

Prices datasets
DatasetRows
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.21B2016
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.15.8B2016
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.1M2026
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.77.1M2017
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.84.8K2017
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.84.7K2017
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.161.1M1999
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 Data Miner 2.1.03B2018
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 the prices cleared before the operating day, reflecting the market's expected supply, demand, congestion, and losses for each delivery hour. Comparing this dataset with real-time RTPD prices shows how expectations diverged from actual grid conditions, which is useful for analyzing basis, congestion risk, renewable forecast error, and day-ahead versus real-time market performance. The official source is CAISO OASIS.1.69B2016
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.572022
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.66.9M2017
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.982.1M2014
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
CAISOFuel Region Gas PricesATG Data·CAISO·CAISO's daily natural-gas price for each of its fuel regions, in $/MMBtu. CAISO posts this as FUEL REGION | GAS INDEX | TRANSPORT | TOTAL, and the value here is that total: a published gas index plus a transport adder, i.e. the delivered cost of gas to that region, not a hub spot assessment. It is the number CAISO uses to reference and floor gas-fired energy bids, so it is the fuel-cost input underneath thermal offer behavior across the West. 201 fuel regions are currently active across 27 electric subregions, reaching well beyond California: Waha and El Paso Permian in West Texas, Opal, Kern River, Cheyenne, CIG and the San Juan points in the Rockies, Malin, Stanfield, Northwest Sumas and Kingsgate in the Pacific Northwest, Alberta AECO in Canada, and the SoCal Citygate and PG&E Citygate burner-tip regions in California. Receipt-point regions such as Waha (FRWHA1-3), El Paso Permian (FREPP1-4), Opal, Malin and Sumas track the underlying published index closely, because their transport adder is small; citygate regions are burner-tip costs and spread widely, so they are not interchangeable with a hub price — on 2026-08-20 the 40 region ids named SoCal Citygate ranged from 4.43 to 8.15 $/MMBtu on the same day. Region ids ending in GHG carry a California carbon-allowance adder on top and are a different quantity again. Negative prices are real and are concentrated in the takeaway-constrained Permian regions: 0.97% of rows are below zero, to a minimum of -10.51 $/MMBtu. Rows are stamped hourly, 24 per region per gas day, but the price is constant across a gas day, and the gas day is the America/Los_Angeles calendar date — it steps at Pacific midnight, so daily rollups must use toDate(event_time, 'America/Los_Angeles'). The current gas day is partial until the next 14:30 UTC pull, though its price is already complete. History runs from 2015-02-01 and is continuous and complete from 2026-02-01 onward; before that date it covers 1,972 of 4,018 days in whole-month blocks (February through April, June, September and November of each year), so a pre-2026 average over an arbitrary window is an average over the months that are present, not over the period requested. Hub attribution is INFERRED from CAISO's region coding, not published: CAISO's monthly fuel-region posting lists region ids with their index, transport and total and no hub names at all, and FRWHA does not appear in it — so 'Waha' here reads the id, corroborated by the price sitting where Waha sits against Henry Hub, rather than by a CAISO mapping. Treat a region as the delivered cost CAISO assigns to it; do not cite it as a hub assessment. This dataset is FUEL-COST CONTEXT, not market settlement data, and is queryable from every active grid scope: a question asked under ERCOT about West Texas gas cost answers from the Waha-region ids here, said as delivered fuel cost. The official source is CAISO OASIS report PRC_FUEL.10.8M2015
ISO-NEHB Annual FTR AuctionATG Data·ISONE·ISO-NE's published HB Annual FTR Auction 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.169.4K2019
ISO-NEHB DA ARD BidATG Data·ISONE·ISO-NE's published HB DA ARD Bid 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.36.9K2022
ISO-NEHB DA Energy OfferATG Data·ISONE·ISO-NE's published HB DA Energy Offer 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.6.1M2024
ISO-NEHB Monthly FTR AuctionATG Data·ISONE·ISO-NE's published HB Monthly FTR Auction 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.6M2020
ISO-NEHB RT ARD BidATG Data·ISONE·ISO-NE's published HB RT ARD Bid 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.1M2022
ISO-NEHB RT Energy OfferATG Data·ISONE·ISO-NE's published HB RT Energy Offer 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.6.9M2024
Henry Hub Natural Gas Spot PriceATG Data·US reference·The daily Henry Hub natural gas spot price in $/MMBtu, published by the U.S. Energy Information Administration as series RNGWHHD. Henry Hub is the national benchmark that other US gas is quoted against, and it is the reference point for gas-fired generation cost in every market, so it is the denominator for basis work and the anchor for any implied-heat-rate or spark-spread calculation. The series runs from 1997-01-07 to the present on trading days only — there are no weekend or holiday rows, and a missing weekday is a non-trading day rather than a gap. It publishes on a short delay, typically two to ten days behind the trade date, so it answers questions about yesterday and last month rather than about right now; pair it with a live market feed for same-day work. This is a national reference series with a single hub, so it carries no market or locational dimension and cannot on its own establish a regional gas price — a delivered regional cost needs a regional series. The basis_usd_mmbtu column is structurally zero for every row and carries no information; it is not a basis series and must not be read as one. A national reference with no market dimension, queryable from every active grid scope. When the asked-for date returns no rows, answer with the latest published print and its date — the lag is the fact to report, not a reason to stop. The official source is the U.S. EIA.7.4K1997
NYISOIntegrated Real-Time Generator LBMPATG Data·NYISO·NYISO settlement-style hourly integrated real-time LBMP for generator PTIDs. Use it when hourly generator-level price settlement is more appropriate than raw five-minute LBMP.159.7M1999
NYISOIntegrated Real-Time Zonal LBMPATG Data·NYISO·NYISO settlement-style hourly integrated real-time LBMP for load zones. It complements the raw five-minute zonal LBMP feed used by the live map.3.8M1999
MISOLive Consolidated LMPATG Data·MISO·MISO's public consolidated price snapshot for 325 official hubs, load-zone nodes, generator nodes, and interfaces. It carries five-minute real-time, hourly integrated real-time, day-ahead ex-ante, and day-ahead ex-post runs plus source price components. event_time/ref_id identify when the snapshot was requested; raw_interval is the market-run delivery label, so a day-ahead snapshot is not a historical delivery-hour curve.6.2M2026
ERCOTLMP by BusATG Data·ERCOT·Locational marginal prices for each electrical bus in ERCOT, produced by Security Constrained Economic Dispatch (SCED) roughly every five minutes. This is the finest public spatial view of observed ERCOT price variation and supports bus-level ranking, history, and basis analysis. A bus price or price spread alone does not identify a binding constraint, congestion component, or electrical relationship to another entity; those claims require direct component or attribution evidence.16.2B2017
ERCOTLMP by Settlement PointATG Data·ERCOT·Locational marginal prices from ERCOT's real-time market, published every five minutes by Security Constrained Economic Dispatch (SCED) for resource nodes, load zones, and trading hubs. This table supports observed price levels, rankings, volatility, and basis between settlement points. Total-LMP differences do not identify a congestion component, binding facility, shift factor, or physical topology relationship, so they cannot establish why two points separated without matched attribution data. The official source is ERCOT report NP6-788-CD (Settlement Point Prices at Resource Nodes, Hubs and Load Zones).1.19B2014
SPPLocational Marginal Prices by BusATG Data·SPP·Real-time locational marginal prices at the individual electrical bus, with total LMP and its marginal energy, congestion, and loss components. This is SPP's finest-grained public price view, well below the settlement-location tier, and is the table to use when a question concerns a specific bus rather than a settlement point. Real-time only: SPP publishes no day-ahead equivalent at bus granularity on this feed.1.56B2017
SPPLocational Marginal Prices by Settlement LocationATG Data·SPP·Locational marginal prices for SPP settlement locations, carrying total LMP and its marginal energy (mec), congestion (mcc), and loss (mlc) components. Covers both the five-minute real-time balancing market and the hourly day-ahead market, distinguished by market_run ('rt_5min' and 'da_hourly'). Around 1,600 settlement locations report on the live feed. Note that location_name and location_type are published empty on this feed, so a location cannot be classified as hub, generator, or interface from this table alone. SPP's two market trading hubs are SPPNORTH_HUB and SPPSOUTH_HUB; other identifiers containing 'HUB' are participant settlement aggregates, not market hubs.496.1M2017
ISO-NEMonthly Asset NCPCATG Data·ISONE·ISO-NE's published Monthly Asset NCPC 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.51.5K2020
ISO-NEMonthly LMP IndexATG Data·ISONE·ISO-NE's published Monthly LMP Index 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.8472018
ISO-NEMonthly PERATG Data·ISONE·ISO-NE's published Monthly PER 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.602018
NYISONYISO Day-Ahead PricesATG Data·NYISO·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.124.6M1999
NYISONYISO Real-Time PricesATG Data·NYISO·NYISO real-time locational marginal prices, one row per interval and location. 771.3M rows, 2015-01 to now. Carries price_usd_mwh plus energy_usd_mwh, congestion_usd_mwh and loss_usd_mwh. NYISO publishes LBMP with loss and congestion, so energy is derived as lmp - loss + congestion, following NYISO's own sign convention. Locations are zone (the 15 NYISO zones and proxy buses) and generator (758 units); 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 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.771.9M2015
ISO-NEPER HourlyATG Data·ISONE·ISO-NE's published PER Hourly 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.7442019
PJMPJM Day-Ahead PricesATG Data·PJM·PJM day-ahead locational marginal prices, one row per interval and location. 1.00B rows, 2018-01 to the next delivery day. 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 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.00B2018
PJMPJM Real-Time PricesATG Data·PJM·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.993.9M2018
ISO-NEPRD Clearing DAATG Data·ISONE·ISO-NE's published PRD Clearing DA 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.4082018
ISO-NERCP Hourly FinalATG Data·ISONE·ISO-NE's published RCP Hourly Final 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
ISO-NERCP Hourly PrelimATG Data·ISONE·ISO-NE's published RCP Hourly Prelim 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
PJMReal-Time 5-Minute LMP (Unverified)ATG Data·PJM·Locational marginal prices from PJM's real-time energy market, published every five minutes for each pricing node (pnode) before settlement verification. Each row carries total LMP plus congestion and marginal-loss components in dollars per MWh. Components support node-level price decomposition, but price differences do not identify a named binding facility or prove topology. This is the freshest PJM price feed; use the settled hourly feed for the verified record published roughly 18 hours later. Point classes span transmission zones, trading hubs, external interfaces, and aggregate nodes. Source: PJM Data Miner 2.217.6M2026
ISO-NEReal-Time and Day-Ahead LMPATG Data·ISONE·ISO-NE locational marginal prices for physical PNodes, eight load zones, the Internal Hub, and external nodes. Filter market_run and scope before use; lmp_total is accompanied by energy, congestion, and loss components.36.1M2026
NYISOReal-Time Generator LBMPATG Data·NYISO·NYISO real-time five-minute generator-level LBMP by generator PTID, with energy, congestion, and loss components. Use this for generator-node market analysis where the public zonal LBMP map is too coarse.2.26B1999
PJMReal-Time Hourly LMP (Verified)ATG Data·PJM·PJM's verified real-time locational marginal prices at hourly granularity for every pricing node, with total LMP and its system-energy, congestion, and marginal-loss components in dollars per MWh. These are the settled, authoritative real-time prices — published on roughly an 18-hour lag behind the operating hour — and history reaches back to 2018, making this the table for real-time price history, day-over-day basis, and volatility studies. For prices in the current hour use the unverified 5-minute feed instead. Source: PJM Data Miner 2.1.01B2018
NYISOReal-Time Zonal LBMPATG Data·NYISO·Real-time locational-based marginal prices (LBMP) for NYISO's public load-zone pricing locations, published at five-minute resolution with energy, congestion, and loss components. The map uses these zonal LBMP locations for NYISO's live price dots, with IDs matching NYISO MIS zone names such as WEST, CAPITL, N.Y.C., and LONGIL.50.3M1999
NYISOReference Bus LBMPATG Data·NYISO·NYISO reference-bus LBMP for NYISO_LBMP_REFERENCE / PTID 24008. This gives the system reference price used for normalizing zonal and generator LBMP components.240.9K2000
CAISORTPD LMP (15-minute)ATG Data·CAISO·Locational marginal prices from CAISO's real-time pre-dispatch market, published at 15-minute resolution for pricing nodes across the California ISO footprint. Each row carries total LMP and its energy, congestion, and loss components for one node and interval. A non-null component supports attribution of that portion of the node price, but neither total LMP nor the component alone names the binding facility or proves a topology relationship; direct constraint attribution is still required. The official source is CAISO OASIS.5.52B2016
ERCOTSCED System LambdaATG Data·ERCOT·ERCOT's five-minute real-time system lambda, the system-wide marginal energy component of SCED LMP. For a settlement point or electrical bus in the same SCED interval, LMP minus system lambda is the point's congestion component; ERCOT LMP has no marginal-loss component. This supports point-level congestion rankings and history when joined interval by interval to real-time LMP. It does not identify which binding constraint affected a point without shift-factor or other direct attribution evidence.1.3M2014
ISO-NESeasonal Peak HourATG Data·ISONE·ISO-NE's published Seasonal Peak Hour 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.3.6K2020
SPPSPP Day-Ahead PricesATG Data·SPP·SPP day-ahead locational marginal prices, one row per interval and location. 92.8M rows, 2017-01 to the next delivery day. Carries price_usd_mwh plus energy_usd_mwh, congestion_usd_mwh and loss_usd_mwh. Locations are node and hub only; location_id joins atg.spp_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.93.1M2017
SPPSPP Real-Time PricesATG Data·SPP·SPP real-time locational marginal prices, one row per interval and location. 1.64B rows, 2025-01 to now. Carries price_usd_mwh plus energy_usd_mwh, congestion_usd_mwh and loss_usd_mwh. Locations are bus (10,457), node (1,983) and hub (2); location_id joins atg.spp_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.1.67B2025
ISO-NEVirtual Proxy DAATG Data·ISONE·ISO-NE's published Virtual Proxy DA 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.2.9M2020
ISO-NEWeekly LMP IndexATG Data·ISONE·ISO-NE's published Weekly LMP Index 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.4342018