ISO-NE logo

HB FCM ARA

ISO-NE's published HB FCM ARA source feed.

Native record
event_time x cp x auc_type x mask_res_id x bid_type
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, cp, auc_type, mask_res_id, bid_type) before aggregating.

Analysis rules

  • Group only after preserving the declared grain: event_time, cp, auc_type, mask_res_id, bid_type.

Schema11

Column
Type
event_timeDateTime64(6, 'UTC')
cpLowCardinality(String)
auc_typeLowCardinality(String)
mask_res_idInt64
mask_lpidNullable(Int64)
mask_czidNullable(Int64)
res_typeNullable(String)
bid_typeLowCardinality(String)
seg1_mwNullable(Float64)
seg1_priceNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample data

event_timecpauc_typemask_res_idmask_lpidmask_czidres_typebid_typeseg1_mwseg1_priceingested_at
2026-09-28 08:30:27.3493982025-26ARA399643504288506GeneratingDemand_Bid42.0010.542026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA398773514028503GeneratingDemand_Bid3.750.512026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA398386512518503GeneratingDemand_Bid2.8690.052026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA3983481644278506GeneratingDemand_Bid47.395.1762026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA3981331333498500ImportDemand_Bid2.6087.7732026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA397416509838500GeneratingSupply_Offer32.692026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA3960241347558506GeneratingDemand_Bid0.382.6392026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA3958911328888503GeneratingDemand_Bid6.9260.1252026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA395778500758506GeneratingDemand_Bid1.3862.6392026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA394499507458503GeneratingSupply_Offer46.1521.52026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA394320506898506GeneratingDemand_Bid0.013.5012026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA3939881328888503GeneratingDemand_Bid3.7812.42026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA3933681663368500GeneratingDemand_Bid0.3522.5872026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA3933401280938503GeneratingDemand_Bid0.0511.12026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA3927621289648505GeneratingDemand_Bid0.7350.52026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA392298501738503GeneratingDemand_Bid3.3020.052026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA3917831284938500GeneratingDemand_Bid0.460.52026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA3912821289648505GeneratingDemand_Bid0.410.52026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA390825513298503GeneratingDemand_Bid3.63112.42026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA390792502758505GeneratingDemand_Bid0.25852026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA389675506898500DemandDemand_Bid1.96512.42026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA3893301328888503GeneratingDemand_Bid1060.0492026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA389160871478505DemandDemand_Bid0.0432.642026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA3885441284938500GeneratingDemand_Bid0.14912.42026-09-28 08:30:30.622561
2026-09-28 08:30:27.3493982025-26ARA3879811347558500GeneratingDemand_Bid2.4172.592026-09-28 08:30:30.622561

Coverage

97.7% complete3 gap days127 days with data
Show coverage history
Coverage: 97.7%Days with data: 127Gaps: 3
2026
gaplessmore