Ask the Grid
Open live grid

BPA Balancing Reserves Deployed

Balancing reserves BPA deployed every five minutes with the INC and DEC maxima available, plus the wind-limit (OCBR), oversupply-mitigation and EIM status flags, since August 2009.

BPAAncillary Services dataBPA market
Query with the agent
Native record
feed x 5-minute instant
5-minute publication cadence
Evidence
Observed market data
Published observations from the named source
Time basis
Point-in-time records
UTC · event_time

Overview

Balancing reserves BPA deployed every five minutes with the INC and DEC maxima available, plus the wind-limit (OCBR), oversupply-mitigation and EIM status flags, since August 2009.

Query contract

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

Analysis rules

  • Pick one feed per question: annual_workbook for history, live_7day for the last day the workbook does not yet hold. Never sum the two feeds for the same instant.
  • Flags are state codes, not MW; do not average them.

Interpretation

  • BPA prints Pacific prevailing time; event_time is UTC, resolved in file order across daylight-saving changes.

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.

BPA MCP API reference
HTTP endpoint
POST /api/v1/datasets/bpa_balancing_reserves_5m/query

Schema10

Column
Type
event_timeDateTime64(6, 'UTC')
feedLowCardinality(String)
reserves_deployed_mwNullable(Float64)
inc_max_mwNullable(Float64)
dec_max_mwNullable(Float64)
ocbr_stateNullable(Float64)
oversupply_mitigation_stateNullable(Float64)
eim_statusNullable(Float64)
source_fileString
ingested_atDateTime64(6, 'UTC')

Sample data

event_timefeedreserves_deployed_mwinc_max_mwdec_max_mwocbr_stateoversupply_mitigation_stateeim_statussource_fileingested_at
2026-09-20 06:30:00.000000live_7day87331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:36:11.974373
2026-09-20 06:25:00.000000live_7day-29331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:36:11.974373
2026-09-20 06:20:00.000000live_7day2331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:36:11.974373
2026-09-20 06:20:00.000000live_7day2331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:26:12.619224
2026-09-20 06:15:00.000000live_7day63331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:36:11.974373
2026-09-20 06:15:00.000000live_7day63331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:26:12.619224
2026-09-20 06:10:00.000000live_7day67331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:16:11.370584
2026-09-20 06:10:00.000000live_7day67331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:36:11.974373
2026-09-20 06:10:00.000000live_7day67331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:26:12.619224
2026-09-20 06:05:00.000000live_7day44331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:16:11.370584
2026-09-20 06:05:00.000000live_7day44331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:36:11.974373
2026-09-20 06:05:00.000000live_7day44331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:26:12.619224
2026-09-20 06:00:00.000000live_7day28331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:06:11.459620
2026-09-20 06:00:00.000000live_7day28331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:16:11.370584
2026-09-20 06:00:00.000000live_7day28331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:36:11.974373
2026-09-20 06:00:00.000000live_7day28331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:26:12.619224
2026-09-20 05:55:00.000000live_7day95331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:06:11.459620
2026-09-20 05:55:00.000000live_7day95331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:16:11.370584
2026-09-20 05:55:00.000000live_7day95331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:36:11.974373
2026-09-20 05:55:00.000000live_7day95331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:26:12.619224
2026-09-20 05:50:00.000000live_7day34331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:06:11.459620
2026-09-20 05:50:00.000000live_7day34331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:16:11.370584
2026-09-20 05:50:00.000000live_7day34331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:36:11.974373
2026-09-20 05:50:00.000000live_7day34331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:26:12.619224
2026-09-20 05:45:00.000000live_7day39331-341000reserves.txt+eimstatus.txt+windlim.txt+envDispFlag.txt2026-09-20 06:06:11.459620

Coverage

100.0% complete0 gap days6,241 days with data
Show coverage history
Coverage: 100.0%Days with data: 6,241Gaps: 0
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016
2015
2014
2013
2012
2011
2010
2009
gaplessmore