SPP logo

Mid-Term Solar Forecast

SPP's mid-term solar generation forecast in MW, running roughly seven days ahead for the published BAA.

One row per
event_time x publish_time x baa
Hourly, out ~7 days 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 published vintage against its delivery interval.

Query contract
Preserve one canonical row per (event_time, publish_time, baa) before aggregating.
Analysis rules
Group only after preserving the declared grain: event_time, publish_time, baa.

Access

Download
Query it in SQL, download it, or read it with an API key. Download data
MCP
Connect an MCP client and load the contract with describe_data before calling query_data.SPP MCPAPI reference
HTTP endpoint
POST /api/v1/datasets/spp_solar_forecast_mid_term/query
Full history
Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

5 columns
ColumnType
event_timeDateTime64(6, 'UTC')
publish_timeDateTime64(6, 'UTC')
baaLowCardinality(String)
forecast_mwNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample data

event_timepublish_timebaaforecast_mwingested_at
2026-11-11 02:00:00.0000002026-11-04 01:00:00.000000SWPW02026-11-04 01:31:32.740062
2026-11-11 02:00:00.0000002026-11-04 01:00:00.000000SPP02026-11-04 01:31:32.740062
2026-11-11 01:00:00.0000002026-11-04 01:00:00.000000SWPW0.082026-11-04 01:31:32.740062
2026-11-11 01:00:00.0000002026-11-04 01:00:00.000000SPP02026-11-04 01:31:32.740062
2026-11-11 01:00:00.0000002026-11-04 00:00:00.000000SWPW0.092026-11-04 01:31:32.740062
2026-11-11 01:00:00.0000002026-11-04 00:00:00.000000SPP02026-11-04 01:31:32.740062
2026-11-11 00:00:00.0000002026-11-04 01:00:00.000000SWPW59.462026-11-04 01:31:32.740062
2026-11-11 00:00:00.0000002026-11-04 01:00:00.000000SPP129.82026-11-04 01:31:32.740062
2026-11-11 00:00:00.0000002026-11-04 00:00:00.000000SWPW63.462026-11-04 01:31:32.740062
2026-11-11 00:00:00.0000002026-11-04 00:00:00.000000SPP130.52026-11-04 01:31:32.740062
2026-11-11 00:00:00.0000002026-11-03 23:00:00.000000SWPW63.462026-11-04 01:31:32.740062
2026-11-11 00:00:00.0000002026-11-03 23:00:00.000000SPP130.52026-11-04 01:31:32.740062
2026-11-10 23:00:00.0000002026-11-04 01:00:00.000000SWPW354.852026-11-04 01:31:32.740062
2026-11-10 23:00:00.0000002026-11-04 01:00:00.000000SPP1027.022026-11-04 01:31:32.740062
2026-11-10 23:00:00.0000002026-11-04 00:00:00.000000SWPW373.742026-11-04 01:31:32.740062
2026-11-10 23:00:00.0000002026-11-04 00:00:00.000000SPP1030.112026-11-04 01:31:32.740062
2026-11-10 23:00:00.0000002026-11-03 23:00:00.000000SWPW373.742026-11-04 01:31:32.740062
2026-11-10 23:00:00.0000002026-11-03 23:00:00.000000SPP1030.112026-11-04 01:31:32.740062
2026-11-10 23:00:00.0000002026-11-03 22:00:00.000000SWPW346.052026-11-04 01:31:32.740062
2026-11-10 23:00:00.0000002026-11-03 22:00:00.000000SPP1013.712026-11-04 01:31:32.740062
2026-11-10 22:00:00.0000002026-11-04 01:00:00.000000SWPW573.882026-11-04 01:31:32.740062
2026-11-10 22:00:00.0000002026-11-04 01:00:00.000000SPP2013.932026-11-04 01:31:32.740062
2026-11-10 22:00:00.0000002026-11-04 00:00:00.000000SWPW599.772026-11-04 01:31:32.740062
2026-11-10 22:00:00.0000002026-11-04 00:00:00.000000SPP2015.742026-11-04 01:31:32.740062
2026-11-10 22:00:00.0000002026-11-03 23:00:00.000000SWPW599.772026-11-04 01:31:32.740062

Coverage

Complete
100.0%
Gap days
0
Days with data
3,403
Show coverage history
Coverage: 100.0%Days with data: 3,403Gaps: 0
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
gaplessmore