All hourly reserve-zone forecast vintages

SPP's All hourly reserve-zone forecast vintages.

Generation data SPP market

Query with the agent

Native record

publisher period x document x sheet/archive member x source row x collected revision

day publication publication cadence

Evidence

Mixed evidence

Multiple evidence types kept distinct in the contract

Time basis

Date-labelled records

UTC · report_date

Overview

Each row preserves a publisher record, workbook row, or report document with its source member and row index. Source timestamps, units, geographic scope, and revision qualifiers are retained in record_json; event_time is collection time; completed_at is when the entire document became available.

Query contract

The view admits a document only when its completion record and exact mirrored row count agree. Select a report_date, source_url and source_sha256 revision before joining source_member and row_index. Interpret observation times from the source record, never from the collection clock.

Analysis rules

Decode the report's source headers and units before aggregating. Never sum report_date, row_index, snapshots, revisions, regional totals and components, or forecast vintages.

Interpretation

report_date identifies the requested publisher period. It is not an observation timestamp. event_time records collection, not source publication or delivery.
The serving mirror keeps the latest row for each publisher record; older collected revisions may no longer be queryable.

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

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

Schema11

Column

Type

event_timeDateTime64(6, 'UTC')

datasetLowCardinality(String)

report_dateDate32

source_urlString

source_memberString

source_sha256String

row_indexInt64

record_jsonString

response_metadataString

ingested_atDateTime64(6, 'UTC')

completed_atDateTime64(6, 'UTC')

Sample data

event_time	dataset	report_date	source_url	source_member	source_sha256	row_index	record_json	response_metadata	ingested_at	completed_at
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	758	["10/12/2026 13:00:00", "10/12/2026 18:00:00", "SPP", "2", "4904.590", "", "410.970", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	757	["10/12/2026 13:00:00", "10/12/2026 18:00:00", "SPP", "1", "996.400", "", "55.800", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	770	["10/12/2026 11:00:00", "10/12/2026 16:00:00", "SPP", "2", "5219.300", "", "422.740", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	769	["10/12/2026 11:00:00", "10/12/2026 16:00:00", "SPP", "1", "932.590", "", "56.510", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	768	["10/12/2026 12:00:00", "10/12/2026 17:00:00", "SWPW", "21", "296.480", "", "747.370", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	767	["10/12/2026 12:00:00", "10/12/2026 17:00:00", "SPP", "5", "931.430", "", "19.850", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	766	["10/12/2026 12:00:00", "10/12/2026 17:00:00", "SPP", "4", "14568.890", "", "1433.950", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	765	["10/12/2026 12:00:00", "10/12/2026 17:00:00", "SPP", "3", "795.860", "", "751.910", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	764	["10/12/2026 12:00:00", "10/12/2026 17:00:00", "SPP", "2", "5052.670", "", "418.490", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	777	["10/12/2026 10:00:00", "10/12/2026 15:00:00", "SPP", "3", "1025.800", "", "546.340", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	776	["10/12/2026 10:00:00", "10/12/2026 15:00:00", "SPP", "2", "5475.450", "", "361.010", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	775	["10/12/2026 10:00:00", "10/12/2026 15:00:00", "SPP", "1", "953.320", "", "45.550", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	792	["10/12/2026 08:00:00", "10/12/2026 13:00:00", "SWPW", "21", "494.780", "", "0.520", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	773	["10/12/2026 11:00:00", "10/12/2026 16:00:00", "SPP", "5", "913.060", "", "11.720", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	772	["10/12/2026 11:00:00", "10/12/2026 16:00:00", "SPP", "4", "14923.020", "", "1441.190", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	771	["10/12/2026 11:00:00", "10/12/2026 16:00:00", "SPP", "3", "883.900", "", "744.420", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	784	["10/12/2026 09:00:00", "10/12/2026 14:00:00", "SPP", "4", "15383.140", "", "759.560", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	783	["10/12/2026 09:00:00", "10/12/2026 14:00:00", "SPP", "3", "1244.500", "", "161.350", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	782	["10/12/2026 09:00:00", "10/12/2026 14:00:00", "SPP", "2", "5749.960", "", "152.170", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	774	["10/12/2026 11:00:00", "10/12/2026 16:00:00", "SWPW", "21", "304.900", "", "717.790", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	786	["10/12/2026 09:00:00", "10/12/2026 14:00:00", "SWPW", "21", "417.760", "", "102.540", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	797	["10/12/2026 07:00:00", "10/12/2026 12:00:00", "SPP", "5", "1523.920", "", "0.000", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	798	["10/12/2026 07:00:00", "10/12/2026 12:00:00", "SWPW", "21", "567.230", "", "0.000", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	781	["10/12/2026 09:00:00", "10/12/2026 14:00:00", "SPP", "1", "1028.390", "", "17.570", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743
2026-10-11 03:43:18.704235	renewable_forecast_reserve_zone	2026-10-10	ftp://pubftp.spp.org/Operational_Data/RF_By_Reserve_Zone/2026/10/10/RF_RESERVE_ZONE-202610101800.csv	RF_RESERVE_ZONE-202610101800.csv	e792be5de69fb018c2632b75523ccd691cc458cd59f260c52a09eafdf12ddb5d	785	["10/12/2026 09:00:00", "10/12/2026 14:00:00", "SPP", "5", "1143.670", "", "0.870", ""]	{"modified": "20261010230557", "size": 76026}	2026-10-11 03:43:18.727634	2026-10-11 03:43:18.852743

Coverage

100.0% complete0 gap days8 days with data

Show coverage history

Coverage: 100.0%Days with data: 8Gaps: 0

2026

gaplessmore

Related generation data

Related generation data
Dataset	Description
Completed-year curtailment archiveSPP · year publication	SPP's Completed-year curtailment archive. Each row preserves a publisher record, workbook row, or report document with its source member and row index. Source timestamps, units, geographic scope, and revision qualifiers are retained in record_json; event_time is collection time; completed_at is when the entire document became available.
Daily VER curtailments, preserving BAASPP · day publication	SPP's Daily VER curtailments, preserving BAA. Each row preserves a publisher record, workbook row, or report document with its source member and row index. Source timestamps, units, geographic scope, and revision qualifiers are retained in record_json; event_time is collection time; completed_at is when the entire document became available.
East / West Available Maintenance MarginSPP · source publication	Published additional MW of available maintenance by East/West source file and calendar target label. MKTHOUR remains unqualified source text; event_time is file publication. Use one complete forecast vintage per footprint rather than stacking publications. Complete views require a matching receipt and mirrored row count; empty results are unknown coverage. Raw sources retain publication history internally.
East / West Generation Mix with StorageSPP · source publication	Published generation by fuel, signed energy-storage MW and load, preserving SPP/SWPW and qualified GMT clock. This is the GenMix2Hour cohort; do not add the separate InclSelf cohort or combine repeated snapshots. Negative storage is retained. History accumulates prospectively. Complete views require a matching receipt and mirrored row count; empty results are unknown coverage. Raw sources retain publication history internally.