CRR Monthly Auction Results

Cleared 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.

Congestion & Constraints data ERCOT market

Query with the agent

Native record

CRR award x time-of-use block x delivery term x auction posting vintage

monthly auction posting publication cadence

Evidence

Observed market data

Published observations from the named source

Time basis

Point-in-time records

UTC · event_time

Overview

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.

Query contract

Keep source_time as the auction-posting vintage. Do not collapse awards from distinct auction postings or delivery terms.

Analysis rules

Group source-to-sink paths only within the same delivery term, time-of-use block, hedge type, bid type, and auction posting.
Do not compute a gross, total auction cost, or acquisition value from MW and shadow_price_per_mwh. Their product is not a total dollar value; the applicable delivery hours and authoritative time-of-use calendar are not expanded in this table.

Interpretation

Auction clearing price is acquisition evidence, not realized congestion revenue, payout, underfunding, or net profit.
A highest-grossing or total-cost ranking is unavailable from this dataset alone because it lacks realized settlements and an expanded authoritative delivery-hour calendar.

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_crr_auction_results/query

Need the full history of this dataset in Snowflake, Databricks or your own storage? Data services delivers it on a schedule.

Schema19

Column

Type

event_timeDateTime64(6, 'UTC')

source_timeDateTime64(6, 'UTC')

crr_idLowCardinality(String)

time_of_useLowCardinality(String)

original_crr_idNullable(String)

account_holderNullable(String)

hedge_typeNullable(String)

bid_typeNullable(String)

crr_typeNullable(String)

sourceNullable(String)

sinkNullable(String)

start_dateNullable(Date32)

end_dateNullable(Date32)

bid_24hourNullable(String)

mwNullable(Float64)

shadow_price_per_mwhNullable(Float64)

emil_idNullable(String)

doc_idNullable(Int64)

ingested_atDateTime64(6, 'UTC')

Sample data

event_time	source_time	crr_id	time_of_use	original_crr_id	account_holder	hedge_type	bid_type	crr_type	source	sink	start_date	end_date	bid_24hour	mw	shadow_price_per_mwh	emil_id	doc_id	ingested_at
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729210	PeakWE	216647759	XBIOUR	OPT	SELL	STANDARD	INGLCO_PUN3	INGLCO_PUN1	2026-10-01	2026-10-31	No	2.6	0.3	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729208	PeakWE	186515117	XUNTX2	OPT	SELL	STANDARD	LZ_WEST	AJAXWIND_RN	2026-10-01	2026-10-31	No	0.7	0.593499	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729204	PeakWD	216820222	XTEFL1	OPT	SELL	STANDARD	JUNCTION_RN	BATCAVE_RN	2026-10-01	2026-10-31	No	1.9	3.083736	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729203	PeakWD	216820222	XTEFL1	OPT	SELL	STANDARD	JUNCTION_RN	BATCAVE_RN	2026-10-01	2026-10-31	No	1.9	3.083736	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729202	PeakWE	207096436	XUSRM	OPT	SELL	STANDARD	LILY_RN	STRATEGC_RN	2026-10-01	2026-10-31	No	19	0.2636	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729200	PeakWD	186635171	XRESIS	OPT	SELL	STANDARD	DDPEC_ST1	PSA_PUN4	2026-10-01	2026-10-31	No	4	1.175589	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729199	PeakWD	207043073	XPERAS	OPT	SELL	STANDARD	BRAZ_WND_ALL	CSC_CSECG1_2	2026-10-01	2026-10-31	No	4.6	0.115929	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729198	Off-peak	216633999	XMETT3	OPT	SELL	STANDARD	TGW_T1_T2	LMAJADAS_ALL	2026-10-01	2026-10-31	No	16	0.51	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729195	PeakWD	216710870	XSUEZ3	OBL	SELL	STANDARD	AZURE_RN	MONT_WND_RN	2026-10-01	2026-10-31	No	0.8	0.017218	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729194	Off-peak	206868307	XBIOUR	OPT	SELL	STANDARD	PTLBES_BESS1	BAYC_BESS_RN	2026-10-01	2026-10-31	No	2	4.368768	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729193	PeakWE	206928129	XDYNE3	OPT	SELL	STANDARD	CSC_CSECG1_2	JADE_SLR_ALL	2026-10-01	2026-10-31	No	0.8	1.256243	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729192	PeakWD	206958488	XDYNE2	OPT	SELL	STANDARD	FOXTROT_ALL	KARAKAW1_1	2026-10-01	2026-10-31	No	2	2.810676	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729190	PeakWD	186464729	XATNV	OPT	SELL	STANDARD	ANCHOR_ALL	BAIRDWND_ALL	2026-10-01	2026-10-31	No	25	0.707619	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729189	PeakWD	197027354	XDYNE3	OPT	SELL	STANDARD	SCES_UNIT1	PHILLWND_ALL	2026-10-01	2026-10-31	No	2	2	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729187	PeakWD	216766905	XGBPP1	OPT	SELL	STANDARD	QUEEN_BA_RN	OECCS_1	2026-10-01	2026-10-31	No	12.9	0.724478	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729185	PeakWE	176941431	XSNDA1	OPT	SELL	STANDARD	SHAFFER_ALL	CRANELL_ALL	2026-10-01	2026-10-31	No	0.5	1.455761	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729184	PeakWE	176941431	XSNDA1	OPT	SELL	STANDARD	SHAFFER_ALL	CRANELL_ALL	2026-10-01	2026-10-31	No	0.5	1.455761	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729183	PeakWE	176941431	XSNDA1	OPT	SELL	STANDARD	SHAFFER_ALL	CRANELL_ALL	2026-10-01	2026-10-31	No	0.5	1.455761	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729180	PeakWD	207219093	XCITA1	OPT	SELL	STANDARD	TNSKA_CCU	DC_E	2026-10-01	2026-10-31	No	2.4	3.585964	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729179	Off-peak	216836905	XECNR2	OPT	SELL	STANDARD	HB_NORTH	LZ_NORTH	2026-10-01	2026-10-31	No	12.5	0.253231	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729176	PeakWD	186500185	XSNDA1	OPT	SELL	STANDARD	SHANNONW_RN	WCPP_CT1	2026-10-01	2026-10-31	No	1.4	3.332832	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729175	PeakWD	186500185	XSNDA1	OPT	SELL	STANDARD	SHANNONW_RN	WCPP_CT1	2026-10-01	2026-10-31	No	1	3.332832	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729174	PeakWD	186500185	XSNDA1	OPT	SELL	STANDARD	SHANNONW_RN	WCPP_CT1	2026-10-01	2026-10-31	No	1	3.332832	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729172	PeakWD	216952964	XKNOA2	OPT	SELL	STANDARD	TC_PUN1	PRO_RN	2026-10-01	2026-10-31	No	0.3	2.083819	NP7-803-M	1275599428	2026-10-12 09:00:59.772169
2026-10-01 05:00:00.000000	2026-09-17 13:00:48.000000	225729170	PeakWE	176857264	XMEA	OPT	SELL	STANDARD	EXN_PUN1	CBY_CBY_G1	2026-10-01	2026-10-31	No	11.6	0.144581	NP7-803-M	1275599428	2026-10-12 09:00:59.772169

