MISO Day-Ahead Prices

MISO day-ahead locational marginal prices, one row per interval and location.

Prices data MISO market

Query with the agent

Native record

location x kind x delivery hour

hourly publication cadence

Evidence

Cleared day-ahead market

A market outcome, not a physical observation

Time basis

Interval-start records

UTC · event_time

Overview

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.

Query contract

One row is already the canonical price for (event_time, location_id, kind) — the refresh collapsed the source's revisions. Select the interval and the locations you need; do not de-duplicate again. Day-ahead rows for the next delivery day are published in a single late-evening batch, so max(event_time) runs ahead of the wall clock by design.

Analysis rules

Prices are intensive. Averaging across intervals gives a simple (unweighted) average price, which is not a settlement or load-weighted price; say which one you computed. Never sum prices across intervals or locations.
Do not add price_usd_mwh to its own components — they decompose it, they do not extend it.

Related analysis

resolving a location's readable name and type · join on location_id, and on kind where both carry it
day-ahead versus real-time basis at one location · aggregate the real-time intervals in the delivery hour before comparing

Interpretation

This is MISO's day-ahead EX-ANTE LMP, the price the day-ahead clearing produced. MISO settles day-ahead schedules at the day-ahead EX-POST LMP, a pricing re-run that differs from ex-ante on most hours by up to about $9/MWh; miso_da_expost_lmp carries the ex-post series. Say which one a figure is, and use ex-post for a settlement question.
History begins 2026-08-12. MISO's market clock is EST all year; local hour labels here follow America/Chicago, which equals EST only during daylight time.

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.

MISO MCP API reference

HTTP endpoint

POST /api/v1/datasets/miso_prices_da/query

Need the full history of this dataset in Snowflake, Databricks or your own storage? Data services delivers it on a schedule.

Schema7

Column

Type

event_timeDateTime64(6, 'UTC')

location_idLowCardinality(String)

kindLowCardinality(String)

price_usd_mwhNullable(Float64)

energy_usd_mwhNullable(Float64)

congestion_usd_mwhNullable(Float64)

loss_usd_mwhNullable(Float64)

Sample data

event_time	location_id	kind	price_usd_mwh	energy_usd_mwh	congestion_usd_mwh	loss_usd_mwh
2026-10-17 04:00:00.000000	DPC.JPM	generator	35.71	33.12	3.24	-0.65
2026-10-17 04:00:00.000000	CLEC.CPS6	generator	25.21	33.120000000000005	-6.91	-1
2026-10-17 04:00:00.000000	AMMO.WVPA	zone	30.07	33.120000000000005	-2.1	-0.95
2026-10-17 04:00:00.000000	DUK	interface	33.08	33.12	-0.83	0.79
2026-10-17 04:00:00.000000	CPLW	interface	32.98	33.12	-0.88	0.74
2026-10-17 04:00:00.000000	AMMO.UE.AZ	zone	29.04	33.12	-2.6	-1.48
2026-10-17 04:00:00.000000	EAI.AECCHYDRO2	generator	30.64	33.120000000000005	-2.31	-0.17
2026-10-17 04:00:00.000000	EES.BC1_4	generator	27.49	33.12	-5.2	-0.43
2026-10-17 04:00:00.000000	EES.ENCO	generator	27.73	33.12	-5.2	-0.19
2026-10-17 04:00:00.000000	AMMO.UE	zone	29.1	33.12	-2.58	-1.44
2026-10-17 04:00:00.000000	CLEC.CPS6ST	generator	25.19	33.12	-6.92	-1.01
2026-10-17 04:00:00.000000	EAI.AECCHYDRO9	generator	21.85	33.12	-9.36	-1.91
2026-10-17 04:00:00.000000	AMMO.SIOUX2	generator	28.93	33.12	-2.41	-1.78
2026-10-17 04:00:00.000000	EES.CARV_BC	generator	27.63	33.12	-5.2	-0.29
2026-10-17 04:00:00.000000	EAI.AECCMCCLLN	generator	21.58	33.12	-10.49	-1.05
2026-10-17 04:00:00.000000	AMMO.SIOUX1	generator	28.87	33.120000000000005	-2.5	-1.75
2026-10-17 04:00:00.000000	EAI.AECCMGVCT1	generator	21.25	33.12	-10.07	-1.8
2026-10-17 04:00:00.000000	AMMO.RUSHIS2	generator	30.86	33.120000000000005	-2.42	0.16
2026-10-17 04:00:00.000000	ALTE.COLUMBAL1	generator	35.69	33.12	1.84	0.73
2026-10-17 04:00:00.000000	EES.BYCT3	generator	26.09	33.12	-6.74	-0.29
2026-10-17 04:00:00.000000	EES.ESSO	generator	27.73	33.12	-5.2	-0.19
2026-10-17 04:00:00.000000	EES.BC1_3	generator	27.49	33.12	-5.2	-0.43
2026-10-17 04:00:00.000000	EAI.AECCMGVCT2	generator	21.25	33.12	-10.07	-1.8
2026-10-17 04:00:00.000000	EAI.BLAKELY1	generator	21.8	33.12	-10.41	-0.91
2026-10-17 04:00:00.000000	EAI.BLAKELY2	generator	21.8	33.12	-10.41	-0.91

Coverage

No time-indexed data — coverage isn’t applicable to this dataset.

Related prices data

Related prices data
Dataset	Description
Day-Ahead Ex-Post LMPMISO · hourly (day-ahead, published next day)	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. 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.
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 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.