BPA Area Control Error

BPA's Area Control Error (CPS ACE) at 1-minute and 10-minute averages from 2013, posted yearly under FERC Order 784.

BPAAncillary Services data BPA market

Open in Data Ask the agent

One row per: resolution x averaging period start; 1-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 (resolution_minutes, event_time) before aggregating.
Analysis rules: Filter one resolution_minutes value.
Interpretation: BPA prints Pacific prevailing time; event_time is UTC, resolved in file order across daylight-saving changes.Posted yearly, months after the year ends; there is no current ACE here.

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_area_control_error/query
Full history: Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

7 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`resolution_minutes`	`Int32`
`ace_mw`	`Nullable(Float64)`
`value_text`	`Nullable(String)`
`pi_tag`	`Nullable(String)`
`source_file`	`String`
`ingested_at`	`DateTime64(6, 'UTC')`

Sample data

event_time	resolution_minutes	ace_mw	value_text	pi_tag	source_file	ingested_at
2026-01-01 07:59:00.000000	1	-68.2558866818746	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:58:00.000000	1	-78.94591341018676	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:57:00.000000	1	-85.09623273213704	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:56:00.000000	1	-85.14826024373373	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:55:00.000000	1	-108.36307360331217	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:54:00.000000	1	-80.68522707621257	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:53:00.000000	1	-99.37290274302164	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:52:00.000000	1	-64.66107781728108	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:51:00.000000	1	-42.45970029830933	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:50:00.000000	1	-30.816671133041382	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:50:00.000000	10	-74.38049457391104	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:49:00.000000	1	-30.986336612701415	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:48:00.000000	1	-63.50105851635788	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:47:00.000000	1	-38.048222635731555	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:46:00.000000	1	-50.423100026448566	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:45:00.000000	1	-49.13058993021647	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:44:00.000000	1	-36.40487993558248	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:43:00.000000	1	-67.01361179351807	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:42:00.000000	1	-30.65137085914612	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:41:00.000000	1	-27.655500288804372	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:40:00.000000	1	-44.11546945969264	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:40:00.000000	10	-43.793014005819956	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:39:00.000000	1	-22.459546852111817	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:38:00.000000	1	-6.226459763447443	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204
2026-01-01 07:37:00.000000	1	-23.391406885782878	∅	AGC_ONLN.CAREA..MW.71949	ACE_2025_FERC784_FINAL.xlsx	2026-09-19 09:45:25.607204

Coverage

Complete: 100.0%
Gap days: 0
Days with data: 4,749

Show coverage history

Coverage: 100.0%Days with data: 4,749Gaps: 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

gaplessmore

Related data

Related ancillary services data
Dataset	Description
BPA Balancing Reserves DeployedBPA · 5-minute	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.
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.