Ask the Grid
Open live grid
ISO-NE logo

Actual Interchange

ISO-NE actual interchange by published external location, with signed interchange, purchase, and sale components.

Interchange dataISO-NE market
Query with the agent
Native record
external location x operating interval
hourly publication cadence
Evidence
Observed market data
Published observations from the named source
Time basis
Point-in-time records
UTC · event_time

Overview

Preserve location and direction; do not sum a net value with its purchase and sale components.

Query contract

Select the latest ingested_at row per event_time and location_id and preserve the published location direction.

Analysis rules

  • Do not add act_interchange to purchase and sale; they are net and directional component views of the same interchange.

Access

Query from your own tools

Use the guarded HTTP endpoint directly, or connect an MCP client and load the dataset contract with describe_data before calling query_data.

ISO-NE MCP API reference
HTTP endpoint
POST /api/v1/datasets/isone_actual_interchange/query

Schema7

Column
Type
event_timeDateTime64(6, 'UTC')
location_idLowCardinality(String)
location_nameNullable(String)
act_interchangeNullable(Float64)
purchaseNullable(Float64)
saleNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample data

event_timelocation_idlocation_nameact_interchangepurchasesaleingested_at
2026-09-28 03:00:00.0000004018.I.HQMRL_RD345 1-1120-112002026-09-28 05:25:05.735423
2026-09-28 03:00:00.0000004017.I.NRTHPORT138 5680682026-09-28 05:25:05.735423
2026-09-28 03:00:00.0000004014.I.SHOREHAM138 9933003302026-09-28 05:25:05.735423
2026-09-28 03:00:00.0000004013.I.HQHIGATE120 2-47-4702026-09-28 05:25:05.735423
2026-09-28 03:00:00.0000004012.I.HQ_P1_P2345 598209822026-09-28 05:25:05.735423
2026-09-28 03:00:00.0000004011.I.ROSETON 345 1281.5-10391320.52026-09-28 05:25:05.735423
2026-09-28 03:00:00.0000004010.I.SALBRYNB345 1-106-10602026-09-28 05:25:05.735423
2026-09-28 02:00:00.0000004018.I.HQMRL_RD345 1-1120-112002026-09-28 04:25:04.898867
2026-09-28 02:00:00.0000004017.I.NRTHPORT138 5660662026-09-28 04:25:04.898867
2026-09-28 02:00:00.0000004014.I.SHOREHAM138 9933003302026-09-28 04:25:04.898867
2026-09-28 02:00:00.0000004013.I.HQHIGATE120 2-47-4702026-09-28 04:25:04.898867
2026-09-28 02:00:00.0000004012.I.HQ_P1_P2345 598209822026-09-28 04:25:04.898867
2026-09-28 02:00:00.0000004011.I.ROSETON 345 1438.25-10031441.252026-09-28 04:25:04.898867
2026-09-28 02:00:00.0000004010.I.SALBRYNB345 1-84-8402026-09-28 04:25:04.898867
2026-09-28 01:00:00.0000004018.I.HQMRL_RD345 1-1120-112002026-09-28 03:25:04.562435
2026-09-28 01:00:00.0000004017.I.NRTHPORT138 510201022026-09-28 03:25:04.562435
2026-09-28 01:00:00.0000004014.I.SHOREHAM138 9933003302026-09-28 03:25:04.562435
2026-09-28 01:00:00.0000004013.I.HQHIGATE120 2-47-4702026-09-28 03:25:04.562435
2026-09-28 01:00:00.0000004012.I.HQ_P1_P2345 5901-819822026-09-28 03:25:04.562435
2026-09-28 01:00:00.0000004011.I.ROSETON 345 1422-109315152026-09-28 03:25:04.562435
2026-09-28 01:00:00.0000004010.I.SALBRYNB345 138-2402026-09-28 03:25:04.562435
2026-09-28 00:00:00.0000004018.I.HQMRL_RD345 1-1120-112002026-09-28 02:25:05.304099
2026-09-28 00:00:00.0000004017.I.NRTHPORT138 510401042026-09-28 02:25:05.304099
2026-09-28 00:00:00.0000004014.I.SHOREHAM138 9933003302026-09-28 02:25:05.304099
2026-09-28 00:00:00.0000004013.I.HQHIGATE120 2-40-4002026-09-28 02:25:05.304099

Coverage

100.0% complete0 gap days1,732 days with data
Show coverage history
Coverage: 100.0%Days with data: 1,732Gaps: 0
2026
2025
2024
2023
2022
gaplessmore