Ask the Grid
Open live grid
NYISO logo

Hour-Ahead Market Energy Report

NYISO hour-ahead market energy summary by hour, including internal bilaterals, generation capacity bid, generation scheduled, imports, exports, and net imports.

Interchange data
Download data
Native record
event_time
hourly (HAM) publication cadence
Evidence
Observed market data
Published observations from the named source
Time basis
Point-in-time records
UTC · event_time

Overview

NYISO hour-ahead market energy summary by hour, including internal bilaterals, generation capacity bid, generation scheduled, imports, exports, and net imports.

Query contract

Preserve one canonical row per (event_time) before aggregating.

Analysis rules

  • Group only after preserving the declared grain: event_time.

Schema9

Column
Type
event_timeDateTime64(6, 'UTC')
end_timeNullable(DateTime64(6, 'UTC'))
internal_bilaterals_mwNullable(Float64)
generation_capacity_bid_mwNullable(Float64)
generation_scheduled_mwNullable(Float64)
imports_scheduled_mwNullable(Float64)
exports_scheduled_mwNullable(Float64)
net_imports_mwNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample data

event_timeend_timeinternal_bilaterals_mwgeneration_capacity_bid_mwgeneration_scheduled_mwimports_scheduled_mwexports_scheduled_mwnet_imports_mwingested_at
2026-10-02 03:00:00.0000002026-10-02 04:00:00.0000009900043704964-5942026-10-01 14:32:18.934327
2026-10-02 03:00:00.0000002026-10-02 04:00:00.0000009900043704965-5952026-10-01 13:32:17.187942
2026-10-02 02:00:00.0000002026-10-02 03:00:00.0000009900047934992-1992026-10-01 14:32:18.934327
2026-10-02 02:00:00.0000002026-10-02 03:00:00.0000009900047934993-2002026-10-01 13:32:17.187942
2026-10-02 01:00:00.0000002026-10-02 02:00:00.00000099000582653874392026-10-01 14:32:18.934327
2026-10-02 01:00:00.0000002026-10-02 02:00:00.00000099000582653884382026-10-01 13:32:17.187942
2026-10-02 00:00:00.0000002026-10-02 01:00:00.0000009900055955507882026-10-01 14:32:18.934327
2026-10-02 00:00:00.0000002026-10-02 01:00:00.0000009900055955508872026-10-01 13:32:17.187942
2026-10-01 23:00:00.0000002026-10-02 00:00:00.00000099000542548315942026-10-01 14:32:18.934327
2026-10-01 23:00:00.0000002026-10-02 00:00:00.00000099000542548325932026-10-01 13:32:17.187942
2026-10-01 22:00:00.0000002026-10-01 23:00:00.000000990005718436913492026-10-01 14:32:18.934327
2026-10-01 22:00:00.0000002026-10-01 23:00:00.000000990005718437013482026-10-01 13:32:17.187942
2026-10-01 21:00:00.0000002026-10-01 22:00:00.000000990005832455512772026-10-01 14:32:18.934327
2026-10-01 21:00:00.0000002026-10-01 22:00:00.000000990005832456112712026-10-01 13:32:17.187942
2026-10-01 20:00:00.0000002026-10-01 21:00:00.00000099000580751246832026-10-01 14:32:18.934327
2026-10-01 20:00:00.0000002026-10-01 21:00:00.00000099000580751366712026-10-01 13:32:17.187942
2026-10-01 19:00:00.0000002026-10-01 20:00:00.00000099000535148734782026-10-01 14:32:18.934327
2026-10-01 19:00:00.0000002026-10-01 20:00:00.00000099000535148784732026-10-01 13:32:17.187942
2026-10-01 18:00:00.0000002026-10-01 19:00:00.000000990005999467213272026-10-01 14:32:18.934327
2026-10-01 18:00:00.0000002026-10-01 19:00:00.000000990005999468113182026-10-01 13:32:17.187942
2026-10-01 17:00:00.0000002026-10-01 18:00:00.000000990006186461115752026-10-01 14:32:18.934327
2026-10-01 17:00:00.0000002026-10-01 18:00:00.000000990006186460115852026-10-01 13:32:17.187942
2026-10-01 16:00:00.0000002026-10-01 17:00:00.000000990004959255524042026-10-01 14:32:18.934327
2026-10-01 16:00:00.0000002026-10-01 17:00:00.000000990006211437118402026-10-01 13:32:17.187942
2026-10-01 15:00:00.0000002026-10-01 16:00:00.000000990005681254831332026-10-01 14:32:18.934327

Coverage

100.0% complete0 gap days9,528 days with data
Show coverage history
Coverage: 100.0%Days with data: 9,528Gaps: 0
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016
2015
2014
2013
2012
2011
2010
2009
2008
2007
2006
2005
2004
2003
2002
2001
2000
gaplessmore