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 data BPA market

Open in Data Ask the agent

One row per: feed x 5-minute instant; 5-minute cadence
Evidence: Observed market data; Published observations from the named source
Time basis: Point-in-time records; UTC · event_time

Overview

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

Download: Query it in SQL, download it, or read it with an API key. Download data
MCP: Connect an MCP client and load the contract with describe_data before calling query_data.BPA MCP API reference
HTTP endpoint: POST /api/v1/datasets/bpa_balancing_reserves_5m/query
Full history: Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

10 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`feed`	`LowCardinality(String)`
`reserves_deployed_mw`	`Nullable(Float64)`
`inc_max_mw`	`Nullable(Float64)`
`dec_max_mw`	`Nullable(Float64)`
`ocbr_state`	`Nullable(Float64)`
`oversupply_mitigation_state`	`Nullable(Float64)`
`eim_status`	`Nullable(Float64)`
`source_file`	`String`
`ingested_at`	`DateTime64(6, 'UTC')`

Sample data

event_time	feed	reserves_deployed_mw	inc_max_mw	dec_max_mw	source_file	ingested_at
2026-11-04 07:55:00.000000	annual_workbook	26	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 07:50:00.000000	annual_workbook	97	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 07:45:00.000000	annual_workbook	101	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 07:40:00.000000	annual_workbook	55	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 07:35:00.000000	annual_workbook	195	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 07:30:00.000000	annual_workbook	61	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 07:25:00.000000	annual_workbook	-92	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 07:20:00.000000	annual_workbook	17	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 07:15:00.000000	annual_workbook	-60	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 07:10:00.000000	annual_workbook	55	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 07:05:00.000000	annual_workbook	64	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 07:00:00.000000	annual_workbook	30	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 06:55:00.000000	annual_workbook	24	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 06:50:00.000000	annual_workbook	38	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 06:45:00.000000	annual_workbook	33	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 06:40:00.000000	annual_workbook	51	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 06:35:00.000000	annual_workbook	-3	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 06:30:00.000000	annual_workbook	-64	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 06:25:00.000000	annual_workbook	-19	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 06:20:00.000000	annual_workbook	-21	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 06:15:00.000000	annual_workbook	36	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 06:10:00.000000	annual_workbook	16	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 06:05:00.000000	annual_workbook	66	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 06:00:00.000000	annual_workbook	50	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457
2026-11-04 05:55:00.000000	annual_workbook	-73	337	-344	ReservesDeployedYTD_2026.xlsx	2026-11-04 09:47:34.127457

Coverage

Complete: 100.0%
Gap days: 0
Days with data: 6,286

Show coverage history

Coverage: 100.0%Days with data: 6,286Gaps: 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

gaplessmore

Related data

Related ancillary services data
Dataset	Description
BPA Area Control ErrorBPA · 1-minute	BPA's Area Control Error (CPS ACE) at 1-minute and 10-minute averages from 2013, posted yearly under FERC Order 784.
Ancillary Service Market Clearing PricesSPP · 5-minute (RTBM) and hourly (Day-Ahead)	Cleared ancillary-service prices by SPP reserve zone for both the real-time balancing market and the day-ahead market. SPP's product set does not map onto other ISOs': regulation clears as a separate service (capacity) price and mileage price in each direction (reg_up_service, reg_up_mile, reg_dn_service, reg_dn_mile), alongside ramp up and down, spinning, supplemental, and uncertainty products. IMPORTANT: reserve_zone mixes two grains. It carries the numeric ancillary reserve zones (1 through 5 under the SPP balancing authority, 21 under the separate SWPW balancing authority) AND the two balancing-authority roll-ups, 'SPP' and 'SWPW', whose prices equal those of their member zones. Aggregating across every value of reserve_zone double-counts the market.
Ancillary Service PricesERCOT · hourly (DAM)	Hourly market clearing prices for the ancillary services ERCOT procures alongside energy in its Day-Ahead Market, broken out by product: Regulation Up (RegUp), Regulation Down (RegDown), Responsive Reserve (RRS), Non-Spinning Reserve (NSPIN), and the ERCOT Contingency Reserve Service (ECRS). These prices represent what the grid pays per megawatt to hold capacity in reserve for frequency control and contingency response, separate from the energy itself. Watching them shows when reserves are scarce and expensive (often during tight or volatile conditions), which informs how generators and storage operators allocate capacity between energy and reserve markets, and gives researchers a read on the cost of keeping the Texas grid reliable. ECRS, added in 2023, is the newest of these products and has at times cleared at notably high levels.
Ancillary-service capacity monitorERCOT · Publisher snapshot	ERCOT's Ancillary-service capacity monitor. Each row preserves a publisher record, workbook row, or report document with its source member and row index. Source timestamps, units, geographic scope, and revision qualifiers are retained in record_json; event_time is collection time; completed_at is when the entire document became available.