Day-Ahead LMP

Hourly locational marginal prices from CAISO's day-ahead market for pricing nodes across the California ISO footprint.

Prices data

Download data Open on map

Native record

pricing node x day-ahead delivery hour

hourly (DAM) publication cadence

Evidence

Cleared day-ahead market

A market outcome, not a physical observation

In Ask the Grid

PNode prices on the CAISO map

Values for the live grid surface

Overview

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.

Query contract

Preserve one canonical row per (event_time, node) before aggregating.

Analysis rules

Group only after preserving the declared grain: event_time, node.

Related analysis

day-ahead versus real-time nodal price · Use query_data on each dataset with the same pricing node, ISO-local day, event_time bucket='hour', and ascending order. The returned delivery-hour axes then align for compute.

Interpretation

Day-ahead price is a market outcome for future delivery, not an observation of real-time conditions.
CAISO publishes the next day's day-ahead prices around 1 PM Pacific the day before delivery. Before then, the next day's prices have not been published yet.

Schema9

Column

Type

event_timeDateTime64(6, 'UTC')

market_runLowCardinality(String)

nodeLowCardinality(String)

pnode_idNullable(String)

lmp_totalNullable(Float64)

energy_componentNullable(Float64)

congestion_componentNullable(Float64)

loss_componentNullable(Float64)

ingested_atDateTime64(6, 'UTC')

Sample data

event_time	market_run	node	pnode_id	lmp_total	energy_component	congestion_component	loss_component	ingested_at
2026-09-30 06:00:00.000000	dam_hourly	ZP26SLAK_5_N001	ZP26SLAK_5_N001	50.33894	42.82772	0	0.7537	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	ZONDWIND_6_N006	ZONDWIND_6_N006	48.62329	42.82772	0	-0.96195	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	ZONDWIND_6_N005	ZONDWIND_6_N005	48.62329	42.82772	0	-0.96195	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	ZONDWIND_6_N004	ZONDWIND_6_N004	48.62329	42.82772	0	-0.96195	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	ZONDWIND_6_N003	ZONDWIND_6_N003	48.62329	42.82772	0	-0.96195	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	ZONDWIND_6_N002	ZONDWIND_6_N002	48.62329	42.82772	0	-0.96195	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	ZONDWIND_6_N001	ZONDWIND_6_N001	48.62329	42.82772	0	-0.96195	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	ZONDWD_6_B1	ZONDWD_6_B1	48.44291	42.82772	-0.24484	-0.89749	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	ZEROWST_7_N002	ZEROWST_7_N002	42.74898	42.82772	-7.2379	0.40164	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	ZENO_6_N002	ZENO_6_N002	106.6104	42.82772	55.79544	1.22971	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	ZENO_6_N001	ZENO_6_N001	106.6104	42.82772	55.79544	1.22971	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	ZANKER_1_N003	ZANKER_1_N003	75.32458	42.82772	25.15423	0.58511	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	ZANKER_1_N001	ZANKER_1_N001	75.32458	42.82772	25.15423	0.58511	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	ZANJA_1_N003	ZANJA_1_N003	48.82783	42.82772	-0.85163	0.09421	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	ZAMORA_1_N001	ZAMORA_1_N001	48.09085	42.82772	-0.24484	-1.24955	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	ZAMORA_1_LN001	ZAMORA_1_LN001	48.09085	42.82772	-0.24484	-1.24955	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	ZACA_1_N001	ZACA_1_N001	50.3439	42.82772	0	0.75865	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	YUBAGOLD_6_N001	YUBAGOLD_6_N001	48.75952	42.82772	-0.25549	-0.57023	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	YUBACTY_7_B1	YUBACTY_7_B1	48.40251	42.82772	-0.25549	-0.92724	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	YUBACITY_6_N010	YUBACITY_6_N010	48.40251	42.82772	-0.25549	-0.92724	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	YREKA_LNODED3	YREKA_LNODED3	43.31747	42.82752	-0.29807	0.78803	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	YREKA_LNODED2	YREKA_LNODED2	43.31747	42.82752	-0.29807	0.78803	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	YREKA_LNODED1	YREKA_LNODED1	43.31747	42.82752	-0.29807	0.78803	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	YREKA_LNODE76	YREKA_LNODE76	43.29606	42.82752	-0.29807	0.76661	2026-09-29 07:08:35.767391
2026-09-30 06:00:00.000000	dam_hourly	YOUNGSBA_LNODE45	YOUNGSBA_LNODE45	42.09493	42.82752	-0.33001	-0.40258	2026-09-29 07:08:35.767391

Coverage

Showing the last 2,290 days of a 3,926-day history (Jan 1, 2016 → Sep 30, 2026). This dataset holds 1.71B rows — too many to count day by day on every visit — so the calendar and the figures below cover the window from Jun 24, 2020.

100.0% complete0 gap days2,290 days with data

Show coverage history

Coverage: 100.0%Days with data: 2,290Gaps: 0

2026

2025

2024

2023

2022

2021

2020

gaplessmore

Related prices data

Related prices data
Dataset	Description
CAISO Day-Ahead PricesCAISO · hourly (IFM)	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.
CAISO Real-Time PricesCAISO · 5-minute (RTD)	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.
Fuel Region Gas PricesCAISO · Daily (gas day)	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.
GHG Allowance Price IndexCAISO · daily	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.