CENACE Live Demand, Generation and Forecast

CENACE's live chart for Baja California, Baja California Sur and the national system: hourly demand, generation and CENACE's demand forecast, stored whole at every hourly poll because CENACE keeps no history of it.

Native record
system x hour x poll
hourly poll publication cadence
Evidence
Mixed evidence
Multiple evidence types kept distinct in the contract
Time basis
Point-in-time records
UTC · event_time

Overview

Baja California's demand minus generation is roughly its net import from California.

Query contract

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

Analysis rules

  • Filter system: 'BCA' is Baja California (tied to CAISO), 'BCS' is Baja California Sur and 'SIN' is the rest of Mexico; never add systems together as if they were one grid.
  • Actuals: take the latest observed_at per (system, event_time) where demand_mw is not NULL.

Interpretation

  • operating_date and hour_ending are on Mexico City's clock (UTC-6) for every system on this chart, Baja California included; event_time is UTC and is what to compare with California.
  • History starts at the first poll (2026-09-26); there is nothing earlier.

Schema9

Column
Type
event_timeDateTime64(6, 'UTC')
systemLowCardinality(String)
observed_atDateTime64(6, 'UTC')
operating_dateNullable(Date)
hour_endingNullable(Int64)
demand_mwNullable(Float64)
generation_mwNullable(Float64)
forecast_mwNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample data

event_timesystemobserved_atoperating_datehour_endingdemand_mwgeneration_mwforecast_mwingested_at
2026-09-27 05:00:00.000000SIN2026-09-26 18:04:05.0000002026-09-2624∅∅424742026-09-26 18:04:05.821099
2026-09-27 05:00:00.000000BCS2026-09-26 18:04:05.0000002026-09-2624∅∅5362026-09-26 18:04:05.821099
2026-09-27 05:00:00.000000BCA2026-09-26 18:04:05.0000002026-09-2624∅∅24992026-09-26 18:04:05.821099
2026-09-27 05:00:00.000000SIN2026-09-26 17:04:05.0000002026-09-2624∅∅424742026-09-26 17:04:06.231583
2026-09-27 05:00:00.000000SIN2026-09-26 16:04:04.0000002026-09-2624∅∅424742026-09-26 16:04:07.707827
2026-09-27 05:00:00.000000SIN2026-09-26 15:04:07.0000002026-09-2624∅∅424742026-09-26 15:04:09.221817
2026-09-27 05:00:00.000000SIN2026-09-26 14:04:05.0000002026-09-2624∅∅424742026-09-26 14:04:05.990562
2026-09-27 05:00:00.000000SIN2026-09-26 13:04:05.0000002026-09-2624∅∅424742026-09-26 13:04:06.360815
2026-09-27 05:00:00.000000SIN2026-09-26 12:04:05.0000002026-09-2624∅∅424742026-09-26 12:04:05.823318
2026-09-27 05:00:00.000000SIN2026-09-26 11:04:04.0000002026-09-2624∅∅424742026-09-26 11:04:06.004952
2026-09-27 05:00:00.000000SIN2026-09-26 10:04:06.0000002026-09-2624∅∅424742026-09-26 10:04:07.677459
2026-09-27 05:00:00.000000SIN2026-09-26 09:04:05.0000002026-09-2624∅∅424742026-09-26 09:04:06.285682
2026-09-27 05:00:00.000000SIN2026-09-26 08:04:05.0000002026-09-2624∅∅424742026-09-26 08:04:05.909046
2026-09-27 05:00:00.000000SIN2026-09-26 07:04:08.0000002026-09-2624∅∅424742026-09-26 07:04:09.677577
2026-09-27 05:00:00.000000BCS2026-09-26 17:04:05.0000002026-09-2624∅∅5362026-09-26 17:04:06.231583
2026-09-27 05:00:00.000000BCS2026-09-26 16:04:04.0000002026-09-2624∅∅5362026-09-26 16:04:07.707827
2026-09-27 05:00:00.000000BCS2026-09-26 15:04:07.0000002026-09-2624∅∅5362026-09-26 15:04:09.221817
2026-09-27 05:00:00.000000BCS2026-09-26 14:04:05.0000002026-09-2624∅∅5362026-09-26 14:04:05.990562
2026-09-27 05:00:00.000000BCS2026-09-26 13:04:05.0000002026-09-2624∅∅5362026-09-26 13:04:06.360815
2026-09-27 05:00:00.000000BCS2026-09-26 12:04:05.0000002026-09-2624∅∅5362026-09-26 12:04:05.823318
2026-09-27 05:00:00.000000BCS2026-09-26 11:04:04.0000002026-09-2624∅∅5362026-09-26 11:04:06.004952
2026-09-27 05:00:00.000000BCS2026-09-26 10:04:06.0000002026-09-2624∅∅5362026-09-26 10:04:07.677459
2026-09-27 05:00:00.000000BCS2026-09-26 09:04:05.0000002026-09-2624∅∅5362026-09-26 09:04:06.285682
2026-09-27 05:00:00.000000BCS2026-09-26 08:04:05.0000002026-09-2624∅∅5362026-09-26 08:04:05.909046
2026-09-27 05:00:00.000000BCS2026-09-26 07:04:08.0000002026-09-2624∅∅5362026-09-26 07:04:09.677577

Coverage

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