Locational marginal prices for power markets around the world, down to 5 minute granularity.
Part of the Foreman Intelligence Data Dictionary. Model: customer_access. Generated from the live Looker model on 2026-09-04.
Contents
Explores in this group
LMPs lmps
Looker description: Locational Marginal Pricing for many zones in the world with granularity up to 5 minutes
Locational marginal prices (LMPs) for power markets Foreman tracks, keyed by ISO, market, and zone, at 5 minute granularity where the market publishes it. This is the price signal curtailment logic compares against strike prices. It stands alone with no miner data, so it is quick to query.
| Grain | One row per ISO, market, and zone per 5 or 15 minutes |
| Time field | Timestamp Date (5 minute, 15 minute, hourly, or daily) |
| Best for |
|
Example questions
- What was the average real-time price in our zone each hour yesterday?
- How many 5 minute intervals were above $100/MWh last month?
- How does day-ahead compare with real-time for the same day?
Views in this explore: LMPs
Fields by view
Each explore is built from one or more views. A view is a set of related fields, and the tables below list every visible field in each view this article owns. Dimensions are attributes you can group and filter by. Measures are aggregates that add up, average, or count across the rows you select.
LMPs
Locational marginal prices: the wholesale price of power at a specific place on the grid, published by each ISO for its markets and zones. Foreman stores them at the finest granularity the market publishes (5 minutes for most real-time markets, hourly for day-ahead). This is the price signal that strike price curtailment compares against.
Used by: Strike Price Data, LMPs
Dimensions
| Field | Type | What it means |
|---|---|---|
| Currency | Text | Currency of the price. Blank means US dollars. |
| ISO | Text | The grid operator: ercot, pjm, miso, spp, nyiso, iso-ne, ieso, aeso, aemo, or omie. demo holds test data. |
| Market | Text | Which market the price is from: day-ahead or real-time. |
| Price | Number | Price per megawatt-hour. |
| Primary Key | Text | Internal unique key for the row. Not useful for analysis. |
| Timestamp Date | Date / time (5 minute, 15 minute, Hour, Date) | Time the price applies to, at 5 minute, 15 minute, hourly, or daily grain. |
| Zone | Text | Pricing node or load zone within the ISO. |
Measures
| Measure | Type | What it means |
|---|---|---|
| Average Price | Average | Average price across the selected rows. |
| Total Price | Sum | Sum of prices across the selected rows. Mostly useful for weighted calculations. |
Comments
0 comments
Please sign in to leave a comment.