Dataframe: CAISO:caiso_lmp_day_ahead_hourly - CAISO LMP Day-Ahead Hourly

Description

Hourly locational marginal prices (LMPs) from the CAISO Day-Ahead Market, the auction held the day before delivery that sets one price per hour per grid location. The LMP is decomposed into its energy, congestion, loss, and greenhouse-gas components.

This dataset is the day-ahead (DAM) leg for the project’s spread work: DAM-RT spreads against the real-time LMP datasets, location spreads between trading hubs, time spreads within an operating day, and TBx (top-minus-bottom x hours) storage-value calculations.

Data Dictionary

• interval_start_utc: datetime64[ns] Interval start, UTC (naive).

• interval_end_utc: datetime64[ns] Interval end = start + 1 hour, UTC (naive).

• market: str Market identifier; DAY_AHEAD_HOURLY in all sampled rows.

• location: str Node, AP node, or trading hub ID (long format, one location per row).

• location_type: str Location category, e.g. Node or AP Node. Trading hubs use TH_* APNode IDs.

• lmp: float64 Locational marginal price, $/MWh. Identity: lmp = energy + congestion + loss + ghg.

• energy: float64 System marginal energy component, $/MWh.

• congestion: float64 Congestion component, $/MWh.

• loss: float64 Loss component, $/MWh.

• ghg: float64 Greenhouse-gas component, $/MWh. Zero for locations outside California.

Notes

• The LMP decomposition identity holds exactly: lmp = energy + congestion + loss + ghg.

• Coverage: the five hub APNodes - NP15 (TH_NP15_GEN-APND), SP15 (TH_SP15_GEN-APND), ZP26 (TH_ZP26_GEN-APND), PACE (TH_PACE_GEN-APND), PACW (TH_PACW_GEN-APND) - with history cached from 2023-05-11, the OASIS retention floor, onward.

• PACE and PACW (PacifiCorp East/West BAAs, WEIM/EDAM) begin exactly at midnight Pacific on 2026-05-01. That is the market go-live date for those hub APNodes, not a data gap.

• Timestamps are stored as naive UTC. Any local-time (US/Pacific) view is computed at analysis time, never stored on disk.

Data Preview

Rows: 92,349  |  Columns: 10  |  Cache: data/opensource/caiso_lmp_day_ahead_hourly.parquet

Sample rows

First and latest 5 rows by interval_start_utc.

interval_start_utc	interval_end_utc	market	location	location_type	lmp	energy	congestion	loss	ghg
2023-05-11 07:00	2023-05-11 08:00	DAY_AHEAD_HOURLY	TH_ZP26_GEN-APND	Trading Hub	8.815	9.281	0.0	-0.466	0.0
2023-05-11 07:00	2023-05-11 08:00	DAY_AHEAD_HOURLY	TH_SP15_GEN-APND	Trading Hub	9.049	9.281	0.0	-0.232	-0.0
2023-05-11 07:00	2023-05-11 08:00	DAY_AHEAD_HOURLY	TH_NP15_GEN-APND	Trading Hub	8.912	9.281	0.0	-0.368	-0.0
2023-05-11 08:00	2023-05-11 09:00	DAY_AHEAD_HOURLY	TH_ZP26_GEN-APND	Trading Hub	6.788	7.129	0.0	-0.342	0.0
2023-05-11 08:00	2023-05-11 09:00	DAY_AHEAD_HOURLY	TH_SP15_GEN-APND	Trading Hub	6.954	7.129	0.0	-0.175	-0.0
…	…	…	…	…	…	…	…	…	…
2026-08-27 06:00	2026-08-27 07:00	DAY_AHEAD_HOURLY	TH_NP15_GEN-APND	Trading Hub	56.341	55.758	-9.463	-2.288	12.334
2026-08-27 06:00	2026-08-27 07:00	DAY_AHEAD_HOURLY	TH_PACE_GEN-APND	AP Node	60.347	62.326	0.085	-2.063	0.0
2026-08-27 06:00	2026-08-27 07:00	DAY_AHEAD_HOURLY	TH_PACW_GEN-APND	AP Node	48.277	55.758	-6.84	-0.641	0.0
2026-08-27 06:00	2026-08-27 07:00	DAY_AHEAD_HOURLY	TH_SP15_GEN-APND	Trading Hub	72.623	55.758	7.085	-2.553	12.334
2026-08-27 06:00	2026-08-27 07:00	DAY_AHEAD_HOURLY	TH_ZP26_GEN-APND	Trading Hub	54.455	55.758	-10.722	-2.914	12.334

Column summary

Column	Dtype	Nulls	Min	Max
interval_start_utc	Datetime[ns]	0	2023-05-11 07:00	2026-08-27 06:00
interval_end_utc	Datetime[ns]	0	2023-05-11 08:00	2026-08-27 07:00
market	String	0	DAY_AHEAD_HOURLY	DAY_AHEAD_HOURLY
location	String	0	TH_NP15_GEN-APND	TH_ZP26_GEN-APND
location_type	String	0	AP Node	Trading Hub
lmp	Float64	0	-68.009	1247.634
energy	Float64	0	-42.086	1215.39
congestion	Float64	0	-289.548	193.603
loss	Float64	0	-70.703	4.027
ghg	Float64	0	-0.0	33.399

DataFrame Glimpse

Rows: 92349
Columns: 10
$ interval_start_utc <datetime[ns]> 2026-08-27 06:00:00
$ interval_end_utc   <datetime[ns]> 2026-08-27 07:00:00
$ market                      <str> 'DAY_AHEAD_HOURLY'
$ location                    <str> 'TH_ZP26_GEN-APND'
$ location_type               <str> 'Trading Hub'
$ lmp                         <f64> 54.45514
$ energy                      <f64> 55.75814
$ congestion                  <f64> -10.72246
$ loss                        <f64> -2.91433
$ ghg                         <f64> 12.33379

Dataframe Manifest

Dataframe Name	CAISO LMP Day-Ahead Hourly
Dataframe ID	caiso_lmp_day_ahead_hourly
Data Sources	CAISO OASIS (PRC_LMP, DAM)
Data Providers	CAISO
Links to Providers	http://oasis.caiso.com
Topic Tags	Lmp, Day-Ahead, Spreads
Type of Data Access
How is data pulled?	src/pulls/pull_caiso_lmp_day_ahead_hourly.py via the open-source gridstatus library
Data available up to (min)	N/A
Data available up to (max)	N/A
Dataframe Path	data\opensource\caiso_lmp_day_ahead_hourly.parquet

Linked Charts:

• CAISO:caiso_dart_spread

Pipeline Manifest

Pipeline Name	Project-Lab-Energy-Weather-Natgas-Quanto-CAISO
Pipeline ID	CAISO
Lead Pipeline Developer	Brian Nguyen
Contributors	Brian Nguyen, Claire Kim
Git Repo URL
Pipeline Web Page	Pipeline Web Page
Date of Last Code Update	2026-08-27 10:08:05
OS Compatibility	Windows, Linux, macOS
Linked Dataframes	CAISO:caiso_lmp_day_ahead_hourly CAISO:caiso_lmp_real_time_15_min CAISO:caiso_lmp_real_time_5_min CAISO:caiso_fuel_prices CAISO:caiso_fuel_regions CAISO:caiso_load CAISO:caiso_load_hourly CAISO:caiso_fuel_mix CAISO:caiso_renewables_hourly CAISO:caiso_curtailed_non_operational_generator_report CAISO:caiso_outages_aggregated_hourly CAISO:openmeteo_temperature_daily CAISO:eia860m_generators CAISO:us_ba_boundaries

Build Commands:

doit