NYISO logo

Day-Ahead Zonal Bid Load

NYISO day-ahead zonal bid-load components by zone: energy bid load, bilateral load, price-cap load, virtual load, and virtual supply.

Native record
event_time x ptid
hourly (DAM) publication cadence
Evidence
Cleared day-ahead market
A market outcome, not a physical observation
Time basis
Point-in-time records
UTC · event_time

Overview

Use it to compare bid-in demand with forecasts and realized load.

Query contract

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

Analysis rules

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

Schema10

Column
Type
event_timeDateTime64(6, 'UTC')
time_zoneNullable(String)
zone_nameNullable(String)
ptidInt64
energy_bid_load_mwNullable(Float64)
bilateral_load_mwNullable(Float64)
price_cap_load_mwNullable(Float64)
virtual_load_mwNullable(Float64)
virtual_supply_mwNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample data

event_timetime_zonezone_nameptidenergy_bid_load_mwbilateral_load_mwprice_cap_load_mwvirtual_load_mwvirtual_supply_mwingested_at
2026-10-02 03:00:00.000000EDTLONGIL6176265314650119-1672026-10-01 14:55:56.492689
2026-10-02 03:00:00.000000EDTN.Y.C.6176114811900175681-2192026-10-01 14:55:56.492689
2026-10-02 03:00:00.000000EDTDUNWOD6176012912524533-702026-10-01 14:55:56.492689
2026-10-02 03:00:00.000000EDTMILLWD61759142434770-312026-10-01 14:55:56.492689
2026-10-02 03:00:00.000000EDTHUD VL6175854516026424-1972026-10-01 14:55:56.492689
2026-10-02 03:00:00.000000EDTCAPITL61757838217013-1772026-10-01 14:55:56.492689
2026-10-02 03:00:00.000000EDTMHK VL61756501172026-452026-10-01 14:55:56.492689
2026-10-02 03:00:00.000000EDTNORTH61755923348084-522026-10-01 14:55:56.492689
2026-10-02 03:00:00.000000EDTCENTRL617549974070235-682026-10-01 14:55:56.492689
2026-10-02 03:00:00.000000EDTGENESE61753810167022-652026-10-01 14:55:56.492689
2026-10-02 03:00:00.000000EDTWEST6175295056207-5302026-10-01 14:55:56.492689
2026-10-02 03:00:00.000000EDTLONGIL6176265314650119-1672026-10-01 13:55:56.151374
2026-10-02 03:00:00.000000EDTN.Y.C.6176114811900175681-2192026-10-01 13:55:56.151374
2026-10-02 03:00:00.000000EDTDUNWOD6176012912524533-702026-10-01 13:55:56.151374
2026-10-02 03:00:00.000000EDTMILLWD61759142434770-312026-10-01 13:55:56.151374
2026-10-02 03:00:00.000000EDTHUD VL6175854516026424-1972026-10-01 13:55:56.151374
2026-10-02 03:00:00.000000EDTCAPITL61757838217013-1772026-10-01 13:55:56.151374
2026-10-02 03:00:00.000000EDTMHK VL61756501172026-452026-10-01 13:55:56.151374
2026-10-02 03:00:00.000000EDTNORTH61755923348084-522026-10-01 13:55:56.151374
2026-10-02 03:00:00.000000EDTCENTRL617549974070235-682026-10-01 13:55:56.151374
2026-10-02 03:00:00.000000EDTGENESE61753810167022-652026-10-01 13:55:56.151374
2026-10-02 03:00:00.000000EDTWEST6175295056207-5302026-10-01 13:55:56.151374
2026-10-02 02:00:00.000000EDTLONGIL6176282014710195-1622026-10-01 14:55:56.492689
2026-10-02 02:00:00.000000EDTN.Y.C.61761159119701911418-2122026-10-01 14:55:56.492689
2026-10-02 02:00:00.000000EDTDUNWOD6176014413127564-602026-10-01 14:55:56.492689

Coverage

100.0% complete0 gap days9,228 days with data
Show coverage history
Coverage: 100.0%Days with data: 9,228Gaps: 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
gaplessmore