Ask the Grid
Open live grid

CENACE Settled Demand by Load Zone (Baja)

CENACE's settled hourly demand by load zone since 2016 in Baja California (Tijuana, Mexicali, Ensenada, San Luis Rio Colorado) and Baja California Sur, from metered withdrawals.

CENACELoad dataBaja California market
Query with the agent
Native record
load zone x hour x settlement
daily, about 14 days late, then re-settled publication cadence
Evidence
Observed market data
Published observations from the named source
Time basis
Point-in-time records
UTC · event_time

Overview

CENACE's settled hourly demand by load zone since 2016 in Baja California (Tijuana, Mexicali, Ensenada, San Luis Rio Colorado) and Baja California Sur, from metered withdrawals.

Query contract

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

Analysis rules

  • Every settlement is stored; take the highest settlement per hour (argMax(value, settlement)) for the best estimate. Settlement 0 lands about 14 days after the day.
  • Zones join cenace.zonal_prices on (system, load_zone, event_time).

Schema9

Column
Type
event_timeDateTime64(6, 'UTC')
systemLowCardinality(String)
load_zoneLowCardinality(String)
settlementInt64
operating_dateNullable(Date)
hour_endingNullable(Int64)
demand_mwhNullable(Float64)
published_atNullable(DateTime64(6, 'UTC'))
ingested_atDateTime64(6, 'UTC')

Sample data

event_timesystemload_zonesettlementoperating_datehour_endingdemand_mwhpublished_atingested_at
2026-09-13 06:00:00.000000BCSLOS CABOS02026-09-1224287.671362026-09-26 07:25:01.0000002026-09-26 18:40:36.145711
2026-09-13 06:00:00.000000BCSLA PAZ02026-09-1224196.928922026-09-26 07:25:01.0000002026-09-26 18:40:36.145711
2026-09-13 06:00:00.000000BCSCONSTITUCION02026-09-122454.47322026-09-26 07:25:01.0000002026-09-26 18:40:36.145711
2026-09-13 06:00:00.000000BCATIJUANA02026-09-1224912.38582026-09-26 07:25:01.0000002026-09-26 18:40:36.145711
2026-09-13 06:00:00.000000BCASANLUIS02026-09-1224303.191732026-09-26 07:25:01.0000002026-09-26 18:40:36.145711
2026-09-13 06:00:00.000000BCAMEXICALI02026-09-12241118.218632026-09-26 07:25:01.0000002026-09-26 18:40:36.145711
2026-09-13 06:00:00.000000BCAENSENADA02026-09-1224233.944172026-09-26 07:25:01.0000002026-09-26 18:40:36.145711
2026-09-13 06:00:00.000000BCSLOS CABOS02026-09-1224287.671362026-09-26 07:25:01.0000002026-09-26 12:40:38.702318
2026-09-13 06:00:00.000000BCSLA PAZ02026-09-1224196.928922026-09-26 07:25:01.0000002026-09-26 12:40:38.702318
2026-09-13 06:00:00.000000BCSCONSTITUCION02026-09-122454.47322026-09-26 07:25:01.0000002026-09-26 12:40:38.702318
2026-09-13 06:00:00.000000BCATIJUANA02026-09-1224912.38582026-09-26 07:25:01.0000002026-09-26 12:40:38.702318
2026-09-13 06:00:00.000000BCASANLUIS02026-09-1224303.191732026-09-26 07:25:01.0000002026-09-26 12:40:38.702318
2026-09-13 06:00:00.000000BCAMEXICALI02026-09-12241118.218632026-09-26 07:25:01.0000002026-09-26 12:40:38.702318
2026-09-13 06:00:00.000000BCAENSENADA02026-09-1224233.944172026-09-26 07:25:01.0000002026-09-26 12:40:38.702318
2026-09-13 05:00:00.000000BCSLOS CABOS02026-09-1223298.940432026-09-26 07:25:01.0000002026-09-26 18:40:36.145711
2026-09-13 05:00:00.000000BCSLA PAZ02026-09-1223204.560582026-09-26 07:25:01.0000002026-09-26 18:40:36.145711
2026-09-13 05:00:00.000000BCSCONSTITUCION02026-09-122356.708912026-09-26 07:25:01.0000002026-09-26 18:40:36.145711
2026-09-13 05:00:00.000000BCATIJUANA02026-09-1223960.094812026-09-26 07:25:01.0000002026-09-26 18:40:36.145711
2026-09-13 05:00:00.000000BCASANLUIS02026-09-1223320.508662026-09-26 07:25:01.0000002026-09-26 18:40:36.145711
2026-09-13 05:00:00.000000BCAMEXICALI02026-09-12231168.412382026-09-26 07:25:01.0000002026-09-26 18:40:36.145711
2026-09-13 05:00:00.000000BCAENSENADA02026-09-1223244.759012026-09-26 07:25:01.0000002026-09-26 18:40:36.145711
2026-09-13 05:00:00.000000BCSLOS CABOS02026-09-1223298.940432026-09-26 07:25:01.0000002026-09-26 12:40:38.702318
2026-09-13 05:00:00.000000BCSLA PAZ02026-09-1223204.560582026-09-26 07:25:01.0000002026-09-26 12:40:38.702318
2026-09-13 05:00:00.000000BCSCONSTITUCION02026-09-122356.708912026-09-26 07:25:01.0000002026-09-26 12:40:38.702318
2026-09-13 05:00:00.000000BCATIJUANA02026-09-1223960.094812026-09-26 07:25:01.0000002026-09-26 12:40:38.702318

Coverage

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