Coverage

3.5% complete442 gap days16 days with data

Show coverage history

Coverage: 3.5%Days with data: 16Gaps: 442

2026

2025

gaplessmore

Related congestion & constraints data

Related congestion & constraints data
Dataset	Description
Constraint Shift Factor RunsERCOT · nightly (one row per completed run)	One row per COMPLETED nightly estimation of ERCOT constraint shift factors, and the only record that a run finished. Resolve the latest usable run here — computed_at = (SELECT max(computed_at) FROM atg.ercot_constraint_sensitivity_runs) — and never off max(computed_at) of the sensitivities themselves, because a run writes its rows in blocks that all carry the new timestamp and an unfinished or abandoned run would otherwise look like the newest one. Each row also carries how much evidence that run had: interval_coverage is the fraction of published dispatch intervals that survived admission, intervals_refused_unexplained counts intervals showing congestion with no constraint recorded as binding (an unobserved binding set), constraint_feed_lag_minutes is how far the constraint feed trailed the price feed, and constraints_seen / constraints_in_fit / constraints_reported show how many constraints bound, how many were good enough to control for, and how many earned a published estimate.
Constraint Shift Factors (Estimated)ERCOT · nightly (60-day rolling estimation window)	Estimated sensitivity of every ERCOT pricing location's price to every binding transmission constraint: one row per constraint, contingency, and location, recomputed nightly over a rolling 60-day window. This is what answers 'which nodes drive this constraint' and 'which constraints is this node exposed to'. Covers ERCOT's transmission constraints with their contingency and both named terminals, over 1,123 settlement points. shift_factor is in the ISO's orientation — POSITIVE means an incremental MW injected at that node increases loading on the constraint and the node is paid below system lambda while it binds; NEGATIVE means generation there relieves the constraint and earns a premium. These are ESTIMATES recovered from the price identity LMP = energy - sum(shift_factor x shadow_price), not a published PTDF matrix. They are measured RELATIVE TO THE MARKET'S REFERENCE — the identity yields SF(node) - SF(reference), so a single absolute value should be quoted as 'relative to the system reference' rather than as the node's PTDF, while DIFFERENCES between nodes are exact because the reference term cancels. Three further differences from a published matrix: they describe a NODE (a generator at that node inherits its location's value, and two units at one node are indistinguishable), they reflect the topology actually in effect across the window including outages rather than a stated base case, and every one carries a std_error from a 200-draw block bootstrap that resamples whole days. Read std_error before quoting shift_factor: an estimate whose absolute value is not at least twice its standard error is not distinguishable from zero. estimation_status says why a row has no number — 'thin_support' (in the fit, so it is controlled for, but under 12 binding intervals or under 3 distinct binding days), 'no_support' (under 3 binding intervals; not a regressor), or 'collinear' (it bound in lockstep with another constraint, so the two cannot be separated). Where from_station and to_station are populated they identify the monitored element and are NOT the constrained direction — the sign of shift_factor is what says which way. Every read must pin computed_at to one run, and must resolve that run through the companion atg.<iso>_constraint_sensitivity_runs ledger rather than off max(computed_at) here — rows are written in blocks that all carry the new timestamp, so an unfinished or abandoned run would otherwise look like the newest. Mixing runs averages a node across different network topologies.
Day-Ahead Shadow Prices & Binding ConstraintsERCOT · hourly (DAM)	Binding transmission constraint and contingency pairs from ERCOT's Day-Ahead Market solution, one row per constraint, contingency, and delivery hour, including the limiting facility, its from and to stations, the constraint limit, flow, and violation in MW, and the shadow price. A row establishes that the named constraint bound in the cleared day-ahead solution for that hour and its marginal system cost. It does not, by itself, identify which settlement point or hub the constraint affected, or establish that the constraint bound in real time; the first requires shift-factor or direct attribution evidence, and real-time binding is recorded in the SCED shadow prices. The official source is ERCOT report NP4-191-CD.
ERCOT Day-Ahead Binding ConstraintsERCOT · hourly (DAM)	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.