Bring your own operational systems into the catalog — historians, EMS/SCADA, GIS, and market feeds — and query them next to the public grid data with the agent.
AVEVA PIOSI monarchGE Vernova GridOSSiemens Spectrum PowerSchneider EcoStruxureHitachi EnergyEsri ArcGISOATI
Data catalog
Every grid dataset behind Ask the Grid, published by ATG Data.
Prices, load, generation, congestion, outages, and the reference layers beneath them — each with its source, coverage, schema, and a live sample.
Bring your own operational systems into the catalog — historians, EMS/SCADA, GIS, and market feeds — and query them next to the public grid data with the agent.
AVEVA PIOSI monarchGE Vernova GridOSSiemens Spectrum PowerSchneider EcoStruxureHitachi EnergyEsri ArcGISOATI
Transmission constraints, shadow prices, interface limits, and congestion-rights results that show where the grid restricted power transfers and affected prices.
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.
5-minute (SCED)
16.3B2017
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.
5-minute (SCED)
1.3M2014
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.
hourly (DAM)
109.0K2014
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.
hourly (DAM)
92.4M2014
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.
hourly (DAM)
85.4K2017
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.
15-minute (RTPD)
5.57B2016
CAISORTD LMP (5-minute)ATG Data·CAISO·CAISO real-time dispatch locational marginal prices at five-minute resolution. Each pricing-node interval includes total LMP plus CAISO-published energy, congestion, loss, and greenhouse-gas components. These components explain the arithmetic composition of the price; identifying the exact binding facility responsible for a node's congestion component still requires direct constraint-to-node attribution evidence.
5-minute (RTD)
16.0B2016
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.
hourly (DAM)
1.71B2016
CAISOGHG Allowance Price IndexATG Data·CAISO·Daily greenhouse-gas allowance price index used as a CAISO market-clearing input. This is an input price, not a nodal LMP or the nodal GHG LMP component.
daily
2.2K2015
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.
5-minute
50.4M1999
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.
hourly (DAM)
3.9M1999
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.
5-minute
1.63B1999
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.
hourly (DAM)
146.5M1999
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.
hourly integrated RT
143.5M1999
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.
hourly integrated RT
3.8M1999
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.
hourly
232.0K2000
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.
15-minute RTC timestep
1.3M2026
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 Market Data.
5-minute
326.7M2026
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 Market Data.
hourly (settled ~18h lag)
2.28B1998
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.
hourly (day-ahead)
2.25B2000
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.
5-minute (RTBM) and hourly (Day-Ahead)
1.51B2014
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.
5-minute (RTBM)
8.07B2017
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.
hourly (day-ahead, published next day)
1.5M2026
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 published loss and congestion components; marginal energy is derived as LMP less those two 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 a current-hour comparison rather than a forward delivery curve.
1-minute snapshots; 5-minute RT and hourly market runs
15.3M2026
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.
5-minute real-time and hourly day-ahead/real-time
288.2M2019
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.
ISO-NE source publication
1.7K2026
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.
ISO-NE source publication
01970
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.
ISO-NE source publication
592022
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.
ISO-NE source publication
1.9K2020
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.
ISO-NE source publication
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.
ISO-NE source publication
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.
ISO-NE source publication
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.
ISO-NE source publication
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.
ISO-NE source publication
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.
ISO-NE source publication
7.0M2024
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.
ISO-NE source publication
52.2K2020
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.
ISO-NE source publication
8562018
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.
ISO-NE source publication
602018
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.
ISO-NE source publication
7442019
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.
ISO-NE source publication
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.
ISO-NE source publication
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.
ISO-NE source publication
01970
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.
ISO-NE source publication
3.6K2020
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.
ISO-NE source publication
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.
ISO-NE source publication
4612018
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.
5-minute (SCED)
990.5M2014
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.
5-minute (RTD)
16.0B2016
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 11 load zones plus four external 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.
5-minute
780.5M2015
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.
hourly
1.00B2018
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.
5-minute
1.74B2025
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.
hourly (DAM)
81.6M2014
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.
hourly (IFM)
1.22B2016
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 (the 11 load zones plus four external proxy buses) 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.
hourly
125.1M1999
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.
hourly
1.01B2018
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.
hourly
114.6M2014
CAISOWEIM Area Real-Time PricesATG Data·CAISO·CAISO's five-minute real-time prices at every location in atg.weim_locations, with the owning balancing area in ba. The same price columns as every atg.<iso>_prices_rt: price_usd_mwh with its energy, congestion, loss and greenhouse-gas components. About 4.1M rows per 30 days across 24 priced areas, from 2016.
5-minute (RTD)
217.1M2016
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.
Daily (gas day)
10.9M2015
USHenry 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.
AVEVA PI
OSI monarch
GE Vernova GridOS
Siemens Spectrum Power
Schneider EcoStruxure
Hitachi Energy
Esri ArcGIS
OATI
