ISO-NE logo

PRD Clearing DA

ISO-NE's published PRD Clearing DA source feed.

Native record
event_time x location_id
ISO-NE source publication publication cadence
Evidence
Observed market data
Published observations from the named source
Time basis
Point-in-time records
UTC · event_time

Overview

This catalog page exposes the physical schema, coverage, and latest source rows without inventing a normalized grain for publisher-shaped snapshot fields. Use the documented key and event time when comparing revisions or vintages.

Query contract

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

Analysis rules

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

Schema5

Column
Type
event_timeDateTime64(6, 'UTC')
location_idLowCardinality(String)
location_nameNullable(String)
da_cleared_mwNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample data

event_timelocation_idlocation_nameda_cleared_mwingested_at
2018-07-18 03:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-18 02:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-18 01:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-18 00:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-17 23:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-17 22:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-17 21:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-17 20:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-17 19:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-17 18:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-17 17:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-17 16:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-17 15:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-17 14:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-17 13:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-17 12:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-17 11:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-17 10:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-17 09:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-17 08:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-17 07:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-17 06:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-17 05:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-17 04:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850
2018-07-17 03:00:00.0000004008.Z.NEMASSBOST02026-07-30 07:00:15.136850

Coverage

100.0% complete0 gap days18 days with data
Show coverage history
Coverage: 100.0%Days with data: 18Gaps: 0
2018
gaplessmore