
Native record
event_time x location_id
Evidence
Observed market data
Time basis
Point-in-time records
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
Analysis rules
Schema5
Column
Type
event_timeDateTime64(6, 'UTC')location_idLowCardinality(String)location_nameNullable(String)loadNullable(Float64)ingested_atDateTime64(6, 'UTC')Sample data
| event_time | location_id | location_name | load | ingested_at |
|---|---|---|---|---|
| 2026-09-28 17:00:00.000000 | 4008 | .Z.NEMASSBOST | 2669.6 | 2026-09-28 17:22:30.600407 |
| 2026-09-28 17:00:00.000000 | 4007 | .Z.WCMASS | 1743.6 | 2026-09-28 17:22:30.600407 |
| 2026-09-28 17:00:00.000000 | 4006 | .Z.SEMASS | 1523.7 | 2026-09-28 17:22:30.600407 |
| 2026-09-28 17:00:00.000000 | 4005 | .Z.RHODEISLAND | 866.2 | 2026-09-28 17:22:30.600407 |
| 2026-09-28 17:00:00.000000 | 4004 | .Z.CONNECTICUT | 3006.8 | 2026-09-28 17:22:30.600407 |
| 2026-09-28 17:00:00.000000 | 4003 | .Z.VERMONT | 619.9 | 2026-09-28 17:22:30.600407 |
| 2026-09-28 17:00:00.000000 | 4002 | .Z.NEWHAMPSHIRE | 1303.5 | 2026-09-28 17:22:30.600407 |
| 2026-09-28 17:00:00.000000 | 4001 | .Z.MAINE | 816.2 | 2026-09-28 17:22:30.600407 |
| 2026-09-28 17:00:00.000000 | 4000 | .H.INTERNAL_HUB | 167.3 | 2026-09-28 17:22:30.600407 |
| 2026-09-28 17:00:00.000000 | 32 | NEPOOL AREA | 13043 | 2026-09-28 17:22:30.600407 |
| 2026-09-28 16:00:00.000000 | 4008 | .Z.NEMASSBOST | 2677.8 | 2026-09-28 16:22:30.244120 |
| 2026-09-28 16:00:00.000000 | 4007 | .Z.WCMASS | 1722.1 | 2026-09-28 16:22:30.244120 |
| 2026-09-28 16:00:00.000000 | 4006 | .Z.SEMASS | 1517 | 2026-09-28 16:22:30.244120 |
| 2026-09-28 16:00:00.000000 | 4005 | .Z.RHODEISLAND | 853.2 | 2026-09-28 16:22:30.244120 |
| 2026-09-28 16:00:00.000000 | 4004 | .Z.CONNECTICUT | 2964.5 | 2026-09-28 16:22:30.244120 |
| 2026-09-28 16:00:00.000000 | 4003 | .Z.VERMONT | 595.5 | 2026-09-28 16:22:30.244120 |
| 2026-09-28 16:00:00.000000 | 4002 | .Z.NEWHAMPSHIRE | 1287.7 | 2026-09-28 16:22:30.244120 |
| 2026-09-28 16:00:00.000000 | 4001 | .Z.MAINE | 840.7 | 2026-09-28 16:22:30.244120 |
| 2026-09-28 16:00:00.000000 | 4000 | .H.INTERNAL_HUB | 179.6 | 2026-09-28 16:22:30.244120 |
| 2026-09-28 16:00:00.000000 | 32 | NEPOOL AREA | 12967 | 2026-09-28 16:22:30.244120 |
| 2026-09-28 15:00:00.000000 | 4008 | .Z.NEMASSBOST | 2629.6 | 2026-09-28 15:22:30.540595 |
| 2026-09-28 15:00:00.000000 | 4007 | .Z.WCMASS | 1661.9 | 2026-09-28 15:22:30.540595 |
| 2026-09-28 15:00:00.000000 | 4006 | .Z.SEMASS | 1508.7 | 2026-09-28 15:22:30.540595 |
| 2026-09-28 15:00:00.000000 | 4005 | .Z.RHODEISLAND | 852 | 2026-09-28 15:22:30.540595 |
| 2026-09-28 15:00:00.000000 | 4004 | .Z.CONNECTICUT | 2949.5 | 2026-09-28 15:22:30.540595 |
Coverage
100.0% complete0 gap days131 days with data
Show coverage history
Coverage: 100.0%Days with data: 131Gaps: 0
2026
gaplessmore