Hourly Interchange Between Balancing Authority Pairs

Hourly net interchange between every pair of US balancing authorities, as reported to EIA-930.

Native record
event_time x fromba x toba
hourly, published about 36 hours late publication cadence
Evidence
Observed market data
Published observations from the named source
Time basis
Point-in-time records
UTC · event_time

Overview

A positive value leaves fromba for toba. This is the only source covering balancing authorities outside the organized markets, so it is how a grid's smaller neighbours can be seen at all. EIA publishes a pair's hour roughly a day and a half after it, and revises for about two days after that, so a row is a settled record rather than a live reading and the freshest ingested_at for an hour is the current one. A pair is reported by both sides and the two reports need not agree.

Query contract

Preserve one canonical row per (event_time, fromba, toba) before aggregating.

Analysis rules

  • Group only after preserving the declared grain: event_time, fromba, toba.

Schema9

Column
Type
event_timeDateTime64(6, 'UTC')
frombaLowCardinality(String)
tobaLowCardinality(String)
source_timeDateTime64(6, 'UTC')
fromba_nameNullable(String)
toba_nameNullable(String)
valueNullable(Float64)
value_unitsNullable(String)
ingested_atDateTime64(6, 'UTC')

Sample data

event_timefrombatobasource_timefromba_nametoba_namevaluevalue_unitsingested_at
2026-09-18 07:00:00.000000WALCTEPC2026-09-20 01:07:03.733182Western Area Power Administration - Desert Southwest RegionTucson Electric Power321megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000WALCSWPW2026-09-20 01:07:03.733182Western Area Power Administration - Desert Southwest RegionSouthwest Power Pool West Balancing Authority Area-51megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000WALCSRP2026-09-20 01:07:03.733182Western Area Power Administration - Desert Southwest RegionSalt River Project Agricultural Improvement and Power District-254megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000WALCNEVP2026-09-20 01:07:03.733182Western Area Power Administration - Desert Southwest RegionNevada Power Company380megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000WALCLDWP2026-09-20 01:07:03.733182Western Area Power Administration - Desert Southwest RegionLos Angeles Department of Water and Power996megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000WALCIID2026-09-20 01:07:03.733182Western Area Power Administration - Desert Southwest RegionImperial Irrigation District22megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000WALCGRID2026-09-20 01:07:03.733182Western Area Power Administration - Desert Southwest RegionGridforce Energy Management, LLC-211megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000WALCCISO2026-09-20 01:07:03.733182Western Area Power Administration - Desert Southwest RegionCalifornia Independent System Operator247megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000WALCAZPS2026-09-20 01:07:03.733182Western Area Power Administration - Desert Southwest RegionArizona Public Service Company-991megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000US48MEX2026-09-20 01:07:03.733182United States Lower 48Mexico103megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000US48CAN2026-09-20 01:07:03.733182United States Lower 48Canada-2079megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000TPWRPSEI2026-09-20 01:07:03.733182City of Tacoma, Department of Public Utilities, Light DivisionPuget Sound Energy, Inc.38megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000TPWRBPAT2026-09-20 01:07:03.733182City of Tacoma, Department of Public Utilities, Light DivisionBonneville Power Administration-344megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000TIDCCISO2026-09-20 01:07:03.733182Turlock Irrigation DistrictCalifornia Independent System Operator-221megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000TIDCBANC2026-09-20 01:07:03.733182Turlock Irrigation DistrictBalancing Authority of Northern California143megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000TEPCWALC2026-09-20 01:07:03.733182Tucson Electric PowerWestern Area Power Administration - Desert Southwest Region-321megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000TEPCSRP2026-09-20 01:07:03.733182Tucson Electric PowerSalt River Project Agricultural Improvement and Power District692megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000TEPCPNM2026-09-20 01:07:03.733182Tucson Electric PowerPublic Service Company of New Mexico-92megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000TEPCEPE2026-09-20 01:07:03.733182Tucson Electric PowerEl Paso Electric Company-250megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000TEPCAZPS2026-09-20 01:07:03.733182Tucson Electric PowerArizona Public Service Company41megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000SWNW2026-09-20 01:07:03.733182SouthwestNorthwest-1044megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000SWCENT2026-09-20 01:07:03.733182SouthwestCentral0megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000SWCAL2026-09-20 01:07:03.733182SouthwestCalifornia4942megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000SRPWALC2026-09-20 01:07:03.733182Salt River Project Agricultural Improvement and Power DistrictWestern Area Power Administration - Desert Southwest Region254megawatthours2026-09-20 01:07:08.372179
2026-09-18 07:00:00.000000SRPTEPC2026-09-20 01:07:03.733182Salt River Project Agricultural Improvement and Power DistrictTucson Electric Power-692megawatthours2026-09-20 01:07:08.372179

Coverage

100.0% complete0 gap days2,818 days with data
Show coverage history
Coverage: 100.0%Days with data: 2,818Gaps: 0
2026
2025
2024
2023
2022
2021
2020
2019
gaplessmore