Ask the Grid

Overview

NYISO hourly load forecast by load zone plus a NYISO system-total row, with source_time preserving forecast vintage. The application uses the latest vintage per target hour to compare expected load against realized hourly actuals.

Use with MCP

This table is available through the signed-in, read-only Ask the Grid MCP server. Connect a market below, then use search_data or describe_data to load its query contract before calling query_data.

Schema6

Column
Type
event_timeDateTime64(6, 'UTC')
source_timeDateTime64(6, 'UTC')
source_dateDate32
zone_nameLowCardinality(String)
forecast_mwNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample rows

event_timesource_timesource_datezone_nameforecast_mwingested_at
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15WEST17492026-08-15 06:25:57.384899
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15NYISO196292026-08-15 06:25:57.384899
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15NORTH6012026-08-15 06:25:57.384899
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15N.Y.C.70122026-08-15 06:25:57.384899
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15MILLWD3152026-08-15 06:25:57.384899
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15MHK VL7902026-08-15 06:25:57.384899
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15LONGIL30872026-08-15 06:25:57.384899
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15HUD VL11862026-08-15 06:25:57.384899
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15GENESE11002026-08-15 06:25:57.384899
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15DUNWOD7582026-08-15 06:25:57.384899
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15CENTRL16142026-08-15 06:25:57.384899
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15CAPITL14172026-08-15 06:25:57.384899
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15WEST17492026-08-15 05:25:56.340774
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15NYISO196292026-08-15 05:25:56.340774
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15NORTH6012026-08-15 05:25:56.340774
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15N.Y.C.70122026-08-15 05:25:56.340774
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15MILLWD3152026-08-15 05:25:56.340774
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15MHK VL7902026-08-15 05:25:56.340774
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15LONGIL30872026-08-15 05:25:56.340774
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15HUD VL11862026-08-15 05:25:56.340774
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15GENESE11002026-08-15 05:25:56.340774
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15DUNWOD7582026-08-15 05:25:56.340774
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15CENTRL16142026-08-15 05:25:56.340774
2026-08-21 03:00:00.0000002026-08-15 04:00:00.0000002026-08-15CAPITL14172026-08-15 05:25:56.340774
2026-08-21 02:00:00.0000002026-08-15 04:00:00.0000002026-08-15WEST18422026-08-15 06:25:57.384899

Coverage

100.0% complete0 gap days4,251 days with data
Show coverage history ▾
Coverage: 100.0%Days with data: 4,251Gaps: 0
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016
2015
gaplessmore