CAISO logo

Five-Minute Demand Outlook

CAISO system demand, day-ahead and hour-ahead demand forecasts, and demand response from the live demand Outlook.

Native record
CAISO system x five-minute delivery x capture
5-minute publication cadence
Evidence
Mixed evidence
Multiple evidence types kept distinct in the contract
Time basis
Point-in-time records
UTC · event_time

Overview

Every capture is retained, with Pacific snapshot date and DST ambiguity flags.

Query contract

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

Analysis rules

  • Select the latest observed_at per delivery interval within the knowledge-time cutoff; never sum snapshots.
  • Exclude ambiguous_local_time rows when exact UTC alignment is required.

Interpretation

  • observed_at is capture time, not operator publication time. Historical snapshots can contain revisions and realized values; never backdate availability to snapshot_date midnight.
  • NULL values are unknown, not zero; MW is power, not interval energy.

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_actual_5m/query

Schema10

Column
Type
event_timeDateTime64(6, 'UTC')
interval_endDateTime64(6, 'UTC')
snapshot_dateDate
observed_atDateTime64(6, 'UTC')
ambiguous_local_timeBool
demand_mwNullable(Float64)
day_ahead_forecast_mwNullable(Float64)
hour_ahead_forecast_mwNullable(Float64)
demand_response_mwNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample data

event_timeinterval_endsnapshot_dateobserved_atambiguous_local_timedemand_mwday_ahead_forecast_mwhour_ahead_forecast_mwdemand_response_mwingested_at
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 06:08:09.589798false∅3171930250∅2026-10-05 06:08:09.732309
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 06:03:09.784499false∅3171930250∅2026-10-05 06:03:09.957579
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 05:58:09.157822false∅3171930255∅2026-10-05 05:58:09.347951
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 05:53:09.116386false∅3171930260∅2026-10-05 05:53:09.355148
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 05:48:09.146715false∅3171930260∅2026-10-05 05:48:09.371244
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 05:43:08.985026false∅3171930265∅2026-10-05 05:43:09.239596
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 05:38:09.247476false∅3171930213∅2026-10-05 05:38:09.504386
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 05:33:09.585617false∅3171930213∅2026-10-05 05:33:09.945712
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 05:28:10.009004false∅3171930217∅2026-10-05 05:28:10.213228
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 05:23:09.000022false∅3171930241∅2026-10-05 05:23:09.169294
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 05:18:09.665421false∅3171930241∅2026-10-05 05:18:09.902647
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 05:13:09.057632false∅3171930242∅2026-10-05 05:13:09.250249
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 05:08:09.876934false∅3171930335∅2026-10-05 05:08:10.016325
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 05:03:09.443280false∅3171930335∅2026-10-05 05:03:09.760423
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 04:58:11.135799false∅3171930337∅2026-10-05 04:58:11.323415
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 04:53:09.223314false∅3171930421∅2026-10-05 04:53:09.418942
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 04:48:09.935589false∅3171930421∅2026-10-05 04:48:10.350746
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 04:43:10.779799false∅3171930424∅2026-10-05 04:43:11.006200
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 04:38:09.877180false∅3171930533∅2026-10-05 04:38:10.072949
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 04:33:09.283851false∅3171930533∅2026-10-05 04:33:09.491302
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 04:28:09.214305false∅3171930534∅2026-10-05 04:28:09.416991
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 04:23:09.061186false∅3171930650∅2026-10-05 04:23:09.255899
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 04:18:09.419853false∅3171930650∅2026-10-05 04:18:09.687257
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 04:13:10.102833false∅3171930648∅2026-10-05 04:13:10.401750
2026-10-05 06:55:00.0000002026-10-05 07:00:00.0000002026-10-042026-10-05 04:08:09.786582false∅3171930744∅2026-10-05 04:08:10.055052

Coverage

100.0% complete0 gap days2 days with data
Show coverage history
Coverage: 100.0%Days with data: 2Gaps: 0
2026
gaplessmore