Monthly LMP Index

ISO-NE's published Monthly LMP Index source feed.

Prices data

Download data

Native record

event_time x location_id

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, location_id) before aggregating.

Analysis rules

Group only after preserving the declared grain: event_time, location_id.

Schema10

Column

Type

event_timeDateTime64(6, 'UTC')

location_idLowCardinality(String)

location_nameNullable(String)

da_on_peak_lmpNullable(Float64)

da_off_peak_lmpNullable(Float64)

da_average_lmpNullable(Float64)

rt_on_peak_lmpNullable(Float64)

rt_off_peak_lmpNullable(Float64)

rt_average_lmpNullable(Float64)

ingested_atDateTime64(6, 'UTC')

Sample data

event_time	location_id	location_name	da_on_peak_lmp	da_off_peak_lmp	da_average_lmp	rt_on_peak_lmp	rt_off_peak_lmp	rt_average_lmp	ingested_at
2026-07-01 04:00:00.000000	4008	.Z.NEMASSBOST	86.37	49.04	67.51	64.5	45.78	55.04	2026-09-01 07:00:15.083128
2026-07-01 04:00:00.000000	4007	.Z.WCMASS	85.81	48.72	67.07	64.08	45.6	54.74	2026-09-01 07:00:15.083128
2026-07-01 04:00:00.000000	4006	.Z.SEMASS	86.15	49.15	67.45	64.37	45.85	55.01	2026-09-01 07:00:15.083128
2026-07-01 04:00:00.000000	4005	.Z.RHODEISLAND	85.16	48.45	66.61	63.49	45.23	54.26	2026-09-01 07:00:15.083128
2026-07-01 04:00:00.000000	4004	.Z.CONNECTICUT	84.35	47.51	65.73	63.28	44.68	53.88	2026-09-01 07:00:15.083128
2026-07-01 04:00:00.000000	4003	.Z.VERMONT	86.65	49.11	67.67	65.87	45.99	55.83	2026-09-01 07:00:15.083128
2026-07-01 04:00:00.000000	4002	.Z.NEWHAMPSHIRE	85.23	48.33	66.58	63.19	45.17	54.09	2026-09-01 07:00:15.083128
2026-07-01 04:00:00.000000	4001	.Z.MAINE	69.38	44.57	56.84	52.36	41.18	46.71	2026-09-01 07:00:15.083128
2026-07-01 04:00:00.000000	4000	.H.INTERNAL_HUB	85.67	48.71	66.99	63.97	45.56	54.66	2026-09-01 07:00:15.083128
2026-06-01 04:00:00.000000	4008	.Z.NEMASSBOST	57.11	45.57	51.21	56.29	46.79	51.43	2026-08-01 07:00:14.199443

Coverage

3.3% complete2,827 gap days96 days with data

Show coverage history

Coverage: 3.3%Days with data: 96Gaps: 2,827

2026

2025

2024

2023

2022

2021

2020

2019

2018

gaplessmore

Related prices data

Related prices data
Dataset	Description
AMSISONE · ISO-NE source publication	ISO-NE's published AMS source feed. 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.
Daily Offer Threshold PriceISONE · ISO-NE source publication	ISO-NE's published Daily Offer Threshold Price source feed. 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.
DR Threshold PriceISONE · ISO-NE source publication	ISO-NE's published DR Threshold Price source feed. 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.
FRM DTPISONE · ISO-NE source publication	ISO-NE's published FRM DTP source feed. 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.