# 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 2026-08-27 06:00:00 $ interval_end_utc 2026-08-27 07:00:00 $ market 'DAY_AHEAD_HOURLY' $ location 'TH_ZP26_GEN-APND' $ location_type 'Trading Hub' $ lmp 54.45514 $ energy 55.75814 $ congestion -10.72246 $ loss -2.91433 $ ghg 12.33379 ``` ## Dataframe Manifest | Dataframe Name | CAISO LMP Day-Ahead Hourly | |--------------------------------|--------------------------------------------------------------------------------------| | Dataframe ID | [caiso_lmp_day_ahead_hourly](../dataframes/CAISO/caiso_lmp_day_ahead_hourly.md) | | 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](../../charts/CAISO.caiso_dart_spread.md) ## Pipeline Manifest | Pipeline Name | Project-Lab-Energy-Weather-Natgas-Quanto-CAISO | |---------------------------------|--------------------------------------------------------| | Pipeline ID | [CAISO](../../../index.md) | | 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](../../dataframes/CAISO/caiso_lmp_day_ahead_hourly.md)
[CAISO:caiso_lmp_real_time_15_min](../../dataframes/CAISO/caiso_lmp_real_time_15_min.md)
[CAISO:caiso_lmp_real_time_5_min](../../dataframes/CAISO/caiso_lmp_real_time_5_min.md)
[CAISO:caiso_fuel_prices](../../dataframes/CAISO/caiso_fuel_prices.md)
[CAISO:caiso_fuel_regions](../../dataframes/CAISO/caiso_fuel_regions.md)
[CAISO:caiso_load](../../dataframes/CAISO/caiso_load.md)
[CAISO:caiso_load_hourly](../../dataframes/CAISO/caiso_load_hourly.md)
[CAISO:caiso_fuel_mix](../../dataframes/CAISO/caiso_fuel_mix.md)
[CAISO:caiso_renewables_hourly](../../dataframes/CAISO/caiso_renewables_hourly.md)
[CAISO:caiso_curtailed_non_operational_generator_report](../../dataframes/CAISO/caiso_curtailed_non_operational_generator_report.md)
[CAISO:caiso_outages_aggregated_hourly](../../dataframes/CAISO/caiso_outages_aggregated_hourly.md)
[CAISO:openmeteo_temperature_daily](../../dataframes/CAISO/openmeteo_temperature_daily.md)
[CAISO:eia860m_generators](../../dataframes/CAISO/eia860m_generators.md)
[CAISO:us_ba_boundaries](../../dataframes/CAISO/us_ba_boundaries.md)
| **Build Commands:** ``` doit ```