SPP logo

Short-Term Solar Forecast

SPP's short-term solar generation forecast in MW with the realized solar actual for the same interval.

Native record
event_time x publish_time
5-minute, frequent vintages publication cadence
Evidence
Forecast data
Forward-looking values with an explicit issue time
Time basis
Point-in-time records
UTC · event_time

Overview

Bitemporal, retaining each successive vintage against its delivery interval. Solar is a much smaller share of the SPP mix than wind and can read slightly negative overnight from station-service draw.

Query contract

Preserve one canonical row per (event_time, publish_time) before aggregating.

Analysis rules

  • Group only after preserving the declared grain: event_time, publish_time.

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.

HTTP endpoint
POST /api/v1/datasets/spp_solar_forecast_short_term/query

Schema6

Column
Type
event_timeDateTime64(6, 'UTC')
publish_timeDateTime64(6, 'UTC')
baaLowCardinality(String)
forecast_mwNullable(Float64)
actual_mwNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample data

event_timepublish_timebaaforecast_mwactual_mwingested_at
2026-09-20 06:55:00.0000002026-09-20 02:55:00.000000SWPW02026-09-20 03:51:09.581728
2026-09-20 06:55:00.0000002026-09-20 02:55:00.000000SPP02026-09-20 03:51:09.581728
2026-09-20 06:55:00.0000002026-09-20 02:55:00.000000SWPW02026-09-20 03:44:55.039075
2026-09-20 06:55:00.0000002026-09-20 02:55:00.000000SPP02026-09-20 03:44:55.039075
2026-09-20 06:55:00.0000002026-09-20 02:55:00.000000SWPW02026-09-20 03:41:04.726199
2026-09-20 06:55:00.0000002026-09-20 02:55:00.000000SPP02026-09-20 03:41:04.726199
2026-09-20 06:50:00.0000002026-09-20 02:55:00.000000SWPW02026-09-20 03:51:09.581728
2026-09-20 06:50:00.0000002026-09-20 02:55:00.000000SPP02026-09-20 03:51:09.581728
2026-09-20 06:50:00.0000002026-09-20 02:50:00.000000SWPW02026-09-20 03:51:09.581728
2026-09-20 06:50:00.0000002026-09-20 02:50:00.000000SPP02026-09-20 03:51:09.581728
2026-09-20 06:50:00.0000002026-09-20 02:55:00.000000SWPW02026-09-20 03:44:55.039075
2026-09-20 06:50:00.0000002026-09-20 02:55:00.000000SPP02026-09-20 03:44:55.039075
2026-09-20 06:50:00.0000002026-09-20 02:50:00.000000SWPW02026-09-20 03:44:55.039075
2026-09-20 06:50:00.0000002026-09-20 02:50:00.000000SPP02026-09-20 03:44:55.039075
2026-09-20 06:50:00.0000002026-09-20 02:55:00.000000SWPW02026-09-20 03:41:04.726199
2026-09-20 06:50:00.0000002026-09-20 02:55:00.000000SPP02026-09-20 03:41:04.726199
2026-09-20 06:50:00.0000002026-09-20 02:50:00.000000SWPW02026-09-20 03:41:04.726199
2026-09-20 06:50:00.0000002026-09-20 02:50:00.000000SPP02026-09-20 03:41:04.726199
2026-09-20 06:45:00.0000002026-09-20 02:55:00.000000SWPW02026-09-20 03:51:09.581728
2026-09-20 06:45:00.0000002026-09-20 02:55:00.000000SPP02026-09-20 03:51:09.581728
2026-09-20 06:45:00.0000002026-09-20 02:50:00.000000SWPW02026-09-20 03:51:09.581728
2026-09-20 06:45:00.0000002026-09-20 02:50:00.000000SPP02026-09-20 03:51:09.581728
2026-09-20 06:45:00.0000002026-09-20 02:45:00.000000SWPW02026-09-20 03:51:09.581728
2026-09-20 06:45:00.0000002026-09-20 02:45:00.000000SPP02026-09-20 03:51:09.581728
2026-09-20 06:45:00.0000002026-09-20 02:55:00.000000SWPW02026-09-20 03:44:55.039075

Coverage

93.8% complete208 gap days3,143 days with data
Show coverage history
Coverage: 93.8%Days with data: 3,143Gaps: 208
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
gaplessmore