Ask the Grid
Ask the Grid
Open live grid
SPP logo

DA and RUC Headroom / Floorroom

Published day-ahead market and RUC headroom/floorroom by BAA and native GMT interval end.

Ancillary Services dataSPP market
Query with the agent
Native record
complete source publication × source row ordinal; preserve BAA
source publication publication cadence
Evidence
Forecast data
Forward-looking values with an explicit issue time
Time basis
Interval-end records
UTC · event_time

Overview

It is a cleared/outlook report, not proof of realized operating reserves. Complete views require a matching receipt and mirrored row count; empty results are unknown coverage. Raw sources retain publication history internally.

Query contract

Published day-ahead market and RUC headroom/floorroom by BAA and native GMT interval end. It is a cleared/outlook report, not proof of realized operating reserves. Complete views require a matching receipt and mirrored row count; empty results are unknown coverage. Raw sources retain publication history internally.

Analysis rules

  • Keep SPP East and SWPW West separate. Never combine a published Total with its footprint components.
  • Do not sum model rows, publication attempts, repeated forecast vintages or duplicate weekly report entries as physical capacity.

Interpretation

  • Published day-ahead market and RUC headroom/floorroom by BAA and native GMT interval end. It is a cleared/outlook report, not proof of realized operating reserves. Complete views require a matching receipt and mirrored row count; empty results are unknown coverage. Raw sources retain publication history internally.
  • Model identities are not authoritative physical asset IDs, coordinates, outage attribution or nodal sensitivities.

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.

SPP MCP API reference
HTTP endpoint
POST /api/v1/datasets/spp_public_headroom_floorroom/query

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

Schema15

Column
Type
event_timeDateTime64(6, 'UTC')
published_atDateTime64(6, 'UTC')
snapshot_timeDateTime64(6, 'UTC')
snapshot_idString
row_numberInt64
baaString
source_fileString
source_urlString
content_hashString
record_jsonString
da_headroomNullable(Float64)
da_floorroomNullable(Float64)
ruc_headroomNullable(Float64)
ruc_floorroomNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample data

