Ask the Grid

Overview

Transmission constraints binding in SPP's day-ahead market, published hourly for the delivery day with the constraint name, shadow price, direction, and the monitored limit and flow in MW. Pairs with the real-time binding-constraint table to compare which constraints the day-ahead market anticipated against those that actually bound in real time. As with the real-time table, no contingency or monitored-facility name is published.

Schema7

Column
Type
event_timeDateTime64(6, 'UTC')
constraint_nameLowCardinality(String)
shadow_priceNullable(Float64)
directionNullable(String)
limit_mwNullable(Float64)
flow_mwNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample rows

event_timeconstraint_nameshadow_pricedirectionlimit_mwflow_mwingested_at
2026-08-05 04:00:00.000000TP1134_32007-36.8082026-08-05 11:15:25.984157
2026-08-05 04:00:00.000000TMP845_30027-7.10382026-08-05 11:15:25.984157
2026-08-05 04:00:00.000000TMP796_28794-11.95312026-08-05 11:15:25.984157
2026-08-05 04:00:00.000000TMP338_28287-23.64462026-08-05 11:15:25.984157
2026-08-05 04:00:00.000000TMP336_31246-12.27072026-08-05 11:15:25.984157
2026-08-05 04:00:00.000000TMP128_29363-250.49272026-08-05 11:15:25.984157
2026-08-05 04:00:00.000000TEMP90_26027-86.25872026-08-05 11:15:25.984157
2026-08-05 04:00:00.000000TEMP89_22229-26.84332026-08-05 11:15:25.984157
2026-08-05 04:00:00.000000SOONER_SONR_SONR_PHSHFT_PS-0.37942026-08-05 11:15:25.984157
2026-08-05 04:00:00.000000SMKSUMPOSAXT-26.31342026-08-05 11:15:25.984157
2026-08-05 04:00:00.000000Ozrk_B-xfmr_A-3.81412026-08-05 11:15:25.984157
2026-08-05 04:00:00.000000OSAWEBCLESOO-128.55152026-08-05 11:15:25.984157
2026-08-05 04:00:00.000000MAUCARSIBOVE-12.59542026-08-05 11:15:25.984157
2026-08-05 04:00:00.000000CIMXF2CIMXF3-24.8442026-08-05 11:15:25.984157
2026-08-05 04:00:00.000000ALIANSNAKE11_11_LN@ALIANCE<7715>22.03692026-08-05 11:15:25.984157
2026-08-05 03:00:00.000000VINHAYKNOXFR-29.36162026-08-05 11:15:25.984157
2026-08-05 03:00:00.000000TP1241_33286-4.98862026-08-05 11:15:25.984157
2026-08-05 03:00:00.000000TP1134_32007-28.9042026-08-05 11:15:25.984157
2026-08-05 03:00:00.000000TP1078_31925-6.74542026-08-05 11:15:25.984157
2026-08-05 03:00:00.000000TMP845_30027-8.49662026-08-05 11:15:25.984157
2026-08-05 03:00:00.000000TMP796_28794-34.91952026-08-05 11:15:25.984157
2026-08-05 03:00:00.000000TMP677_28355-34.66312026-08-05 11:15:25.984157
2026-08-05 03:00:00.000000TMP595_32603-0.96772026-08-05 11:15:25.984157
2026-08-05 03:00:00.000000TMP348_25258-47.76632026-08-05 11:15:25.984157
2026-08-05 03:00:00.000000TMP336_31246-7.99642026-08-05 11:15:25.984157

Coverage

100.0% complete0 gap days582 days with data
Show coverage history ▾
Coverage: 100.0%Days with data: 582Gaps: 0
2026
2025
gaplessmore