Data Platform
Jump to Data Package:
Time series |
|
| Package version | |
| Description | Load, wind and solar, prices in hourly resolution |
| Notes | This data package contains different kinds of timeseries data relevant for power system modelling, namely electricity consumption (load) for 36 European countries as well as wind and solar power generation and capacities and prices for a growing subset of countries. The timeseries become available at different points in time depending on the sources. The data has been downloaded from the sources, resampled and merged in a large CSV file with hourly resolution. Additionally, the data available at a higher resolution (Some renewables in-feed, 15 minutes) is provided in a separate file. All data processing is conducted in python and pandas and has been documented in the Jupyter notebooks linked below. |
| Last changes | harmonized column names for wind generation |
| Geographical scope | 35 European countries |
| Documentation | Documentation and script (view on GitHub) |
| Download |
Data package (zip) opsd-time_series-2016-10-28.zip (101 MB) Individual data files (csv, xlsx) time_series_60min_singleindex.csv (55 MB) Alternative file formats 
Filter
time_series_15min_singleindex.csv (74 MB) Alternative file formats
Filter
time_series.xlsx (80 MB) Database (SQLite) time_series.sqlite (104 MB) |
| Meta data |
README.md datapackage.json |
| Input data | View original input data |
| Sources | CEPS | PSE | Amprion | BNetzA and Netztransparenz.de | Svenska Kraftnaet | TransnetBW | 50Hertz | TenneT | ENTSO-E Data Portal | Energinet.dk | own calculation |
| Report issue | Report an issue on Github |
| Contact | Jonathan Muehlenpfordt |
| Subscribe | Get notified by email for updates |
| Attribution in Chicago author-date style should be given as follows: "Open Power System Data. 2016. Data Package Time series. Version 2016-10-28. https://data.open-power-system-data.org/time_series/2016-10-28/. (Primary data from various sources, for a complete list see URL)." | |
Field documentation
time series 60min singleindex.csv
| Field Name | Type (Format) | Description | Source |
|---|---|---|---|
| utc_timestamp | datetime (fmt:%Y-%m-%dT%H%M%SZ) | Start of timeperiod in Coordinated Universal Time | |
| cet_cest_timestamp | datetime (fmt:%Y-%m-%dT%H%M%S%z) | Start of timeperiod in Central European (Summer-) Time | |
| comment | string | marker to indicate which columns are missing data in source data and has been interpolated (e.g. solar_DE-transnetbw_generation;) | |
| load_AT_load | number (float) | Consumption in Austria in MW | ENTSO-E Data Portal |
| load_BA_load | number (float) | Consumption in Bosnia and Herzegovina in MW | ENTSO-E Data Portal |
| load_BE_load | number (float) | Consumption in Belgium in MW | ENTSO-E Data Portal |
| load_BG_load | number (float) | Consumption in Bulgaria in MW | ENTSO-E Data Portal |
| load_CH_load | number (float) | Consumption in Switzerland in MW | ENTSO-E Data Portal |
| load_CS_load | number (float) | Consumption in Serbia and Montenegro in MW | ENTSO-E Data Portal |
| load_CY_load | number (float) | Consumption in Cyprus in MW | ENTSO-E Data Portal |
| load_CZ_load | number (float) | Consumption in Czech Republic in MW | ENTSO-E Data Portal |
| load_DE_load | number (float) | Consumption in Germany in MW | ENTSO-E Data Portal |
| load_DK_load | number (float) | Consumption in Denmark in MW | ENTSO-E Data Portal |
| load_DK-west_load | number (float) | Consumption in DK-west balancing area in MW | ENTSO-E Data Portal |
| load_EE_load | number (float) | Consumption in Estonia in MW | ENTSO-E Data Portal |
| load_ES_load | number (float) | Consumption in Spain in MW | ENTSO-E Data Portal |
| load_FI_load | number (float) | Consumption in Finland in MW | ENTSO-E Data Portal |
| load_FR_load | number (float) | Consumption in France in MW | ENTSO-E Data Portal |
| load_GB_load | number (float) | Consumption in United Kingdom in MW | ENTSO-E Data Portal |
| load_GR_load | number (float) | Consumption in Greece in MW | ENTSO-E Data Portal |
| load_HR_load | number (float) | Consumption in Croatia in MW | ENTSO-E Data Portal |
| load_HU_load | number (float) | Consumption in Hungary in MW | ENTSO-E Data Portal |
| load_IE_load | number (float) | Consumption in Ireland in MW | ENTSO-E Data Portal |
| load_IS_load | number (float) | Consumption in Iceland in MW | ENTSO-E Data Portal |
| load_IT_load | number (float) | Consumption in Italy in MW | ENTSO-E Data Portal |
| load_LT_load | number (float) | Consumption in Lithuania in MW | ENTSO-E Data Portal |
| load_LU_load | number (float) | Consumption in Luxembourg in MW | ENTSO-E Data Portal |
| load_LV_load | number (float) | Consumption in Latvia in MW | ENTSO-E Data Portal |
| load_ME_load | number (float) | Consumption in Montenegro in MW | ENTSO-E Data Portal |
| load_MK_load | number (float) | Consumption in Macedonia, Republic of in MW | ENTSO-E Data Portal |
| load_NI_load | number (float) | Consumption in Northern Ireland in MW | ENTSO-E Data Portal |
| load_NL_load | number (float) | Consumption in Netherlands in MW | ENTSO-E Data Portal |
| load_NO_load | number (float) | Consumption in Norway in MW | ENTSO-E Data Portal |
| load_PL_load | number (float) | Consumption in Poland in MW | ENTSO-E Data Portal |
| load_PT_load | number (float) | Consumption in Portugal in MW | ENTSO-E Data Portal |
| load_RO_load | number (float) | Consumption in Romania in MW | ENTSO-E Data Portal |
| load_RS_load | number (float) | Consumption in Serbia in MW | ENTSO-E Data Portal |
| load_SE_load | number (float) | Consumption in Sweden in MW | ENTSO-E Data Portal |
| load_SI_load | number (float) | Consumption in Slovenia in MW | ENTSO-E Data Portal |
| load_SK_load | number (float) | Consumption in Slovakia in MW | ENTSO-E Data Portal |
| load_UA-west_load | number (float) | Consumption in UA-west balancing area in MW | ENTSO-E Data Portal |
| price_DE_epex | number (float) | Day-ahead spot price for Germany | Energinet.dk |
| price_DK-east_elspot | number (float) | Day-ahead spot price for DK-east balancing area | Energinet.dk |
| price_DK-west_elspot | number (float) | Day-ahead spot price for DK-west balancing area | Energinet.dk |
| price_NO_elspot | number (float) | Day-ahead spot price for Norway | Energinet.dk |
| price_SE_elspot | number (float) | Day-ahead spot price for Sweden | Energinet.dk |
| price_SE-3_elspot | number (float) | Day-ahead spot price for SE-3 balancing area | Energinet.dk |
| price_SE-4_elspot | number (float) | Day-ahead spot price for SE-4 balancing area | Energinet.dk |
| solar_CZ_generation | number (float) | Actual solar generation in Czech Republic in MW | CEPS |
| solar_DE_capacity | number (float) | Electrical capacity of solar in Germany in MW | BNetzA and Netztransparenz.de |
| solar_DE_generation | number (float) | Actual solar generation in Germany in MW | own calculation |
| solar_DE_profile | number (float) | Share of solar capacity producing in Germany | own calculation |
| solar_DE-50hertz_forecast | number (float) | Forecasted solar generation forecast in DE-50hertz balancing area in MW | 50Hertz |
| solar_DE-50hertz_generation | number (float) | Actual solar generation in DE-50hertz balancing area in MW | 50Hertz |
| solar_DE-amprion_forecast | number (float) | Forecasted solar generation forecast in DE-amprion balancing area in MW | Amprion |
| solar_DE-amprion_generation | number (float) | Actual solar generation in DE-amprion balancing area in MW | Amprion |
| solar_DE-tennet_forecast | number (float) | Forecasted solar generation forecast in DE-tennet balancing area in MW | TenneT |
| solar_DE-tennet_generation | number (float) | Actual solar generation in DE-tennet balancing area in MW | TenneT |
| solar_DE-transnetbw_forecast | number (float) | Forecasted solar generation forecast in DE-transnetbw balancing area in MW | TransnetBW |
| solar_DE-transnetbw_generation | number (float) | Actual solar generation in DE-transnetbw balancing area in MW | TransnetBW |
| solar_DK-east_generation | number (float) | Actual solar generation in DK-east balancing area in MW | Energinet.dk |
| solar_DK-west_generation | number (float) | Actual solar generation in DK-west balancing area in MW | Energinet.dk |
| solar_SE_generation | number (float) | Actual solar generation in Sweden in MW | Svenska Kraftnaet |
| wind_DE-50hertz_forecast | number (float) | Forecasted wind generation forecast in DE-50hertz balancing area in MW | 50Hertz |
| wind_DE-50hertz_generation | number (float) | Actual wind generation in DE-50hertz balancing area in MW | 50Hertz |
| wind_DE-amprion_forecast | number (float) | Forecasted wind generation forecast in DE-amprion balancing area in MW | Amprion |
| wind_DE-amprion_generation | number (float) | Actual wind generation in DE-amprion balancing area in MW | Amprion |
| wind_DE-tennet_forecast | number (float) | Forecasted wind generation forecast in DE-tennet balancing area in MW | TenneT |
| wind_DE-tennet_generation | number (float) | Actual wind generation in DE-tennet balancing area in MW | TenneT |
| wind_DE-transnetbw_forecast | number (float) | Forecasted wind generation forecast in DE-transnetbw balancing area in MW | TransnetBW |
| wind_DE-transnetbw_generation | number (float) | Actual wind generation in DE-transnetbw balancing area in MW | TransnetBW |
| wind_DK-east_generation | number (float) | Actual wind generation in DK-east balancing area in MW | Energinet.dk |
| wind_DK-west_generation | number (float) | Actual wind generation in DK-west balancing area in MW | Energinet.dk |
| wind_PL_generation | number (float) | Actual wind generation in Poland in MW | PSE |
| wind_SE_generation | number (float) | Actual wind generation in Sweden in MW | Svenska Kraftnaet |
| wind-offshore_DE_capacity | number (float) | Electrical capacity of wind-offshore in Germany in MW | BNetzA and Netztransparenz.de |
| wind-offshore_DE_generation | number (float) | Actual wind-offshore generation in Germany in MW | own calculation |
| wind-offshore_DE_profile | number (float) | Share of wind-offshore capacity producing in Germany | own calculation |
| wind-offshore_DE-50hertz_forecast | number (float) | Forecasted wind-offshore generation forecast in DE-50hertz balancing area in MW | 50Hertz |
| wind-offshore_DE-50hertz_generation | number (float) | Actual wind-offshore generation in DE-50hertz balancing area in MW | 50Hertz |
| wind-offshore_DE-tennet_generation | number (float) | Actual wind-offshore generation in DE-tennet balancing area in MW | TenneT |
| wind-offshore_DK_generation | number (float) | Actual wind-offshore generation in Denmark in MW | Energinet.dk |
| wind-onshore_CZ_generation | number (float) | Actual wind-onshore generation in Czech Republic in MW | CEPS |
| wind-onshore_DE_capacity | number (float) | Electrical capacity of wind-onshore in Germany in MW | BNetzA and Netztransparenz.de |
| wind-onshore_DE_generation | number (float) | Actual wind-onshore generation in Germany in MW | own calculation |
| wind-onshore_DE_profile | number (float) | Share of wind-onshore capacity producing in Germany | own calculation |
| wind-onshore_DE-50hertz_forecast | number (float) | Forecasted wind-onshore generation forecast in DE-50hertz balancing area in MW | 50Hertz |
| wind-onshore_DE-50hertz_generation | number (float) | Actual wind-onshore generation in DE-50hertz balancing area in MW | 50Hertz |
| wind-onshore_DE-amprion_generation | number (float) | Actual wind-onshore generation in DE-amprion balancing area in MW | own calculation |
| wind-onshore_DE-tennet_generation | number (float) | Actual wind-onshore generation in DE-tennet balancing area in MW | own calculation |
| wind-onshore_DE-transnetbw_generation | number (float) | Actual wind-onshore generation in DE-transnetbw balancing area in MW | own calculation |
| wind-onshore_DK_generation | number (float) | Actual wind-onshore generation in Denmark in MW | Energinet.dk |
time series 15min singleindex.csv
| Field Name | Type (Format) | Description | Source |
|---|---|---|---|
| utc_timestamp | datetime (fmt:%Y-%m-%dT%H%M%SZ) | Start of timeperiod in Coordinated Universal Time | |
| cet_cest_timestamp | datetime (fmt:%Y-%m-%dT%H%M%S%z) | Start of timeperiod in Central European (Summer-) Time | |
| comment | string | marker to indicate which columns are missing data in source data and has been interpolated (e.g. solar_DE-transnetbw_generation;) | |
| solar_CZ_generation | number (float) | Actual solar generation in Czech Republic in MW | CEPS |
| solar_DE_capacity | number (float) | Electrical capacity of solar in Germany in MW | BNetzA and Netztransparenz.de |
| solar_DE_generation | number (float) | Actual solar generation in Germany in MW | own calculation |
| solar_DE_profile | number (float) | Share of solar capacity producing in Germany | own calculation |
| solar_DE-50hertz_forecast | number (float) | Forecasted solar generation forecast in DE-50hertz balancing area in MW | 50Hertz |
| solar_DE-50hertz_generation | number (float) | Actual solar generation in DE-50hertz balancing area in MW | 50Hertz |
| solar_DE-amprion_forecast | number (float) | Forecasted solar generation forecast in DE-amprion balancing area in MW | Amprion |
| solar_DE-amprion_generation | number (float) | Actual solar generation in DE-amprion balancing area in MW | Amprion |
| solar_DE-tennet_forecast | number (float) | Forecasted solar generation forecast in DE-tennet balancing area in MW | TenneT |
| solar_DE-tennet_generation | number (float) | Actual solar generation in DE-tennet balancing area in MW | TenneT |
| solar_DE-transnetbw_forecast | number (float) | Forecasted solar generation forecast in DE-transnetbw balancing area in MW | TransnetBW |
| solar_DE-transnetbw_generation | number (float) | Actual solar generation in DE-transnetbw balancing area in MW | TransnetBW |
| wind_DE-50hertz_forecast | number (float) | Forecasted wind generation forecast in DE-50hertz balancing area in MW | 50Hertz |
| wind_DE-50hertz_generation | number (float) | Actual wind generation in DE-50hertz balancing area in MW | 50Hertz |
| wind_DE-amprion_forecast | number (float) | Forecasted wind generation forecast in DE-amprion balancing area in MW | Amprion |
| wind_DE-amprion_generation | number (float) | Actual wind generation in DE-amprion balancing area in MW | Amprion |
| wind_DE-tennet_forecast | number (float) | Forecasted wind generation forecast in DE-tennet balancing area in MW | TenneT |
| wind_DE-tennet_generation | number (float) | Actual wind generation in DE-tennet balancing area in MW | TenneT |
| wind_DE-transnetbw_forecast | number (float) | Forecasted wind generation forecast in DE-transnetbw balancing area in MW | TransnetBW |
| wind_DE-transnetbw_generation | number (float) | Actual wind generation in DE-transnetbw balancing area in MW | TransnetBW |
| wind-offshore_DE_capacity | number (float) | Electrical capacity of wind-offshore in Germany in MW | BNetzA and Netztransparenz.de |
| wind-offshore_DE_generation | number (float) | Actual wind-offshore generation in Germany in MW | own calculation |
| wind-offshore_DE_profile | number (float) | Share of wind-offshore capacity producing in Germany | own calculation |
| wind-offshore_DE-50hertz_forecast | number (float) | Forecasted wind-offshore generation forecast in DE-50hertz balancing area in MW | 50Hertz |
| wind-offshore_DE-50hertz_generation | number (float) | Actual wind-offshore generation in DE-50hertz balancing area in MW | 50Hertz |
| wind-offshore_DE-tennet_generation | number (float) | Actual wind-offshore generation in DE-tennet balancing area in MW | TenneT |
| wind-onshore_CZ_generation | number (float) | Actual wind-onshore generation in Czech Republic in MW | CEPS |
| wind-onshore_DE_capacity | number (float) | Electrical capacity of wind-onshore in Germany in MW | BNetzA and Netztransparenz.de |
| wind-onshore_DE_generation | number (float) | Actual wind-onshore generation in Germany in MW | own calculation |
| wind-onshore_DE_profile | number (float) | Share of wind-onshore capacity producing in Germany | own calculation |
| wind-onshore_DE-50hertz_forecast | number (float) | Forecasted wind-onshore generation forecast in DE-50hertz balancing area in MW | 50Hertz |
| wind-onshore_DE-50hertz_generation | number (float) | Actual wind-onshore generation in DE-50hertz balancing area in MW | 50Hertz |
| wind-onshore_DE-amprion_generation | number (float) | Actual wind-onshore generation in DE-amprion balancing area in MW | own calculation |
| wind-onshore_DE-tennet_generation | number (float) | Actual wind-onshore generation in DE-tennet balancing area in MW | own calculation |
| wind-onshore_DE-transnetbw_generation | number (float) | Actual wind-onshore generation in DE-transnetbw balancing area in MW | own calculation |