SQL Storage Serer
The collected data is stored at link_to_server?? on a PostgreSQL database. To code examples for accessing this data are provided here. This page provides a description of the data that is available on the database, and the table organization.
By default, all times are in UTC time and electricty values are in MW.
LMP
The realtime_lmp table contains realtime 5-minute Location Marginal Pricing data. The table schema is as follows:
| LocationID | Region | DateTime | LMP | MCC | MLC |
|---|---|---|---|---|---|
WI.HUB |
MISO |
2020-12-29 23:00:00-06 |
14.32 |
0.00 |
-4.88 |
Production
The production table contains realtime electricity production data. The following gentypes are possible: coal, gas, hydro, nuclear, oil, wind, solar, geothermal, biomass, unknown. The table schema is as follows:
| Region | DateTime | GenType | MW |
|---|---|---|---|
MISO |
2020-12-29 23:00:00-06 |
Coal |
23394.7 |
Load
The load table contains realtime electricity usage data. The table schema is as follows:
| Region | DateTime | MW |
|---|---|---|
MISO |
2020-12-29 23:00:00-06 |
23394.7 |
Renewable Forecast
The renewable_forecast table contains forecast information for renewable energy. ISOs create different variations for forecast, such as a general renewable forecast or a wind forecast. Currently, the following values may exist in GenTypes : wind, solar, renewable.
The table schema is as follows:
| Region | Evaluated | DateTimeBeginning | DateTimeEnding | GenType | MW |
|---|---|---|---|---|---|
MISO |
2020-11-29 15:3:45-06 |
2020-12-29 00:00:00-06 |
2020-12-29 01:00:00-06 |
wind |
8.42 |
PJM |
2020-12-29 12:00:00-06 |
2020-12-29 18:00:00-06 |
2020-12-29 19:00:00-06 |
renewable |
6.34 |
Load Forecast
The load_forecast table contains medium term load forecast data. The table schema is as follows:
| Region | Evaluated | DateTimeBeginning | DateTimeEnding | MW |
|---|---|---|---|---|
MISO |
2020-11-29 15:3:45-06 |
2020-12-29 22:00:00-06 |
2020-12-29 23:00:00-06 |
36.41 |