CAISO logo

CAISO Day-Ahead Load Forecast

CAISO's day-ahead demand forecast, one row per forecast hour with a system total and one column per TAC area.

Native record
one row per forecast hour, wide by TAC area
hourly (day-ahead run) publication cadence
Evidence
Forecast data
Forward-looking values with an explicit issue time
Time basis
Interval-start records
UTC · event_time

Overview

75,727 hours, 2018-01 through the next delivery day. Column-for-column identical to CAISO Load (caiso_load) on purpose: system_mw, pge_mw, sce_mw, sdge_mw, vea_mw, mwd_mw. Forecast-versus-actual is therefore a plain join on event_time with no reshaping on either side. CAISO publishes no issue-time column for this feed, so there is no vintage axis here — this is the day-ahead market run for each hour, not a curve of successive forecasts. CAISO's other horizons (two-day, seven-day, real-time) live in caiso.load_forecast_horizons and only begin in May 2026.

Query contract

event_time is the hour being forecast. There is exactly one day-ahead forecast row per hour and no publication column, so no vintage selection is possible or needed.

Analysis rules

  • Take every value for one hour from that hour's single row.
  • Do not sum the five TAC-area columns together with system_mw.

Related analysis

  • day-ahead forecast error · join on event_time; both tables carry the same six columns

Interpretation

  • This is the DAY-AHEAD run only. It cannot answer what CAISO expected an hour before delivery, and calling it 'the forecast' without the horizon overstates it.
  • There is no issue-time column, so this table cannot support any question about how a forecast was revised as delivery approached.

Access

Query from your own tools

Use the guarded HTTP endpoint directly, or connect an MCP client and load the dataset contract with describe_data before calling query_data.

HTTP endpoint
POST /api/v1/datasets/caiso_load_forecast/query

Need the full history of this dataset in Snowflake, Databricks or your own storage? Data services delivers it on a schedule.

Schema7

Column
Type
event_timeDateTime64(6, 'UTC')
system_mwNullable(Float64)
pge_mwNullable(Float64)
sce_mwNullable(Float64)
sdge_mwNullable(Float64)
vea_mwNullable(Float64)
mwd_mwNullable(Float64)

Sample data

event_timesystem_mwpge_mwsce_mwsdge_mwvea_mwmwd_mw
2026-10-13 06:00:00.00000022683.361000110296.472154.2652.86178.77
2026-10-13 05:00:00.00000024063.6510655.6510880.862293.2655.89178
2026-10-13 04:00:00.00000025306.3811282.7911325.562460.6859.79177.55
2026-10-13 03:00:00.00000025960.0611700.6611450.972567.3462.89178.2
2026-10-13 02:00:00.00000026635.0412056.0511655.982679.9565.75177.31
2026-10-13 01:00:00.00000026454.6712082.4411487.492642.0265.23177.5
2026-10-13 00:00:00.00000025232.8511391.2511167.82433.9162.71177.18
2026-10-12 23:00:00.00000023668.1410390.4510841.972198.0661.07176.59
2026-10-12 22:00:00.00000022563.679639.5910641.052047.757.48177.86
2026-10-12 21:00:00.00000021794.969014.7110605.421943.7353.13177.97
2026-10-12 20:00:00.00000021477.978705.6910642.451901.9949.58178.27
2026-10-12 19:00:00.00000021534.68641.4910770.711896.1347.76178.5
2026-10-12 18:00:00.00000022012.598918.6510921.091947.2347.29178.33
2026-10-12 17:00:00.00000023037.689528.6111173.422110.1748.93176.55
2026-10-12 16:00:00.00000024136.9810284.8311367.562256.9250.82176.86
2026-10-12 15:00:00.00000024882.1811069.5611264.232317.7153.22177.46
2026-10-12 14:00:00.00000024795.8211307.510918.752339.752.55177.31
2026-10-12 13:00:00.00000023308.6910473.5310362.62242.4452.21177.91
2026-10-12 12:00:00.00000021335.419518.589506.432084.3548.37177.69
2026-10-12 11:00:00.00000020169.498953.788994.021997.8345.24178.62
2026-10-12 10:00:00.00000019867.518785.18842.1201844178.32
2026-10-12 09:00:00.00000020204.948883.198997.492101.1244.13179.01
2026-10-12 08:00:00.00000020894.399103.319352.182213.7244.96180.22
2026-10-12 07:00:00.00000021716.189393.919797.492297.246.54181.03
2026-10-12 06:00:00.00000022467.339675.9510277.522292.4344.61176.82

Coverage

100.0% complete0 gap days3,208 days with data
Show coverage history
Coverage: 100.0%Days with data: 3,208Gaps: 0
2026
2025
2024
2023
2022
2021
2020
2019
2018
gaplessmore