DAM Total AS Sold

This dataset reports the total quantity of ancillary services ERCOT procured in its Day-Ahead Market, broken out by product (such as Regulation Up, Regulation Down, Responsive Reserve, ECRS, and Non-Spinning Reserve) for each delivery hour.

Ancillary Services data ERCOT market

Query with the agent

Native record

event_time x as_type

hourly (DAM) publication cadence

Evidence

Cleared day-ahead market

A market outcome, not a physical observation

Time basis

Point-in-time records

UTC · event_time

Overview

These figures show how much reserve capability ERCOT set aside to keep supply and demand balanced and to respond to contingencies, separate from the energy cleared for actual generation. Paired with the per-product clearing prices, the cleared volumes let traders, researchers, and the public see how reserve requirements shift hour to hour and how much of the market's capacity is committed to grid reliability rather than energy. The data comes from ERCOT report NP4-532-CD (DAM Total AS Sold) and updates with each day-ahead market run.

Query contract

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

Analysis rules

Group only after preserving the declared grain: event_time, as_type.

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.

ERCOT MCP API reference

HTTP endpoint

POST /api/v1/datasets/ercot_dam_total_as_sold/query

Schema7

Column

Type

event_timeDateTime64(6, 'UTC')

as_typeLowCardinality(String)

total_mwNullable(Float64)

dst_flagNullable(Bool)

emil_idNullable(String)

doc_idNullable(Int64)

ingested_atDateTime64(6, 'UTC')

Sample data

event_time	as_type	total_mw	dst_flag	emil_id	doc_id	ingested_at
2026-09-26 05:00:00.000000	RRSUF	841.9	false	∅	∅	2026-09-25 07:15:16.489727
2026-09-26 05:00:00.000000	RRSPF	1327.9	false	∅	∅	2026-09-25 07:15:16.489727
2026-09-26 05:00:00.000000	RRSFF	45.2	false	∅	∅	2026-09-25 07:15:16.489727
2026-09-26 05:00:00.000000	REGUP	260.3	false	∅	∅	2026-09-25 07:15:16.489727
2026-09-26 05:00:00.000000	REGDN	267	false	∅	∅	2026-09-25 07:15:16.489727
2026-09-26 05:00:00.000000	ONNS	1931.8	false	∅	∅	2026-09-25 07:15:16.489727
2026-09-26 05:00:00.000000	OFFNS	2333.5	false	∅	∅	2026-09-25 07:15:16.489727
2026-09-26 05:00:00.000000	OFFEC	216.6	false	∅	∅	2026-09-25 07:15:16.489727
2026-09-26 05:00:00.000000	ECRSS	842.6	false	∅	∅	2026-09-25 07:15:16.489727
2026-09-26 05:00:00.000000	ECRSM	215.8	false	∅	∅	2026-09-25 07:15:16.489727
2026-09-26 05:00:00.000000	RRSUF	841.9	false	∅	∅	2026-09-25 06:15:17.125119
2026-09-26 05:00:00.000000	RRSPF	1327.9	false	∅	∅	2026-09-25 06:15:17.125119
2026-09-26 05:00:00.000000	RRSFF	45.2	false	∅	∅	2026-09-25 06:15:17.125119
2026-09-26 05:00:00.000000	REGUP	260.3	false	∅	∅	2026-09-25 06:15:17.125119
2026-09-26 05:00:00.000000	REGDN	267	false	∅	∅	2026-09-25 06:15:17.125119
2026-09-26 05:00:00.000000	ONNS	1931.8	false	∅	∅	2026-09-25 06:15:17.125119
2026-09-26 05:00:00.000000	OFFNS	2333.5	false	∅	∅	2026-09-25 06:15:17.125119
2026-09-26 05:00:00.000000	OFFEC	216.6	false	∅	∅	2026-09-25 06:15:17.125119
2026-09-26 05:00:00.000000	ECRSS	842.6	false	∅	∅	2026-09-25 06:15:17.125119
2026-09-26 05:00:00.000000	ECRSM	215.8	false	∅	∅	2026-09-25 06:15:17.125119
2026-09-26 05:00:00.000000	RRSUF	841.9	false	∅	∅	2026-09-25 05:15:15.745344
2026-09-26 05:00:00.000000	RRSPF	1327.9	false	∅	∅	2026-09-25 05:15:15.745344
2026-09-26 05:00:00.000000	RRSFF	45.2	false	∅	∅	2026-09-25 05:15:15.745344
2026-09-26 05:00:00.000000	REGUP	260.3	false	∅	∅	2026-09-25 05:15:15.745344
2026-09-26 05:00:00.000000	REGDN	267	false	∅	∅	2026-09-25 05:15:15.745344

Coverage

94.2% complete17 gap days278 days with data

Show coverage history

Coverage: 94.2%Days with data: 278Gaps: 17

2026

2025

gaplessmore

Related ancillary services data

Related ancillary services data
Dataset	Description
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.
DAM Energy Storage Resource Data (60-Day)ERCOT · hourly (DAM), 60-day disclosure	What each ERCOT battery offered into the Day-Ahead Market and what it was awarded, hour by hour, from the 60-Day DAM Disclosure Reports. Like the SCED storage file this subreport begins at RTC+B go-live on 6 December 2025. Each row is one hour for one storage resource and its QSE, carrying the QSE's submitted energy curve as up to ten monotonic MW/price pairs, the resource's high and low sustainable limits and status, the awarded energy quantity, its settlement point and that point's day-ahead price, and its ancillary awards with the matching market clearing price for capacity in each service (Reg-Up, Reg-Down, RRS-PFR, RRS-FFR, RRS-UFR, ECRS, Non-Spin). This is where day-ahead storage strategy is legible: how a fleet split its capacity between energy and reserves, what it was paid for each, and how its bid curve related to the price that cleared. It is a cleared-market record on a 60-day regulatory delay, not a live feed. Measured 2026-09-07: 3.2 million rows. The official source is ERCOT report NP3-966-ER, 60-Day DAM Disclosure Reports.
ERCOT Day-Ahead Ancillary PricesERCOT · hourly (day-ahead)	Cleared day-ahead ancillary-service capacity prices in ERCOT, one row per hour and product. 365,717 rows, 2017-01 to the next delivery day. Products: reg_up, reg_down, spin, non_spin, ecrs. ERCOT procures ancillary services system-wide, so there is no region column — one price per product per hour. price_usd_mw is a price for CAPACITY held in reserve — dollars per megawatt of commitment — not dollars per megawatt-hour of energy delivered. The two are different units and are not comparable to an LMP.
Real-Time Ancillary-Service CapabilityERCOT · 5-minute (SCED)	ERCOT's current NP6-328-CD RTC+B report of total Resource capability available for ancillary-service combinations, one row per SCED execution and AS combination. Values are based on QSE telemetry, capped by Resource limits and, for batteries, by the service's duration requirement and available state of charge. This is the live replacement for the retired System AS Capacity Monitor, but it is capability—not procured awards, deployed reserves, or proof of a price cause.