
Native record
event_time x masked_participant_id x masked_location_id x bid_type x bid_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
Schema8
Column
Type
event_timeDateTime64(6, 'UTC')masked_participant_idInt64masked_location_idInt64location_typeNullable(String)bid_typeLowCardinality(String)bid_idInt64segmentsNullable(String)ingested_atDateTime64(6, 'UTC')Sample data
| event_time | masked_participant_id | masked_location_id | location_type | bid_type | bid_id | segments | ingested_at |
|---|---|---|---|---|---|---|---|
| 2026-06-01 03:00:00.000000 | 985313 | 41756 | LOAD ZONE | FIXED | 16403739 | {"Segment": [{"Mw": 34.3, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 958802 | 41756 | LOAD ZONE | FIXED | 76427356 | {"Segment": [{"Mw": 27.1, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 955355 | 37894 | LOAD ZONE | FIXED | 16404027 | {"Segment": [{"Mw": 8.5, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 950161 | 70291 | LOAD ZONE | FIXED | 767500386 | {"Segment": [{"Mw": 2.1, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 950161 | 41756 | LOAD ZONE | FIXED | 767500387 | {"Segment": [{"Mw": 1.7, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 950161 | 39271 | LOAD ZONE | FIXED | 767500382 | {"Segment": [{"Mw": 0.5, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 950161 | 37894 | LOAD ZONE | FIXED | 767500388 | {"Segment": [{"Mw": 1.4, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 950161 | 28934 | LOAD ZONE | FIXED | 767500384 | {"Segment": [{"Mw": 13.5, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 943850 | 70291 | LOAD ZONE | FIXED | 16403480 | {"Segment": [{"Mw": 28.3, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 938836 | 70291 | LOAD ZONE | FIXED | 295081041 | {"Segment": [{"Mw": 8.7, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 938836 | 41756 | LOAD ZONE | FIXED | 295081042 | {"Segment": [{"Mw": 5.1, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 938836 | 37894 | LOAD ZONE | FIXED | 295081043 | {"Segment": [{"Mw": 8.2, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 929528 | 37894 | LOAD ZONE | FIXED | 16404000 | {"Segment": [{"Mw": 24.7, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 916628 | 37894 | LOAD ZONE | FIXED | 55609792 | {"Segment": [{"Mw": 20.6, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 915073 | 89933 | LOAD ZONE | FIXED | 125501875 | {"Segment": [{"Mw": 1.2, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 915073 | 67184 | LOAD ZONE | FIXED | 125501871 | {"Segment": [{"Mw": 0.8, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 915073 | 39271 | LOAD ZONE | FIXED | 125501872 | {"Segment": [{"Mw": 6.4, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 915073 | 28934 | LOAD ZONE | FIXED | 125501874 | {"Segment": [{"Mw": 1.9, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 910942 | 89933 | LOAD ZONE | FIXED | 119703173 | {"Segment": [{"Mw": 1.8, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 910942 | 39271 | LOAD ZONE | FIXED | 119703170 | {"Segment": [{"Mw": 2.0, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 910942 | 37894 | LOAD ZONE | FIXED | 119703176 | {"Segment": [{"Mw": 6.5, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 895947 | 75309 | HUB | INC | 420862156 | {"Segment": [{"Price": 39.4, "Mw": 10.0, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 893586 | 89933 | LOAD ZONE | FIXED | 105270054 | {"Segment": [{"Mw": 29.7, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 893586 | 41756 | LOAD ZONE | FIXED | 105270056 | {"Segment": [{"Mw": 39.1, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
| 2026-06-01 03:00:00.000000 | 893586 | 39271 | LOAD ZONE | FIXED | 105270051 | {"Segment": [{"Mw": 47.3, "Number": 1}]} | 2026-09-28 14:10:27.262305 |
Coverage
87.3% complete112 gap days771 days with data
Show coverage history
Coverage: 87.3%Days with data: 771Gaps: 112
2026
2025
2024
gaplessmore