Day-Ahead Ex-Post LMP

MISO's day-ahead ex-post locational marginal prices for the full nodal set of roughly 2,600 generator nodes, load zones, hubs, and interfaces, one row per node per operating hour.

Prices data MISO market

Open in Data Ask the agent

One row per: event_time x node; Hourly (day-ahead, published next day) cadence
Evidence: Cleared day-ahead market; A market outcome, not a physical observation
Time basis: Point-in-time records; UTC · event_time

Overview

Each row carries total LMP with its congestion (mcc) and marginal-loss (mlc) components in dollars per MWh; the energy component is lmp less mcc and mlc. event_time is hour-beginning UTC. These are the day-ahead prices a node settles at, published the morning after the operating day and restated when MISO re-runs settlement, so read the latest load per node and hour. A congestion component does not by itself identify which constraint bound. Unlike miso.live_lmp, a consolidated snapshot of 325 locations, this covers every node and is addressable by market date.

Query contract: Preserve one canonical row per (event_time, node) before aggregating.
Analysis rules: Group only after preserving the declared grain: event_time, node.

Access

Download: Query it in SQL, download it, or read it with an API key. Download data
MCP: Connect an MCP client and load the contract with describe_data before calling query_data.MISO MCP API reference
HTTP endpoint: POST /api/v1/datasets/miso_da_expost_lmp/query
Full history: Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

8 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`market_date`	`Date32`
`node`	`LowCardinality(String)`
`node_type`	`LowCardinality(String)`
`lmp`	`Nullable(Float64)`
`mcc`	`Nullable(Float64)`
`mlc`	`Nullable(Float64)`
`ingested_at`	`DateTime64(6, 'UTC')`

Sample data

event_time	market_date	node	node_type	lmp	mcc	mlc	ingested_at
2026-11-02 04:00:00.000000	2026-11-01	YAD	Interface	31.99	5	0.47	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WR.THAYERLD	Loadzone	34.67	8.19	-0.04	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WR.MOWR_1.AZ	Hub	34.89	8.47	-0.1	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WR.MOWR	Loadzone	34.84	8.42	-0.1	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WR.MEUC_1.AZ	Hub	34.67	8.19	-0.04	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WR.MEUCLADD	Gennode	29.44	4.18	-1.26	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WR.MEUCFRED2	Gennode	34.13	8.08	-0.47	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WR.MEUCFRED1	Gennode	34.13	8.08	-0.47	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WR	Interface	10	-14.6	-1.92	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WPS.WPSM	Loadzone	22.46	-6.76	2.7	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WPS.WPSE	Loadzone	22.81	-6.75	3.04	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WPS.WESTON4	Gennode	21.91	-6.8	2.19	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WPS.WESTON3	Gennode	21.88	-6.8	2.16	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WPS.WESTON17	Gennode	21.95	-6.8	2.23	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WPS.WESTON16	Gennode	21.95	-6.8	2.23	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WPS.WESTON15	Gennode	21.95	-6.8	2.23	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WPS.WESTON14	Gennode	21.95	-6.8	2.23	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WPS.WESTON13	Gennode	21.95	-6.8	2.23	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WPS.WESTON12	Gennode	21.95	-6.8	2.23	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WPS.WESTON11	Gennode	21.95	-6.8	2.23	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WPS.WESRCE2_LD	Loadzone	21.95	-6.8	2.23	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WPS.WESRCE1_LD	Loadzone	21.95	-6.8	2.23	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WPS.WEM33	Gennode	22.72	-6.75	2.95	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WPS.WEM32	Gennode	22.72	-6.75	2.95	2026-11-02 13:43:43.436274
2026-11-02 04:00:00.000000	2026-11-01	WPS.WEM31	Gennode	22.75	-6.75	2.98	2026-11-02 13:43:43.436274

Coverage

Complete: 100.0%
Gap days: 0
Days with data: 7,810

Show coverage history

Coverage: 100.0%Days with data: 7,810Gaps: 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

gaplessmore

Related data

Related prices data
Dataset	Description
Live Consolidated LMPMISO · 1-minute snapshots; 5-minute RT and hourly market runs	MISO's public consolidated price snapshot for 325 official hubs, load-zone nodes, generator nodes, and interfaces. It carries five-minute real-time, hourly integrated real-time, day-ahead ex-ante, and day-ahead ex-post runs plus published loss and congestion components; marginal energy is derived as LMP less those two components. event_time/ref_id identify when the snapshot was requested; raw_interval is the market-run delivery label, so a day-ahead snapshot is a current-hour comparison rather than a forward delivery curve.
MISO Day-Ahead PricesMISO · hourly	MISO day-ahead locational marginal prices, one row per interval and location. 499k rows, 2026-08-12 to the next delivery day. Carries price_usd_mwh plus congestion_usd_mwh and loss_usd_mwh as MISO publishes them; energy_usd_mwh is the residual. Locations are generator, zone, interface and hub; location_id joins atg.miso_locations for the readable name, and kind is carried inline so a hub-only or zone-only question needs no join at all. Every market's day-ahead price table in this catalog has these same column names, so a cross-market price comparison is a UNION rather than a per-ISO rewrite. Revisions are already collapsed — read it plainly.
MISO Real-Time PricesMISO · 5-minute	MISO real-time locational marginal prices, one row per interval and location. 5.7M rows, 2026-08-12 to now. Carries price_usd_mwh plus congestion_usd_mwh and loss_usd_mwh as MISO publishes them; energy_usd_mwh is the residual, so the components sum to the price by construction. Locations are generator (1,859), zone (493), interface (22) and hub (8); location_id joins atg.miso_locations for the readable name, and kind is carried inline so a hub-only or zone-only question needs no join at all. Every market's real-time price table in this catalog has these same column names, so a cross-market price comparison is a UNION rather than a per-ISO rewrite. Revisions are already collapsed — read it plainly.
Real-Time Five-Minute LMPMISO · 5 minutes	MISO's real-time preliminary ex-post locational marginal prices for the full nodal set of roughly 2,600 generator nodes, load zones, hubs, and interfaces, one row per node per five-minute interval. Each row carries total LMP with its congestion (mcc) and marginal-loss (mlc) components in dollars per MWh; the energy component is lmp less mcc and mlc. event_time is interval-beginning UTC. Prices are preliminary: MISO restates real-time prices in its final settlement reports. Unlike miso.live_lmp, a consolidated snapshot of 325 locations with ex-ante prices, this covers every node.