event_timepublished_atsnapshot_timesnapshot_idrow_numberbaasource_filesource_urlcontent_hashrecord_jsonda_headroomda_floorroomruc_headroomruc_floorroomingested_at
2026-10-12 05:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0448SPPMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/12/2026 00:00:00", "GMT Interval End": "10/12/2026 05:00:00", "BAA": "SPP", "Day Ahead Market Headroom": "933", "Day Ahead Market Floorroom": "0", "Day Ahead RUC Headroom": "933", "Day Ahead RUC Floorroom": "0"}933093302026-10-09 19:50:02.379179
2026-10-12 05:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0496SWPWMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/12/2026 00:00:00", "GMT Interval End": "10/12/2026 05:00:00", "BAA": "SWPW", "Day Ahead Market Headroom": "78", "Day Ahead Market Floorroom": "0", "Day Ahead RUC Headroom": "78", "Day Ahead RUC Floorroom": "0"}7807802026-10-09 19:50:02.379179
2026-10-12 04:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0495SWPWMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/11/2026 23:00:00", "GMT Interval End": "10/12/2026 04:00:00", "BAA": "SWPW", "Day Ahead Market Headroom": "56", "Day Ahead Market Floorroom": "78", "Day Ahead RUC Headroom": "56", "Day Ahead RUC Floorroom": "78"}567856782026-10-09 19:50:02.379179
2026-10-12 04:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0447SPPMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/11/2026 23:00:00", "GMT Interval End": "10/12/2026 04:00:00", "BAA": "SPP", "Day Ahead Market Headroom": "911", "Day Ahead Market Floorroom": "933", "Day Ahead RUC Headroom": "911", "Day Ahead RUC Floorroom": "933"}9119339119332026-10-09 19:50:02.379179
2026-10-12 03:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0494SWPWMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/11/2026 22:00:00", "GMT Interval End": "10/12/2026 03:00:00", "BAA": "SWPW", "Day Ahead Market Headroom": "43", "Day Ahead Market Floorroom": "56", "Day Ahead RUC Headroom": "43", "Day Ahead RUC Floorroom": "56"}435643562026-10-09 19:50:02.379179
2026-10-12 03:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0446SPPMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/11/2026 22:00:00", "GMT Interval End": "10/12/2026 03:00:00", "BAA": "SPP", "Day Ahead Market Headroom": "881", "Day Ahead Market Floorroom": "911", "Day Ahead RUC Headroom": "881", "Day Ahead RUC Floorroom": "911"}8819118819112026-10-09 19:50:02.379179
2026-10-12 02:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0493SWPWMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/11/2026 21:00:00", "GMT Interval End": "10/12/2026 02:00:00", "BAA": "SWPW", "Day Ahead Market Headroom": "16", "Day Ahead Market Floorroom": "43", "Day Ahead RUC Headroom": "16", "Day Ahead RUC Floorroom": "43"}164316432026-10-09 19:50:02.379179
2026-10-12 02:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0445SPPMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/11/2026 21:00:00", "GMT Interval End": "10/12/2026 02:00:00", "BAA": "SPP", "Day Ahead Market Headroom": "687", "Day Ahead Market Floorroom": "881", "Day Ahead RUC Headroom": "687", "Day Ahead RUC Floorroom": "881"}6878816878812026-10-09 19:50:02.379179
2026-10-12 01:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0492SWPWMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/11/2026 20:00:00", "GMT Interval End": "10/12/2026 01:00:00", "BAA": "SWPW", "Day Ahead Market Headroom": "10", "Day Ahead Market Floorroom": "16", "Day Ahead RUC Headroom": "10", "Day Ahead RUC Floorroom": "16"}101610162026-10-09 19:50:02.379179
2026-10-12 01:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0444SPPMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/11/2026 20:00:00", "GMT Interval End": "10/12/2026 01:00:00", "BAA": "SPP", "Day Ahead Market Headroom": "590", "Day Ahead Market Floorroom": "687", "Day Ahead RUC Headroom": "590", "Day Ahead RUC Floorroom": "687"}5906875906872026-10-09 19:50:02.379179
2026-10-12 00:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0491SWPWMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/11/2026 19:00:00", "GMT Interval End": "10/12/2026 00:00:00", "BAA": "SWPW", "Day Ahead Market Headroom": "0", "Day Ahead Market Floorroom": "55", "Day Ahead RUC Headroom": "0", "Day Ahead RUC Floorroom": "55"}0550552026-10-09 19:50:02.379179
2026-10-12 00:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0443SPPMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/11/2026 19:00:00", "GMT Interval End": "10/12/2026 00:00:00", "BAA": "SPP", "Day Ahead Market Headroom": "490", "Day Ahead Market Floorroom": "590", "Day Ahead RUC Headroom": "490", "Day Ahead RUC Floorroom": "590"}4905904905902026-10-09 19:50:02.379179
2026-10-11 23:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0490SWPWMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/11/2026 18:00:00", "GMT Interval End": "10/11/2026 23:00:00", "BAA": "SWPW", "Day Ahead Market Headroom": "55", "Day Ahead Market Floorroom": "67", "Day Ahead RUC Headroom": "55", "Day Ahead RUC Floorroom": "67"}556755672026-10-09 19:50:02.379179
2026-10-11 23:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0442SPPMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/11/2026 18:00:00", "GMT Interval End": "10/11/2026 23:00:00", "BAA": "SPP", "Day Ahead Market Headroom": "0", "Day Ahead Market Floorroom": "490", "Day Ahead RUC Headroom": "0", "Day Ahead RUC Floorroom": "490"}049004902026-10-09 19:50:02.379179
2026-10-11 22:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0489SWPWMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/11/2026 17:00:00", "GMT Interval End": "10/11/2026 22:00:00", "BAA": "SWPW", "Day Ahead Market Headroom": "67", "Day Ahead Market Floorroom": "47", "Day Ahead RUC Headroom": "67", "Day Ahead RUC Floorroom": "47"}674767472026-10-09 19:50:02.379179
2026-10-11 22:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0441SPPMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/11/2026 17:00:00", "GMT Interval End": "10/11/2026 22:00:00", "BAA": "SPP", "Day Ahead Market Headroom": "80", "Day Ahead Market Floorroom": "484", "Day Ahead RUC Headroom": "80", "Day Ahead RUC Floorroom": "484"}80484804842026-10-09 19:50:02.379179
2026-10-11 21:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0488SWPWMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/11/2026 16:00:00", "GMT Interval End": "10/11/2026 21:00:00", "BAA": "SWPW", "Day Ahead Market Headroom": "47", "Day Ahead Market Floorroom": "38", "Day Ahead RUC Headroom": "47", "Day Ahead RUC Floorroom": "38"}473847382026-10-09 19:50:02.379179
2026-10-11 21:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0440SPPMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/11/2026 16:00:00", "GMT Interval End": "10/11/2026 21:00:00", "BAA": "SPP", "Day Ahead Market Headroom": "484", "Day Ahead Market Floorroom": "659", "Day Ahead RUC Headroom": "484", "Day Ahead RUC Floorroom": "659"}4846594846592026-10-09 19:50:02.379179
2026-10-11 20:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0487SWPWMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/11/2026 15:00:00", "GMT Interval End": "10/11/2026 20:00:00", "BAA": "SWPW", "Day Ahead Market Headroom": "38", "Day Ahead Market Floorroom": "30", "Day Ahead RUC Headroom": "38", "Day Ahead RUC Floorroom": "30"}383038302026-10-09 19:50:02.379179
2026-10-11 20:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0439SPPMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/11/2026 15:00:00", "GMT Interval End": "10/11/2026 20:00:00", "BAA": "SPP", "Day Ahead Market Headroom": "659", "Day Ahead Market Floorroom": "751", "Day Ahead RUC Headroom": "659", "Day Ahead RUC Floorroom": "751"}6597516597512026-10-09 19:50:02.379179
2026-10-11 19:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0486SWPWMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/11/2026 14:00:00", "GMT Interval End": "10/11/2026 19:00:00", "BAA": "SWPW", "Day Ahead Market Headroom": "30", "Day Ahead Market Floorroom": "37", "Day Ahead RUC Headroom": "30", "Day Ahead RUC Floorroom": "37"}303730372026-10-09 19:50:02.379179
2026-10-11 19:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0438SPPMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/11/2026 14:00:00", "GMT Interval End": "10/11/2026 19:00:00", "BAA": "SPP", "Day Ahead Market Headroom": "751", "Day Ahead Market Floorroom": "915", "Day Ahead RUC Headroom": "751", "Day Ahead RUC Floorroom": "915"}7519157519152026-10-09 19:50:02.379179
2026-10-11 18:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0485SWPWMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/11/2026 13:00:00", "GMT Interval End": "10/11/2026 18:00:00", "BAA": "SWPW", "Day Ahead Market Headroom": "37", "Day Ahead Market Floorroom": "31", "Day Ahead RUC Headroom": "37", "Day Ahead RUC Floorroom": "31"}373137312026-10-09 19:50:02.379179
2026-10-11 18:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0437SPPMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/11/2026 13:00:00", "GMT Interval End": "10/11/2026 18:00:00", "BAA": "SPP", "Day Ahead Market Headroom": "915", "Day Ahead Market Floorroom": "977", "Day Ahead RUC Headroom": "915", "Day Ahead RUC Floorroom": "977"}9159779159772026-10-09 19:50:02.379179
2026-10-11 17:00:00.0000002026-10-09 12:00:27.0740002026-10-09 19:50:02.351614caf43686772468df029166b50f1381810ac4503ac01f187ecbbbc17938252c0436SPPMarkets/Headroom_and_Floorroom/2026/10/Headroom-Floorroom-20261010.csvhttps://portal.spp.org/1e43390148b179b1cbcfb0fc3359b9746b93425f6ccba892df228cfb5624d4a1{"Interval": "10/11/2026 12:00:00", "GMT Interval End": "10/11/2026 17:00:00", "BAA": "SPP", "Day Ahead Market Headroom": "977", "Day Ahead Market Floorroom": "922", "Day Ahead RUC Headroom": "977", "Day Ahead RUC Floorroom": "922"}9779229779222026-10-09 19:50:02.379179

Coverage

100.0% complete0 gap days11 days with data
Show coverage history
Coverage: 100.0%Days with data: 11Gaps: 0
2026
gaplessmore