LMP Pricing Data#
Support#
Below are the currently supported LMP markets
Method |
REAL_TIME_5_MIN |
REAL_TIME_15_MIN |
DAY_AHEAD_HOURLY |
REAL_TIME_HOURLY |
REAL_TIME_HOURLY_FINAL |
REAL_TIME_HOURLY_PRELIM |
|
|---|---|---|---|---|---|---|---|
CAISO |
|
latest, today, historical |
latest, today, historical |
latest, today, historical |
- |
- |
- |
Ercot |
|
- |
- |
- |
- |
- |
- |
IESO |
- |
- |
- |
- |
- |
- |
- |
ISONE |
|
latest, today, historical |
- |
today, historical |
latest, today, historical |
- |
- |
MISO |
|
latest, today |
- |
today, historical |
- |
historical |
historical |
NYISO |
|
latest, today, historical |
latest, today |
latest, today, historical |
- |
- |
- |
PJM |
|
latest, today, historical |
- |
today, historical |
today, historical |
- |
- |
SPP |
- |
- |
- |
- |
- |
- |
- |
How to use#
We are currently adding Locational Marginal Price (LMP). Even though each BA offers different markets, but you can query them with a standardized API
import gridstatus
nyiso = gridstatus.NYISO()
nyiso.get_lmp(date="today", market="REAL_TIME_5_MIN", locations="ALL")
| Time | Interval Start | Interval End | Market | Location | Location Type | LMP | Energy | Congestion | Loss | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2024-10-04 00:00:00-04:00 | 2024-10-04 00:00:00-04:00 | 2024-10-04 00:05:00-04:00 | REAL_TIME_5_MIN | CAPITL | Zone | 24.06 | 23.18 | -0.0 | 0.88 |
| 1 | 2024-10-04 00:00:00-04:00 | 2024-10-04 00:00:00-04:00 | 2024-10-04 00:05:00-04:00 | REAL_TIME_5_MIN | WEST | Zone | 22.72 | 23.18 | -0.0 | -0.46 |
| 2 | 2024-10-04 00:00:00-04:00 | 2024-10-04 00:00:00-04:00 | 2024-10-04 00:05:00-04:00 | REAL_TIME_5_MIN | PJM | Zone | 23.25 | 23.18 | -0.0 | 0.07 |
| 3 | 2024-10-04 00:00:00-04:00 | 2024-10-04 00:00:00-04:00 | 2024-10-04 00:05:00-04:00 | REAL_TIME_5_MIN | O H | Zone | 22.32 | 23.18 | -0.0 | -0.86 |
| 4 | 2024-10-04 00:00:00-04:00 | 2024-10-04 00:00:00-04:00 | 2024-10-04 00:05:00-04:00 | REAL_TIME_5_MIN | NPX | Zone | 23.99 | 23.18 | -0.0 | 0.81 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 1840 | 2024-10-04 10:00:00-04:00 | 2024-10-04 10:00:00-04:00 | 2024-10-04 10:05:00-04:00 | REAL_TIME_5_MIN | H Q | Zone | 26.41 | 26.28 | -0.0 | 0.13 |
| 1841 | 2024-10-04 10:00:00-04:00 | 2024-10-04 10:00:00-04:00 | 2024-10-04 10:05:00-04:00 | REAL_TIME_5_MIN | GENESE | Zone | 26.39 | 26.28 | -0.0 | 0.11 |
| 1842 | 2024-10-04 10:00:00-04:00 | 2024-10-04 10:00:00-04:00 | 2024-10-04 10:05:00-04:00 | REAL_TIME_5_MIN | DUNWOD | Zone | 27.73 | 26.29 | -0.0 | 1.44 |
| 1843 | 2024-10-04 10:00:00-04:00 | 2024-10-04 10:00:00-04:00 | 2024-10-04 10:05:00-04:00 | REAL_TIME_5_MIN | CENTRL | Zone | 26.28 | 26.28 | -0.0 | 0.00 |
| 1844 | 2024-10-04 10:00:00-04:00 | 2024-10-04 10:00:00-04:00 | 2024-10-04 10:05:00-04:00 | REAL_TIME_5_MIN | CAPITL | Zone | 26.94 | 26.28 | -0.0 | 0.66 |
1845 rows × 10 columns
And here is querying CAISO
import gridstatus
caiso = gridstatus.CAISO()
locations = ["TH_NP15_GEN-APND", "TH_SP15_GEN-APND", "TH_ZP26_GEN-APND"]
caiso.get_lmp(date="today", market='DAY_AHEAD_HOURLY', locations=locations)
| Time | Interval Start | Interval End | Market | Location | Location Type | LMP | Energy | Congestion | Loss | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2024-10-04 00:00:00-07:00 | 2024-10-04 00:00:00-07:00 | 2024-10-04 01:00:00-07:00 | DAY_AHEAD_HOURLY | TH_NP15_GEN-APND | Trading Hub | 47.45667 | 51.21589 | -3.42119 | -0.33802 |
| 1 | 2024-10-04 00:00:00-07:00 | 2024-10-04 00:00:00-07:00 | 2024-10-04 01:00:00-07:00 | DAY_AHEAD_HOURLY | TH_SP15_GEN-APND | Trading Hub | 48.47623 | 51.21589 | -0.73199 | -2.00766 |
| 2 | 2024-10-04 00:00:00-07:00 | 2024-10-04 00:00:00-07:00 | 2024-10-04 01:00:00-07:00 | DAY_AHEAD_HOURLY | TH_ZP26_GEN-APND | Trading Hub | 47.93687 | 51.21589 | -1.11771 | -2.16131 |
| 3 | 2024-10-04 01:00:00-07:00 | 2024-10-04 01:00:00-07:00 | 2024-10-04 02:00:00-07:00 | DAY_AHEAD_HOURLY | TH_NP15_GEN-APND | Trading Hub | 45.49581 | 49.04301 | -3.14015 | -0.40706 |
| 4 | 2024-10-04 01:00:00-07:00 | 2024-10-04 01:00:00-07:00 | 2024-10-04 02:00:00-07:00 | DAY_AHEAD_HOURLY | TH_SP15_GEN-APND | Trading Hub | 46.89990 | 49.04301 | -0.42660 | -1.71651 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 67 | 2024-10-04 22:00:00-07:00 | 2024-10-04 22:00:00-07:00 | 2024-10-04 23:00:00-07:00 | DAY_AHEAD_HOURLY | TH_SP15_GEN-APND | Trading Hub | 56.86215 | 59.88382 | -0.45864 | -2.56303 |
| 68 | 2024-10-04 22:00:00-07:00 | 2024-10-04 22:00:00-07:00 | 2024-10-04 23:00:00-07:00 | DAY_AHEAD_HOURLY | TH_ZP26_GEN-APND | Trading Hub | 56.53389 | 59.88382 | -0.69108 | -2.65884 |
| 69 | 2024-10-04 23:00:00-07:00 | 2024-10-04 23:00:00-07:00 | 2024-10-05 00:00:00-07:00 | DAY_AHEAD_HOURLY | TH_NP15_GEN-APND | Trading Hub | 53.63049 | 56.26507 | -2.34200 | -0.29258 |
| 70 | 2024-10-04 23:00:00-07:00 | 2024-10-04 23:00:00-07:00 | 2024-10-05 00:00:00-07:00 | DAY_AHEAD_HOURLY | TH_SP15_GEN-APND | Trading Hub | 53.49508 | 56.26507 | -0.44624 | -2.32375 |
| 71 | 2024-10-04 23:00:00-07:00 | 2024-10-04 23:00:00-07:00 | 2024-10-05 00:00:00-07:00 | DAY_AHEAD_HOURLY | TH_ZP26_GEN-APND | Trading Hub | 53.26237 | 56.26507 | -0.67332 | -2.32937 |
72 rows × 10 columns
You can see what markets are available by accessing the markets property of an iso. For, example
caiso.markets
[<Markets.REAL_TIME_5_MIN: 'REAL_TIME_5_MIN'>,
<Markets.REAL_TIME_15_MIN: 'REAL_TIME_15_MIN'>,
<Markets.DAY_AHEAD_HOURLY: 'DAY_AHEAD_HOURLY'>]