Real-Time Binding Constraints

Transmission constraints binding in SPP's real-time balancing market, published every five minutes with the opaque constraint ID, constraint type, NERC flowgate ID where present, TLR level, binding state, source-published monitored and contingent facilities, three limit fields, and the E/W interconnect marker.

Congestion & Constraints data

Open in Data

One row per: event_time x constraint_name x interconnect x constraint_type x nerc_id x monitored_facility x contingent_facility x contingency_name; 5-minute cadence
Evidence: Observed market data; Published observations from the named source
Time basis: Point-in-time records; UTC · event_time

Overview

A non-zero shadow price is direct evidence that the source identity was binding and pricing congestion in that interval. SPP does not publish flow or direction in this feed, and a facility label is source context rather than a match to a physical topology entity.

Query contract: Preserve one canonical row per (event_time, constraint_name, interconnect, constraint_type, nerc_id, monitored_facility, contingent_facility, contingency_name) before aggregating.
Analysis rules: Group only after preserving the declared grain: event_time, constraint_name, interconnect, constraint_type, nerc_id, monitored_facility, contingent_facility, contingency_name.

Access

Download: Query it in SQL, download it, or read it with an API key. Download data
Full history: Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

21 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`constraint_name`	`LowCardinality(String)`
`shadow_price`	`Nullable(Float64)`
`direction`	`Nullable(String)`
`limit_mw`	`Nullable(Float64)`
`flow_mw`	`Nullable(Float64)`
`ingested_at`	`DateTime64(6, 'UTC')`
`source_interval`	`Nullable(String)`
`source_gmt_interval_end`	`Nullable(String)`
`constraint_type`	`Nullable(String)`
`nerc_id`	`Nullable(String)`
`tlr_level`	`Nullable(String)`
`binding_status`	`Nullable(String)`
`monitored_facility`	`Nullable(String)`
`contingent_facility`	`Nullable(String)`
`contingency_name`	`Nullable(String)`
`source_limit_mw`	`Nullable(Float64)`
`effective_limit_mw`	`Nullable(Float64)`
`initial_limit_mw`	`Nullable(Float64)`
`interconnect`	`Nullable(String)`
`source_file`	`Nullable(String)`

Sample data

