Ask the Grid
Open live grid

Overview

What is physically generating in NYISO, in megawatts by fuel, one row per interval. 1,143,328 intervals, 2015-12 to now, usable from 2018-01. Columns: gas_mw, dual_fuel_mw, other_fossil_mw, nuclear_mw, hydro_mw, wind_mw, other_renewables_mw. NYISO reports no coal (its last coal plant retired in 2020), no grid-scale solar as its own category (it sits inside other_renewables, and behind-the-meter solar is a separate feed), and no storage. Those columns are absent rather than present-and-NULL: a column exists here where the data exists. Wide rather than long: a whole interval's mix is one row, so shares are computed across columns in that row and the timestamp does not repeat once per fuel. "Which fuel is largest" is greatest() across the columns, or simply reading the row.

NYISO marketAsk the agent about this dataset

Use with MCP

This table is readable two ways, over the same guarded boundary. Over HTTP: POST /api/v1/datasets/nyiso_generation_mix/query, described in the API reference. Or from an MCP client: connect a market below, then use search_data or describe_data to load its query contract before calling query_data.

NYISO MCP Server

Schema9

Column
Type
event_timeDateTime64(6, 'UTC')
gas_mwNullable(Float64)
dual_fuel_mwNullable(Float64)
other_fossil_mwNullable(Float64)
nuclear_mwNullable(Float64)
hydro_mwNullable(Float64)
wind_mwNullable(Float64)
other_renewables_mwNullable(Float64)
sourceLowCardinality(String)

Sample rows

event_timegas_mwdual_fuel_mwother_fossil_mwnuclear_mwhydro_mwwind_mwother_renewables_mwsource
2026-08-28 02:00:00.00000050986057031273303609227live
2026-08-28 01:55:00.00000051296123031273325610224live
2026-08-28 01:50:00.00000051426156031273325591230live
2026-08-28 01:45:00.00000051586169031263324580223live
2026-08-28 01:40:00.00000051776172031283334576241live
2026-08-28 01:35:00.00000051346137031273321599240live
2026-08-28 01:30:00.00000050966121031273320620228live
2026-08-28 01:25:00.00000050976146031263341631234live
2026-08-28 01:20:00.00000051316175031263339618246live
2026-08-28 01:15:00.00000051836204031273333600232live
2026-08-28 01:10:00.00000052116259031283369596219live
2026-08-28 01:05:00.00000052126301031283430596216live
2026-08-28 01:00:00.00000053116331031273485594219live
2026-08-28 00:55:00.00000053846358031283564567222live
2026-08-28 00:50:00.00000054526369031263606538225live
2026-08-28 00:45:00.00000055116401231263659501226live
2026-08-28 00:40:00.000000557664371631273660471223live
2026-08-28 00:35:00.000000561864571731253654456222live
2026-08-28 00:30:00.000000564564541731253644463219live
2026-08-28 00:25:00.000000567864411731273686438217live
2026-08-28 00:20:00.000000570564221731273772400234live
2026-08-28 00:15:00.000000572564731731253775377241live
2026-08-28 00:10:00.000000576065091731273713374240live
2026-08-28 00:05:00.000000582564581731263809362242live
2026-08-28 00:00:00.000000578566071731263850359224live

Coverage

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