Wholesale Electricity Market Prices - Day-Ahead and Real-Time
This dataset provides granular locational marginal price (LMP) data from major US ISO/RTO electricity markets, including breakdowns by energy, congestion, and loss components for day-ahead and real-time intervals. It enables comprehensive analysis of market dynamics, risk management, and operational strategies for generation dispatch and financial hedging. Ideal for market participants, analysts, and researchers seeking insights into price formation and grid operations.
Sample rows
preview · 8 of 250 rows · all 14 columns| market_idstring | price_typestring | interval_length_minutesinteger | productstring | node_idstring | node_namestring | service_typestring | price_datetimedatetime | lmp_pricefloat | lmp_energy_componentfloat | lmp_congestion_componentfloat | lmp_loss_componentfloat | currencystring | market_datedate |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PJM | day-ahead | 60 | day-ahead energy | PJM-ZONE-NJ01 | New Jersey Zone Bus | energy | 2024-04-05T11:00:00Z | 38.55 | 36.85 | 1.21 | 0.49 | USD | 2024-04-05 |
| ERCOT | real-time | 5 | real-time energy | ERCOT-BUS-HOU01 | Houston Area Bus | energy | 2024-04-05T11:05:00Z | 51.43 | 48.9 | 2.26 | 0.27 | USD | 2024-04-05 |
| CAISO | day-ahead | 60 | day-ahead energy | CAISO-SUB-LA07 | Los Angeles Substation | energy | 2023-12-12T00:00:00Z | 42.12 | 40.56 | 1.37 | 0.19 | USD | 2023-12-12 |
| NYISO | real-time | 15 | real-time energy | NYISO-BUS-NYC05 | NYC Zone 5 Bus | energy | 2022-07-07T23:45:00Z | -10.23 | -9.83 | -0.27 | -0.13 | USD | 2022-07-07 |
| MISO | day-ahead | 60 | day-ahead energy | MISO-ZONE-IL03 | Illinois Zone 3 | energy | 2024-05-20T13:00:00Z | 29.88 | 28.43 | 1.03 | 0.42 | USD | 2024-05-20 |
| ISO-NE | real-time | 15 | real-time energy | ISO-NE-BUS-BOS02 | Boston Area Bus | energy | 2023-09-03T22:45:00Z | 62.12 | 58.97 | 2.89 | 0.26 | USD | 2023-09-03 |
| SPP | day-ahead | 60 | day-ahead energy | SPP-BUS-OKC04 | Oklahoma City Bus | energy | 2021-03-18T17:00:00Z | -25.77 | -24.89 | -0.74 | -0.14 | USD | 2021-03-18 |
| PJM | real-time | 5 | real-time energy | PJM-BUS-PHIL03 | Philadelphia Bus | energy | 2024-03-29T15:05:00Z | 141.67 | 137.22 | 4.18 | 0.27 | USD | 2024-03-29 |
| CAISO | day-ahead | 60 | day-ahead energy | CAISO-BUS-SF11 | San Francisco Bus | energy | 2024-01-14T09:00:00Z | 45.6 | 43.92 | 1.13 | 0.55 | USD | 2024-01-14 |
| ISO-NE | real-time | 15 | real-time energy | ISO-NE-ZONE-NH01 | New Hampshire Zone 1 | energy | 2024-04-05T10:15:00Z | 32.31 | 31.11 | 0.89 | 0.31 | USD | 2024-04-05 |
| ERCOT | day-ahead | 60 | day-ahead energy | ERCOT-ZONE-DAL02 | Dallas Zone 2 | energy | 2023-10-08T16:00:00Z | 93.42 | 89.85 | 2.87 | 0.7 | USD | 2023-10-08 |
| MISO | real-time | 15 | real-time energy | MISO-BUS-MN04 | Minnesota Bus 4 | energy | 2022-02-11T20:15:00Z | 75.19 | 72.13 | 2.55 | 0.51 | USD | 2022-02-11 |
| NYISO | day-ahead | 60 | day-ahead energy | NYISO-ZONE-ALB01 | Albany Area Zone 1 | energy | 2023-11-29T07:00:00Z | -17.1 | -16.33 | -0.43 | -0.34 | USD | 2023-11-29 |
| SPP | real-time | 5 | real-time energy | SPP-ZONE-TUL01 | Tulsa Zone 1 | energy | 2022-04-27T18:05:00Z | -31.42 | -30.48 | -0.63 | -0.31 | USD | 2022-04-27 |
| CAISO | day-ahead | 60 | day-ahead energy | CAISO-ZONE-SD03 | San Diego Zone 3 | energy | 2023-05-04T06:00:00Z | 49.18 | 47.22 | 1.51 | 0.45 | USD | 2023-05-04 |
| PJM | real-time | 1 | real-time energy | PJM-BUS-DC02 | Washington DC Bus | energy | 2024-02-21T20:01:00Z | 154.04 | 148.92 | 4.89 | 0.23 | USD | 2024-02-21 |
| ERCOT | day-ahead | 60 | day-ahead energy | ERCOT-SUB-AUS01 | Austin Substation | energy | 2023-03-21T12:00:00Z | 67.27 | 63.89 | 2.91 | 0.47 | USD | 2023-03-21 |
| MISO | real-time | 15 | real-time energy | MISO-ZONE-IN02 | Indiana Zone 2 | energy | 2024-05-20T13:30:00Z | 83.95 | 80.51 | 2.94 | 0.5 | USD | 2024-05-20 |
| ISO-NE | day-ahead | 60 | day-ahead energy | ISO-NE-SUB-ME01 | Maine Substation | energy | 2022-06-10T17:00:00Z | 21.06 | 20.22 | 0.63 | 0.21 | USD | 2022-06-10 |
| NYISO | real-time | 5 | real-time energy | NYISO-BUS-ROC02 | Rochester Bus 2 | energy | 2023-08-14T18:05:00Z | -4.88 | -4.62 | -0.17 | -0.09 | USD | 2023-08-14 |
What the 250 rows show
from the 250-row sampleDay-ahead (price type) stands out: mean interval_
- 60median interval_
length_ minutes - 3service types
- 7markets
- 42.1median lmp_
price - 43.4median lmp_
energy_ component - 1.5median lmp_
congestion_ component
Median 60, from 1 to 60.
- string 7
- integer 1
- float 4
- date 1
- datetime 1
Columns
14 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 7 columns | |||
market_id | string | Unique identifier for the ISO/RTO market (e.g., PJM, ERCOT, CAISO, MISO, NYISO, ISO-NE, SPP)7 values | PJM |
node_id | string | Unique identifier for the market node or location (e.g., substation, bus, zone) | PJM-ZONE-NJ01 |
node_name | string | Human-readable name of the market node or locationoptional | New Jersey Zone Bus |
service_type | string | Type of market service (energy, capacity, or ancillary)energy · capacity · ancillary | energy |
product | string | Specific product within the service type (e.g., day-ahead energy, real-time energy, regulation, spinning reserve)8 products | day-ahead energy |
price_type | string | Type of price reported (day-ahead or real-time)day-ahead · real-time | day-ahead |
currency | string | Currency in which the price is denominated (typically USD)USD | USD |
| Numbers 5 columns | |||
interval_length_minutes | integer | Length of the market interval in minutes (e.g., 5, 15, 60)1 or more | 60 |
lmp_price | float | Locational Marginal Price in $/MWh for the specified node, product, and interval | 38.55 |
lmp_energy_component | float | Energy component of the LMP in $/MWhoptional | 36.85 |
lmp_congestion_component | float | Congestion component of the LMP in $/MWhoptional | 1.21 |
lmp_loss_component | float | Loss component of the LMP in $/MWhoptional | 0.49 |
| Dates and times 2 columns | |||
price_datetime | datetime | Timestamp for the price (market interval start time, typically in UTC) | 2024-04-05T11:00:00Z |
market_date | date | Date of the market interval (derived from price_datetime) | 2024-04-05 |
Use it for
An energy dashboard
Interval_
length_ minutes by price_ type and a breakdown of product. Excel, Power BI or Tableau. Why do the 141 day-ahead rows have a mean interval_
length_ minutes of 55.9? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Markets250PJM60day-aheadERCOT5real-timeCAISO60day-ahead
A software demo
Believable markets with node_
id, node_ name and service_ type to fill a screen in front of a buyer.
This dataset250 rows14 columns
Yours1,000 rows14 columns
blueprint · wholesale-electricity-market-prices-day-ahead-and-real-time
Behind this dataset
Same schema. As many rows as you need.
These 250 rows came out of a blueprint — 14 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
Rules it was built with
- ISO/RTO market: PJM, ERCOT, CAISO, MISO, NYISO, ISO-NE, SPP
- Pricing node (bus) ID and zone/hub aggregation
- Day-ahead LMP ($/MWh) cleared in day-ahead market auction
- Real-time LMP ($/MWh) for 5-minute or 15-minute intervals
- LMP components: energy price, congestion, losses
- Ancillary services: regulation, spinning reserve, non-spinning reserve prices
- Capacity market prices ($/MW-day) for resource adequacy
- Negative pricing events from excess wind/solar generation
Open the blueprint in Data Factory
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- wholesale-electricity-market-prices-day-ahead-and-real-time