Ask the Grid

Overview

ISO-NE locational marginal prices for physical PNodes, eight load zones, the Internal Hub, and external nodes. Filter market_run and scope before use; lmp_total is accompanied by energy, congestion, and loss components.

Use with MCP

This table is available through the signed-in, read-only Ask the Grid MCP server. Connect a market below, then use search_data or describe_data to load its query contract before calling query_data.

Schema11

Column
Type
event_timeDateTime64(6, 'UTC')
market_runLowCardinality(String)
scopeLowCardinality(String)
location_idLowCardinality(String)
location_nameNullable(String)
location_typeNullable(String)
lmp_totalNullable(Float64)
energy_componentNullable(Float64)
congestion_componentNullable(Float64)
loss_componentNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample rows

event_timemarket_runscopelocation_idlocation_namelocation_typelmp_totalenergy_componentcongestion_componentloss_componentingested_at
2026-08-13 22:45:00.000000rt_5mhub4018.I.HQMRL_RD345 1EXT. NODE71.8579.30-7.452026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mhub4017.I.NRTHPORT138 5EXT. NODE78.1779.30-1.132026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mhub4014.I.SHOREHAM138 99EXT. NODE80.1679.300.862026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mhub4013.I.HQHIGATE120 2EXT. NODE79.6179.300.312026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mhub4012.I.HQ_P1_P2345 5EXT. NODE78.7479.30-0.562026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mhub4011.I.ROSETON 345 1EXT. NODE77.6379.30-1.672026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mhub4010.I.SALBRYNB345 1EXT. NODE74.7879.30-4.522026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mhub4008.Z.NEMASSBOSTLOAD ZONE80.2379.300.932026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mhub4007.Z.WCMASSLOAD ZONE79.6979.300.392026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mhub4006.Z.SEMASSLOAD ZONE80.5279.301.222026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mhub4005.Z.RHODEISLANDLOAD ZONE79.2279.30-0.082026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mhub4004.Z.CONNECTICUTLOAD ZONE78.6879.30-0.622026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mhub4003.Z.VERMONTLOAD ZONE79.9479.300.642026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mhub4002.Z.NEWHAMPSHIRELOAD ZONE79.2779.30-0.032026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mhub4001.Z.MAINELOAD ZONE75.8979.30-3.412026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mhub4000.H.INTERNAL_HUBHUB79.5679.300.262026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mall77616UN.CONGRESS13.8CSFCNETWORK NODE78.0479.30-1.262026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mall77615UN.ROXBURY 34.5TWNWNETWORK NODE71.9479.30-7.362026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mall774UN.E_FAIRFX34.5LLAMNETWORK NODE80.0279.300.722026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mall77305UN.TASKERFM34.5NUTSNETWORK NODE79.5379.300.232026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mall77304UN.3RIVRSME34.5TRSNETWORK NODE74.1279.30-5.182026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mall769UN.N_CANAL 34.5HADLNETWORK NODE79.379.3002026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mall768UN.GARVINS 34.5GARVNETWORK NODE79.5479.300.242026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mall767UN.OAK_HILL34.5CONCNETWORK NODE80.0179.300.712026-08-13 22:50:21.029277
2026-08-13 22:45:00.000000rt_5mall7619DR.RI_Rhode_IslandDRRAZ79.2279.30-0.082026-08-13 22:50:21.029277

Coverage

100.0% complete0 gap days85 days with data
Show coverage history ▾
Coverage: 100.0%Days with data: 85Gaps: 0
2026
gaplessmore