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 update datasets up to 2016-12-31 and reformat output files
Countries 35 European countries
Documentation Documentation and script (view on GitHub)
Download Data package (zip)
opsd-time_series-2017-03-06.zip (114 MB)

Individual data files (csv, xlsx)
time_series.xlsx (90 MB)
time_series_60min_singleindex.csv (57 MB) Alternative file formats Filter
time_series_15min_singleindex.csv (84 MB) Alternative file formats Filter

Database (SQLite)
time_series.sqlite (112 MB)
Meta data README.md
datapackage.json
Input data View original input data
Sources CEPS | Svenska Kraftnaet | own calculation | BNetzA and Netztransparenz.de | TenneT | PSE | Energinet.dk | TransnetBW | Amprion | ENTSO-E Data Portal | 50Hertz
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. 2017. Data Package Time series. Version 2017-03-06. https://data.open-power-system-data.org/time_series/2017-03-06/. (Primary data from various sources, for a complete list see URL)."
<- back to overview

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
interpolated_values string marker to indicate which columns are missing data in source data and has been interpolated (e.g. DE_transnetbw_solar_generation;)
AT_load_ number (float) Consumption in Austria in MW ENTSO-E Data Portal
BA_load_ number (float) Consumption in Bosnia and Herzegovina in MW ENTSO-E Data Portal
BE_load_ number (float) Consumption in Belgium in MW ENTSO-E Data Portal
BG_load_ number (float) Consumption in Bulgaria in MW ENTSO-E Data Portal
CH_load_ number (float) Consumption in Switzerland in MW ENTSO-E Data Portal
CS_load_ number (float) Consumption in Serbia and Montenegro in MW ENTSO-E Data Portal
CY_load_ number (float) Consumption in Cyprus in MW ENTSO-E Data Portal
CZ_load_ number (float) Consumption in Czechia in MW ENTSO-E Data Portal
CZ_solar_generation number (float) Actual solar generation in Czechia in MW CEPS
CZ_wind_generation number (float) Actual wind generation in Czechia in MW CEPS
DE_load_ number (float) Consumption in Germany in MW ENTSO-E Data Portal
DE_price_day_ahead number (float) Day-ahead spot price for Germany Energinet.dk
DE_solar_capacity number (float) Electrical capacity of solar in Germany in MW BNetzA and Netztransparenz.de
DE_solar_generation number (float) Actual solar generation in Germany in MW own calculation
DE_solar_profile number (float) Share of solar capacity producing in Germany own calculation
DE_wind_capacity number (float) Electrical capacity of wind in Germany in MW BNetzA and Netztransparenz.de
DE_wind_generation number (float) Actual wind generation in Germany in MW own calculation
DE_wind_profile number (float) Share of wind capacity producing in Germany own calculation
DE_wind_offshore_capacity number (float) Electrical capacity of wind_offshore in Germany in MW BNetzA and Netztransparenz.de
DE_wind_offshore_generation number (float) Actual wind_offshore generation in Germany in MW own calculation
DE_wind_offshore_profile number (float) Share of wind_offshore capacity producing in Germany own calculation
DE_wind_onshore_capacity number (float) Electrical capacity of wind_onshore in Germany in MW BNetzA and Netztransparenz.de
DE_wind_onshore_generation number (float) Actual wind_onshore generation in Germany in MW own calculation
DE_wind_onshore_profile number (float) Share of wind_onshore capacity producing in Germany own calculation
DE_50hertz_solar_forecast number (float) Forecasted solar generation in DE_50hertz balancing area in MW 50Hertz
DE_50hertz_solar_generation number (float) Actual solar generation in DE_50hertz balancing area in MW 50Hertz
DE_50hertz_wind_forecast number (float) Forecasted wind generation in DE_50hertz balancing area in MW 50Hertz
DE_50hertz_wind_generation number (float) Actual wind generation in DE_50hertz balancing area in MW 50Hertz
DE_50hertz_wind_offshore_forecast number (float) Forecasted wind_offshore generation in DE_50hertz balancing area in MW 50Hertz
DE_50hertz_wind_offshore_generation number (float) Actual wind_offshore generation in DE_50hertz balancing area in MW 50Hertz
DE_50hertz_wind_onshore_forecast number (float) Forecasted wind_onshore generation in DE_50hertz balancing area in MW 50Hertz
DE_50hertz_wind_onshore_generation number (float) Actual wind_onshore generation in DE_50hertz balancing area in MW 50Hertz
DE_amprion_solar_forecast number (float) Forecasted solar generation in DE_amprion balancing area in MW Amprion
DE_amprion_solar_generation number (float) Actual solar generation in DE_amprion balancing area in MW Amprion
DE_amprion_wind_forecast number (float) Forecasted wind generation in DE_amprion balancing area in MW Amprion
DE_amprion_wind_generation number (float) Actual wind generation in DE_amprion balancing area in MW Amprion
DE_amprion_wind_onshore_generation number (float) Actual wind_onshore generation in DE_amprion balancing area in MW own calculation
DE_tennet_solar_forecast number (float) Forecasted solar generation in DE_tennet balancing area in MW TenneT
DE_tennet_solar_generation number (float) Actual solar generation in DE_tennet balancing area in MW TenneT
DE_tennet_wind_forecast number (float) Forecasted wind generation in DE_tennet balancing area in MW TenneT
DE_tennet_wind_generation number (float) Actual wind generation in DE_tennet balancing area in MW TenneT
DE_tennet_wind_offshore_generation number (float) Actual wind_offshore generation in DE_tennet balancing area in MW TenneT
DE_tennet_wind_onshore_generation number (float) Actual wind_onshore generation in DE_tennet balancing area in MW own calculation
DE_transnetbw_solar_forecast number (float) Forecasted solar generation in DE_transnetbw balancing area in MW TransnetBW
DE_transnetbw_solar_generation number (float) Actual solar generation in DE_transnetbw balancing area in MW TransnetBW
DE_transnetbw_wind_forecast number (float) Forecasted wind generation in DE_transnetbw balancing area in MW TransnetBW
DE_transnetbw_wind_generation number (float) Actual wind generation in DE_transnetbw balancing area in MW TransnetBW
DE_transnetbw_wind_onshore_generation number (float) Actual wind_onshore generation in DE_transnetbw balancing area in MW own calculation
DK_load_ number (float) Consumption in Denmark in MW ENTSO-E Data Portal
DK_wind_offshore_generation number (float) Actual wind_offshore generation in Denmark in MW Energinet.dk
DK_wind_onshore_generation number (float) Actual wind_onshore generation in Denmark in MW Energinet.dk
DK_east_price_day_ahead number (float) Day-ahead spot price for DK_east balancing area Energinet.dk
DK_east_solar_generation number (float) Actual solar generation in DK_east balancing area in MW Energinet.dk
DK_east_wind_generation number (float) Actual wind generation in DK_east balancing area in MW Energinet.dk
DK_west_load_ number (float) Consumption in DK_west balancing area in MW ENTSO-E Data Portal
DK_west_price_day_ahead number (float) Day-ahead spot price for DK_west balancing area Energinet.dk
DK_west_solar_generation number (float) Actual solar generation in DK_west balancing area in MW Energinet.dk
DK_west_wind_generation number (float) Actual wind generation in DK_west balancing area in MW Energinet.dk
EE_load_ number (float) Consumption in Estonia in MW ENTSO-E Data Portal
ES_load_ number (float) Consumption in Spain in MW ENTSO-E Data Portal
FI_load_ number (float) Consumption in Finland in MW ENTSO-E Data Portal
FR_load_ number (float) Consumption in France in MW ENTSO-E Data Portal
GB_load_ number (float) Consumption in United Kingdom in MW ENTSO-E Data Portal
GR_load_ number (float) Consumption in Greece in MW ENTSO-E Data Portal
HR_load_ number (float) Consumption in Croatia in MW ENTSO-E Data Portal
HU_load_ number (float) Consumption in Hungary in MW ENTSO-E Data Portal
IE_load_ number (float) Consumption in Ireland in MW ENTSO-E Data Portal
IS_load_ number (float) Consumption in Iceland in MW ENTSO-E Data Portal
IT_load_ number (float) Consumption in Italy in MW ENTSO-E Data Portal
LT_load_ number (float) Consumption in Lithuania in MW ENTSO-E Data Portal
LU_load_ number (float) Consumption in Luxembourg in MW ENTSO-E Data Portal
LV_load_ number (float) Consumption in Latvia in MW ENTSO-E Data Portal
ME_load_ number (float) Consumption in Montenegro in MW ENTSO-E Data Portal
MK_load_ number (float) Consumption in Macedonia, Republic of in MW ENTSO-E Data Portal
NI_load_ number (float) Consumption in Northern Ireland in MW ENTSO-E Data Portal
NL_load_ number (float) Consumption in Netherlands in MW ENTSO-E Data Portal
NO_load_ number (float) Consumption in Norway in MW ENTSO-E Data Portal
NO_price_day_ahead number (float) Day-ahead spot price for Norway Energinet.dk
PL_load_ number (float) Consumption in Poland in MW ENTSO-E Data Portal
PL_wind_generation number (float) Actual wind generation in Poland in MW PSE
PT_load_ number (float) Consumption in Portugal in MW ENTSO-E Data Portal
RO_load_ number (float) Consumption in Romania in MW ENTSO-E Data Portal
RS_load_ number (float) Consumption in Serbia in MW ENTSO-E Data Portal
SE_load_ number (float) Consumption in Sweden in MW ENTSO-E Data Portal
SE_price_day_ahead number (float) Day-ahead spot price for Sweden Energinet.dk
SE_solar_generation number (float) Actual solar generation in Sweden in MW Svenska Kraftnaet
SE_wind_generation number (float) Actual wind generation in Sweden in MW Svenska Kraftnaet
SE_3_price_day_ahead number (float) Day-ahead spot price for SE_3 balancing area Energinet.dk
SE_4_price_day_ahead number (float) Day-ahead spot price for SE_4 balancing area Energinet.dk
SI_load_ number (float) Consumption in Slovenia in MW ENTSO-E Data Portal
SK_load_ number (float) Consumption in Slovakia in MW ENTSO-E Data Portal
UA_west_load_ number (float) Consumption in UA_west balancing area in MW ENTSO-E Data Portal

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
interpolated_values string marker to indicate which columns are missing data in source data and has been interpolated (e.g. DE_transnetbw_solar_generation;)
CZ_solar_generation number (float) Actual solar generation in Czechia in MW CEPS
CZ_wind_generation number (float) Actual wind generation in Czechia in MW CEPS
DE_solar_capacity number (float) Electrical capacity of solar in Germany in MW BNetzA and Netztransparenz.de
DE_solar_generation number (float) Actual solar generation in Germany in MW own calculation
DE_solar_profile number (float) Share of solar capacity producing in Germany own calculation
DE_wind_capacity number (float) Electrical capacity of wind in Germany in MW BNetzA and Netztransparenz.de
DE_wind_generation number (float) Actual wind generation in Germany in MW own calculation
DE_wind_profile number (float) Share of wind capacity producing in Germany own calculation
DE_wind_offshore_capacity number (float) Electrical capacity of wind_offshore in Germany in MW BNetzA and Netztransparenz.de
DE_wind_offshore_generation number (float) Actual wind_offshore generation in Germany in MW own calculation
DE_wind_offshore_profile number (float) Share of wind_offshore capacity producing in Germany own calculation
DE_wind_onshore_capacity number (float) Electrical capacity of wind_onshore in Germany in MW BNetzA and Netztransparenz.de
DE_wind_onshore_generation number (float) Actual wind_onshore generation in Germany in MW own calculation
DE_wind_onshore_profile number (float) Share of wind_onshore capacity producing in Germany own calculation
DE_50hertz_solar_forecast number (float) Forecasted solar generation in DE_50hertz balancing area in MW 50Hertz
DE_50hertz_solar_generation number (float) Actual solar generation in DE_50hertz balancing area in MW 50Hertz
DE_50hertz_wind_forecast number (float) Forecasted wind generation in DE_50hertz balancing area in MW 50Hertz
DE_50hertz_wind_generation number (float) Actual wind generation in DE_50hertz balancing area in MW 50Hertz
DE_50hertz_wind_offshore_forecast number (float) Forecasted wind_offshore generation in DE_50hertz balancing area in MW 50Hertz
DE_50hertz_wind_offshore_generation number (float) Actual wind_offshore generation in DE_50hertz balancing area in MW 50Hertz
DE_50hertz_wind_onshore_forecast number (float) Forecasted wind_onshore generation in DE_50hertz balancing area in MW 50Hertz
DE_50hertz_wind_onshore_generation number (float) Actual wind_onshore generation in DE_50hertz balancing area in MW 50Hertz
DE_amprion_solar_forecast number (float) Forecasted solar generation in DE_amprion balancing area in MW Amprion
DE_amprion_solar_generation number (float) Actual solar generation in DE_amprion balancing area in MW Amprion
DE_amprion_wind_forecast number (float) Forecasted wind generation in DE_amprion balancing area in MW Amprion
DE_amprion_wind_generation number (float) Actual wind generation in DE_amprion balancing area in MW Amprion
DE_amprion_wind_onshore_generation number (float) Actual wind_onshore generation in DE_amprion balancing area in MW own calculation
DE_tennet_solar_forecast number (float) Forecasted solar generation in DE_tennet balancing area in MW TenneT
DE_tennet_solar_generation number (float) Actual solar generation in DE_tennet balancing area in MW TenneT
DE_tennet_wind_forecast number (float) Forecasted wind generation in DE_tennet balancing area in MW TenneT
DE_tennet_wind_generation number (float) Actual wind generation in DE_tennet balancing area in MW TenneT
DE_tennet_wind_offshore_generation number (float) Actual wind_offshore generation in DE_tennet balancing area in MW TenneT
DE_tennet_wind_onshore_generation number (float) Actual wind_onshore generation in DE_tennet balancing area in MW own calculation
DE_transnetbw_solar_forecast number (float) Forecasted solar generation in DE_transnetbw balancing area in MW TransnetBW
DE_transnetbw_solar_generation number (float) Actual solar generation in DE_transnetbw balancing area in MW TransnetBW
DE_transnetbw_wind_forecast number (float) Forecasted wind generation in DE_transnetbw balancing area in MW TransnetBW
DE_transnetbw_wind_generation number (float) Actual wind generation in DE_transnetbw balancing area in MW TransnetBW
DE_transnetbw_wind_onshore_generation number (float) Actual wind_onshore generation in DE_transnetbw balancing area in MW own calculation
<- back to overview