Overview

Which transmission facilities bound in ERCOT's day-ahead market and what each one cost, one row per interval and constraint. 2.94M rows, 2017-01 to the next delivery day. Columns: event_time, constraint_name, shadow_price_usd_mwh, plus contingency, from_station and to_station, limit_mw and flow_mw. The shadow price is the marginal cost of the binding limit — what the market would have saved from one more megawatt of capability on that element. This is the table that answers WHY congestion appeared; a price spread between two locations shows that they separated but not which facility separated them.

ERCOT market Ask the agent about this dataset

Use with MCP

This table is readable two ways, over the same guarded boundary. Over HTTP: POST /api/v1/datasets/ercot_constraints_da/query, described in the API reference. Or from an MCP client: connect a market below, then use search_data or describe_data to load its query contract before calling query_data.

ERCOT MCP Server

Schema8

Column

Type

event_timeDateTime64(6, 'UTC')

constraint_nameLowCardinality(String)

contingencyLowCardinality(String)

from_stationLowCardinality(Nullable(String))

to_stationLowCardinality(Nullable(String))

shadow_price_usd_mwhNullable(Float64)

limit_mwNullable(Float64)

flow_mwNullable(Float64)

Sample rows

event_time	constraint_name	contingency	from_station	to_station	shadow_price_usd_mwh	limit_mw	flow_mw
2026-08-28 05:00:00.000000	SANA_FMR1	SCOLBAL8	SANA	SANA	7.713	50	50
2026-08-28 05:00:00.000000	NLARSW_PILONC1_1	DFOAVLO5	NLARSW	PILONCIL	2.506	138	138
2026-08-28 05:00:00.000000	MIL_LIPAN_1	SGRSMNW8	LONG	LIPAN	4.072	230	230
2026-08-28 05:00:00.000000	MH_PP_1	SSTILOM8	MILHWY	SILASRAY	0.168	259	259
2026-08-28 05:00:00.000000	MAGRUD_VICTOR2_1	SCOLPAW5	VICTORIA	MAGRUDER	0.294	239	239
2026-08-28 05:00:00.000000	LPLMK_LPLNE_1	SBWDDBM5	LPLMK	LPLNE	1.314	218	218
2026-08-28 05:00:00.000000	LPLMK_LPLCO_1	XLP259	LPLCO	LPLMK	1.6	131	131
2026-08-28 05:00:00.000000	LENSW_PUTN2_1	SCISPUT8	LENSW	PUTN	1.042	87	87
2026-08-28 05:00:00.000000	HEXT_YELWJC1_1	DYETRJU8	YELWJCKT	HEXT	10.431	30	30
2026-08-28 05:00:00.000000	HARGRO_TWINBU1_1	SRUSBIG8	TWINBU	HARGROVE	1.195	151	151
2026-08-28 05:00:00.000000	HARGRO_TWINBU1_1	DBAKCED5	TWINBU	HARGROVE	12.272	151	151
2026-08-28 05:00:00.000000	FORTMA_YELWJC1_1	STREMAD8	FORTMA	YELWJCKT	5.699	151	151
2026-08-28 05:00:00.000000	FORTMA_YELWJC1_1	DBIGKEN5	FORTMA	YELWJCKT	5.95	151	151
2026-08-28 05:00:00.000000	E_PASP	BASE CASE	∅	∅	0.982	541	541
2026-08-28 05:00:00.000000	ESCOND_GANSO1_1	SBRAHAM8	ESCONDID	GANSO	10.023	122	122
2026-08-28 05:00:00.000000	DOWNIE_READIN1_1	SW_BBAT8	DOWNIES	READING	1.514	139	139
2026-08-28 05:00:00.000000	CELANE_N_SHAR1_1	SN_SAJO5	CELANEBI	N_SHARPE	0.192	239	239
2026-08-28 05:00:00.000000	BRUNI_69_1	SLAQLOB8	BRUNI	BRUNI	37.346	37	37
2026-08-28 05:00:00.000000	BIG_COTU_1	SBE2ASH8	COTULAS	BIGWELS	2.779	74	74
2026-08-28 05:00:00.000000	BENTS_FRTER_1B_1	SSHAFRO8	FRONTERA	S_MISSIN	27.045	213	213
2026-08-28 05:00:00.000000	6945__A	SRGRMGS5	MGSES	CATSW	70.722	1200	1200
2026-08-28 05:00:00.000000	6635__G	SCLCGTN8	MRVLY	ESTLD	13.071	31	31
2026-08-28 05:00:00.000000	2585_1	SBATPAL8	MOORE	DOWNIES	2.502	122	122
2026-08-28 05:00:00.000000	221T355_1	SGEOHU48	CHIEBR	GEORGE	0.533	262	262
2026-08-28 05:00:00.000000	138_FTS_LNC_1	SLEOSGA8	FTST	LEONCRK	0.326	248	248

Coverage

100.0% complete0 gap days3,526 days with data

Show coverage history ▾

Coverage: 100.0%Days with data: 3,526Gaps: 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

gaplessmore

More data from ERCOT

Ancillary Service PricesHourly 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.CRR Monthly Auction ResultsCleared ERCOT monthly Congestion Revenue Right auction awards, one row per source-to-sink CRR and time-of-use block, including awarded MW and the auction shadow price per MWh. This is public auction evidence for who acquired a path and at what clearing price. It does not contain realized day-ahead congestion settlements, fees, later trades, the holder's full portfolio, or net profit, so auction cost must not be described as payout or profitability. The official source is ERCOT report NP7-803-M.Current Supply, Demand & Intraday ForecastERCOT's public real-time supply and demand dashboard at five-minute resolution. This is the preferred dataset for a current actual-versus-forecast demand comparison: series='realized' reports observed demand_mw, series='intraday_forecast' reports demand_mw forecast for the same target event_time at successive source_time vintages, and series='forward_forecast' reports forecasted_demand_mw farther ahead. It also carries committed and available capacity. Operators, traders, and researchers use it to measure current forecast error, headroom, and how forecasts converge toward realized demand.DAM Settlement Point PricesHourly settlement point prices cleared in the ERCOT Day-Ahead Market, covering every settlement point in Texas (load zones, hubs, and resource nodes). These are the prices at which energy is bought and sold a day in advance of delivery, set the afternoon before each operating day. They are the day-ahead counterpart to real-time locational prices, and the gap between the two reflects how the market expected conditions to differ from how they actually unfolded. Traders use them to position and hedge, generators and loads use them to plan commitments, and researchers use them to study how congestion and scarcity show up across the grid.