SPP logo

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.

Native record
event_time x constraint_name x interconnect x constraint_type x nerc_id x monitored_facility x contingent_facility x contingency_name
5-minute publication 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.

Schema21

Column
Type
event_timeDateTime64(6, 'UTC')
constraint_nameLowCardinality(String)
shadow_priceNullable(Float64)
directionNullable(String)
limit_mwNullable(Float64)
flow_mwNullable(Float64)
ingested_atDateTime64(6, 'UTC')
source_intervalNullable(String)
source_gmt_interval_endNullable(String)
constraint_typeNullable(String)
nerc_idNullable(String)
tlr_levelNullable(String)
binding_statusNullable(String)
monitored_facilityNullable(String)
contingent_facilityNullable(String)
contingency_nameNullable(String)
source_limit_mwNullable(Float64)
effective_limit_mwNullable(Float64)
initial_limit_mwNullable(Float64)
interconnectNullable(String)
source_fileNullable(String)

Sample data

event_timeconstraint_nameshadow_pricedirectionlimit_mwflow_mwingested_atsource_intervalsource_gmt_interval_endconstraint_typenerc_idtlr_levelbinding_statusmonitored_facilitycontingent_facilitycontingency_namesource_limit_mweffective_limit_mwinitial_limit_mwinterconnectsource_file
2026-09-19 22:05:00.000000VINHAYKNOXFR0952026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00FG5406CMEACTIVATEDLN VINETAP3 - NHAYSMIDW:KNOLL1 XF A:230 115:1:61009597E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TP1268_331720122.852026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00FG33172CMEACTIVATEDLN CUDAHY1 - KISMETSECI:BUCKNER7 HOLCOM1:345:1:13135122.85130.95E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TP1243_33405091.912026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00FG33405CMEACTIVATEDLN SEWARD3 - ST-JOHNSECI:CLARKCO THISTLE7:345:2:1110191.9197.97E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TP1241_332860280.282026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00FG33286CMEACTIVATEDLN MDWST - FRNKLN1OKGE:CDRLN BOYD:138:1:13308280.28298.76E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TP1236_327860153.792026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00FG32786CMEACTIVATEDLN CORNTP4 - NAPLES1OKGE:GRACMONT MINCO:345:1:11169153.79163.93E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TP1214_32539068.9782026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00FG32539CMEACTIVATEDXFMR DUNCAN - DUNCANOKGE CSWS:SUNNYSDE TERRY_RD:345:2:75.868.97873.53E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TP1198_33127037.052026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00FG33127CMEACTIVATEDLN HOSSTON - PLAINDEACSWS:NBENTON LIEBERM:138:1:113937.0537.83E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TP1191_32124-1500373.352026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00FG32124CMEBREACHEDXFMR NOWST1 - NOWST1OKGE:NOWST1 XF XF3T:345 138 13.8:3393373.35381.21E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TP1160_333180344.352026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00FG33318CMEACTIVATEDLN BROOK_LN - JUNCTN5SPRM:MAIN1 BATFLD5:161:1:8355344.35344.35E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TP1154_32011-1118.9762357.632026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00FG32011CMEBREACHEDXFMR NOWST1 - NOWST1OKGE:NOWST1 XF B_T:345 138 13.8:3:393357.63381.21E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TP1139_32022063.72026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00FG32022CMEACTIVATEDLN MARSHAL3 - KNOBSECI:CONCOR3 CLIFTO1:115:1:97063.767.9E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TP1136_320150269.362026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00FG32015CMEACTIVATEDLN GORD - MAIZWR:WICH BENT:345:1:8296269.36287.12E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TP1121_319790183.352026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00FG31979CMEACTIVATEDLN JAY_HAWK - FRANKLN5EDE WR:RAM452 NSES:161:1:5193183.35187.21E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TP1119_319840182.912026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00FG31984CMEACTIVATEDLN JAGG - PENTWR:87TH_ST STRA:345:1:9201182.91194.97E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TP1115_33373-40.5516251.162026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00FG33373CMEBINDINGXFMR MSTNG - MSTNGSPS:SEMIN MSTNG:230:1:9273251.16264.81E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TP1100_3191804752026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00M2M31918CMEACTIVATEDXFMR FTSMTH - FTSMTHOKGE:FTSMTH XF T5_T:345 161:3:13500475485E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TP1084_319210292.62026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00FG31921CMEACTIVATEDLN CIMARRON - HAYMAKR4OKGE:CKHAL XEROX CIMARRON:138:2:18308292.6298.76E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TMP994_333600123.762026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00FG33360CMEACTIVATEDLN ELRENOJ2 - ELRENO1OKGE:CTNWD1 CRESCENT:138:1:11136123.76131.92E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TMP972_333800211.852026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00FG33380CMEACTIVATEDLN OVRLD_PK - MERRIAM2KCPL:NASHUA IATAN:345:1:11223211.85216.31E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TMP951_323030172.92026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00FG32303CMEACTIVATEDLN 59TH - ELPAWR:WICH BENT:345:1:8182172.9176.54E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TMP925_296460151.972026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00M2M29646CMEACTIVATEDLN AUR1241 - RDSPG5SPA AECI:TABLE_RK 5RENOHLW 5RIVRSD167151.97161.99E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TMP908_296200103.552026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00FG29620CMEACTIVATEDLN 29EVENG3 - 29GAWR:HOYT JEFF:345:1:6109103.55105.73E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TMP889_328790139.232026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00FG32879CMEACTIVATEDLN STARRDTP - BRNTPOKGE WFEC:BROWN2 SBROWN:138:1:5153139.23148.41E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TMP882_322280156.522026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00FG32228CMEACTIVATEDLN HOYT - 54MRWR:HOYT STRA:345:1:7172156.52166.84E/RTBM-BC-latestInterval.csv
2026-09-19 22:05:00.000000TMP873_33352-81.0792131.132026-09-19 22:07:37.22503809/19/2026 17:10:0009/19/2026 22:10:00FG33352CMEBINDINGLN NORGE_RD - CORNVILLCSWS:CORNVILL SW_STA:138:4:22141131.13136.77E/RTBM-BC-latestInterval.csv

Coverage

100.0% complete0 gap days3,549 days with data
Show coverage history
Coverage: 100.0%Days with data: 3,549Gaps: 0
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
gaplessmore