event_time	constraint_name	shadow_price	direction	limit_mw	flow_mw	ingested_at	source_interval	source_gmt_interval_end	constraint_type	nerc_id	tlr_level	binding_status	monitored_facility	contingent_facility	contingency_name	source_limit_mw	effective_limit_mw	initial_limit_mw	interconnect	source_file
2026-11-03 23:30:00.000000	TP1368_33529	0	∅	365.75	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	FG	33529	CME	ACTIVATED	XFMR SPERVI1 - SPERVI1	SECI:CLARKCO THISTLE7:345:2:11	∅	385	365.75	373.45	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TP1363_33522	0	∅	168.15	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	FG	33522	CME	ACTIVATED	LN WHEELER - HOWARD3	CSWS:CHISHOLM SWEETWT6:230:1:16	∅	177	168.15	171.69	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TP1352_33578	0	∅	182.4	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	M2M	33578	CME	ACTIVATED	LN MRYVL_SJ - MIDWAY5	MEC:BRADDCTR CLARNDA:161:1:8	∅	192	182.4	186.24	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TP1344_33575	0	∅	72.54	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	M2M	33575	CME	ACTIVATED	LN ARENDS - FOSTRACB	ALTW:LAKEFLD DICY:161:1:5	∅	78	72.54	75.66	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TP1341_33544	0	∅	255.55	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	FG	33544	CME	ACTIVATED	XFMR ARSENAL - ARSENAL	CSWS:TRICHEL FORTHUM ARSENAL:138:3	∅	269	255.55	260.93	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TP1340_33561	0	∅	310.62	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	M2M	33561	CME	ACTIVATED	LN SIBLY161 - ECKLES	MPS AMRN:SIBLEY OVER:345:2:9	∅	334	310.62	323.98	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TP1338_33520	-108.3724	∅	202.02	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	FG	33520	CME	BINDING	LN STILW1 - SPVALLY2	GRDA OKGE:CLEVLND7 WHTETAIL:345:1:	∅	222	202.02	215.34	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TP1259_33585	0	∅	317.3	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	M2M	33585	CME	ACTIVATED	LN BATFLD5 - SPRGFLD	SPA AECI:SPRGFLD BROOK_LN:161:1:8	∅	334	317.3	323.98	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TP1255_33589	0	∅	208.32	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	FG	33589	CME	ACTIVATED	LN JAY_HAWK - MARM	EDE:CAR395 ASB3491:161:2:11	∅	224	208.32	217.28	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TP1236_32786	0	∅	152.1	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	FG	32786	CME	ACTIVATED	LN CORNTP4 - NAPLES1	OKGE:GRACMONT MINCO:345:1:11	∅	169	152.1	163.93	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TP1113_31962	0	∅	531.05	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	FG	31962	CME	ACTIVATED	XFMR POTTER_S - POTTER_S	CSWS:OKLAUNIO LAW_ES:345:1:9	∅	559	531.05	542.23	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TP1040_31783	0	∅	210.9	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	FG	31783	CME	ACTIVATED	LN CKSKI1 - KILDR	OKGE WR:RENFROW7 VIOLA7:345:1:10	∅	222	210.9	215.34	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TP1011_32349	0	∅	125.4	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	M2M	32349	CME	ACTIVATED	LN JAMESTN - CARNGTN	WAUE:PICKRTWA JAMESTN:230:1:4	∅	132	125.4	128.04	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TMP994_33360	0	∅	126.48	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	FG	33360	CME	ACTIVATED	LN ELRENOJ2 - ELRENO1	OKGE:CTNWD1 CRESCENT:138:1:11	∅	136	126.48	131.92	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TMP951_32303	0	∅	177.63	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	FG	32303	CME	ACTIVATED	LN 59TH - ELPA	WR:WICH BENT:345:1:8	∅	191	177.63	185.27	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TMP870_33415	0	∅	109.2	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	FG	33415	CME	ACTIVATED	LN BRULE - B_SPRGS	NPPD:SIDNEY OGALALA:230:1:5	∅	120	109.2	116.4	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TMP845_30027	0	∅	76.95	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	FG	30027	CME	ACTIVATED	LN MARSHAL3 - KNOB	WR:MARSHAL3 SSEN:115:2:12	∅	81	76.95	78.57	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TMP791_29987	0	∅	188.1	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	FG	29987	CME	ACTIVATED	LN FLCH_TMP - LAW_ES	CSWS:TREASURE LAW_ES:345:1:9	∅	198	188.1	192.06	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TMP786_32375	0	∅	225	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	M2M	32375	CME	ACTIVATED	XFMR GARRISN - GARRISN	WAUE GRE:LELANDO STANTON2:230:1:7	∅	250	225	242.5	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TMP775_29068	0	∅	531.05	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	FG	29068	CME	ACTIVATED	XFMR POTTER_S - POTTER_S	SPS:CROSSRDS TOLKSUB:345:1:12	∅	559	531.05	542.23	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TMP688_29274	0	∅	365.75	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	FG	29274	CME	ACTIVATED	XFMR SPERVI1 - SPERVI1	MIDW SECI:POSTROCK SPERVI1:345:2:1	∅	385	365.75	373.45	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TMP630_33215	0	∅	508.69	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	FG	33215	CME	ACTIVATED	XFMR POTTER_S - POTTER_S	SPS:HITCH XF HITCH_230_345:345 230	∅	559	508.69	542.23	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TMP608_33377	0	∅	114	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	FG	33377	CME	ACTIVATED	LN B_SPRGS - BRULE	NPPD:SIDNEY OGALALA:230:1:5	∅	120	114	116.4	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TMP555_29231	-10.868	∅	531.05	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	FG	29231	CME	BINDING	XFMR POTTER_S - POTTER_S	SPS:HOBBS:COMBINEDCYCLE	∅	559	531.05	542.23	E	/RTBM-BC-latestInterval.csv
2026-11-03 23:30:00.000000	TMP539_25534	0	∅	110.67	∅	2026-11-03 23:33:23.839804	11/03/2026 17:35:00	11/03/2026 23:35:00	M2M	25534	CME	ACTIVATED	XFMR MAURINE - MAURINE	WAUE:MAURINE NUNDRWD:230:2:10	∅	119	110.67	115.43	E	/RTBM-BC-latestInterval.csv

Coverage

Complete: 100.0%
Gap days: 0
Days with data: 3,594

Show coverage history

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

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

gaplessmore

Related data

Related congestion & constraints data
Dataset	Description
Constraint Identity EvidenceSPP · Built from daily DA/RT source evidence	Bitemporal, source-backed identities for SPP binding constraints. Each row preserves the raw operator ID and footprint, exact monitored-facility, contingent-facility, contingency and public flowgate context, evidence locator and version, observed and authoritative effective intervals, match method, confidence, review status, and resolution status. Source-exact and reviewed-exact mappings are distinguished from unresolved, contradictory, and rejected rows. The canonical constraint ID is an SPP source identity, not a physical line or substation ID.
Constraint Identity QualitySPP · Per identity build	One quality row per identity build: observed and distinct raw IDs, resolved/partial/unresolved/contradictory/rejected counts, resolution rate, stale reviewed mappings, one-to-many cases, missing footprint markers, SPP East/West ambiguity, and any source-key loss. This reports the evidence boundary rather than inflating resolution with text or geographic guesses.
Day-Ahead Binding ConstraintsSPP · Hourly (Day-Ahead)	Transmission constraints binding in SPP's day-ahead market, published hourly for the delivery day with the opaque constraint ID, constraint type, NERC flowgate ID where present, binding state, source-published monitored and contingent facilities, contingency name, and the E/W interconnect marker. Pairs with the real-time table to compare which exact source identities the day-ahead market anticipated. This feed does not publish direction, flow, or limits, and its facility labels are source context rather than physical topology matches.
SPP Day-Ahead Binding ConstraintsSPP · hourly	Which transmission facilities bound in SPP's day-ahead market and what each one cost, one row per interval and constraint. Inspect the current measured time coverage. Columns: event_time, constraint_name, shadow_price_usd_mwh, plus constraint_type, nerc_id, binding_status, monitored_facility, contingent_facility, contingency_name, interconnect and source_file. The day-ahead feed does not publish direction, flow or limits. 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.