Download Hourly Time Series

 
A selection of my data is available for download here. The data has been stored in a tree structure with the following three levels:
 - Year
 - Nation
 - Region
2006
Denmark
Load MW (download)
Wind MW (download)
West Denmark
Load MW (download)
Wind MW (download)
Net export MW (download)
Spot price €/MWh (download)
East Denmark
Load MW (download)
Wind MW (download)
Net export MW (download)
Spot price €/MWh (download)
Germany
Spot price €/MWh (download)
TenneT (former E.ON Netz)
Wind MW (download)
2007
Denmark
Load MW (download)
Wind MW (download)
West Denmark
Load MW (download)
Wind MW (download)
Net export MW (download)
Spot price €/MWh (download)
East Denmark
Load MW (download)
Wind MW (download)
Net export MW (download)
Spot price €/MWh (download)
Germany
Spot price €/MWh (download)
TenneT (former E.ON Netz)
Wind MW (download)
2008
Denmark
Load MW (download)
Wind MW (download)
West Denmark
Load MW (download)
Wind MW (download)
Net export MW (download)
Spot price €/MWh (download)
East Denmark
Load MW (download)
Wind MW (download)
Net export MW (download)
Spot price €/MWh (download)
Germany
Spot price €/MWh (download)
TenneT (former E.ON Netz)
Wind MW (download)
2009
Denmark
Load MW (download)
Wind MW (download)
West Denmark
Load MW (download)
Wind MW (download)
Net export MW (download)
Spot price €/MWh (download)
East Denmark
Load MW (download)
Wind MW (download)
Net export MW (download)
Spot price €/MWh (download)
Germany
Wind MW (download)
Spot price €/MWh (download)
TenneT (former E.ON Netz)
Wind MW (download)
Amprion (former RWE)
Wind MW (download)
EnBW
Wind MW (download)
50Hertz
Wind MW (download)
Ireland
Wind MW (download)
Great Britain
System prices £/MWh (download)
2010
Denmark
Load MW (download)
Wind MW (download)
West Denmark
Load MW (download)
Wind MW (download)
Spot price €/MWh (download)
Net export MW (download)
East Denmark
Load MW (download)
Wind MW (download)
Spot price €/MWh (download)
Net export MW (download)
Germany
Wind MW (download)
Spot price €/MWh (download)
TenneT
Wind MW (download)
Amprion (former RWE)
Wind MW (download)
EnBW
Wind MW (download)
50Hertz
Wind MW (download)
Ireland
Load MW (download)
Wind MW (download)
Great Britain
Wind MW (download)
System prices £/MWh (download)
Spain
Net export MW (download)
PV MW (download)
Wind MW (download)
Load MW (download)
Exchanges MW (download)
2011
Denmark
Load MW (download)
Wind MW (download)
Net export MW (download)
Onshore wind MW (download)
Offshore wind MW (download)
West Denmark
Load MW (download)
Wind MW (download)
Spot price €/MWh (download)
Balancing prices €/MWh (download)
Net export MW (download)
East Denmark
Load MW (download)
Wind MW (download)
Spot price €/MWh (download)
Net export MW (download)
Germany
Wind MW (download)
Spot price €/MWh (download)
Load MW * (download)
TenneT
Wind MW (download)
Offshore wind MW (download)
PV MW (download)
Amprion (former RWE)
Wind MW (download)
PV MW (download)
EnBW
Wind MW (download)
PV MW (from 21 Jan) (download)
50Hertz
Wind MW (download)
Ireland
Load MW (download)
Wind MW (download)
CO2 t/h (download)
Great Britain
Wind MW (download)
Load MW (download)
Net export MW (download)
System prices £/MWh (download)
France
Wind MW (download)
Load MW (download)
Nuclear MW (download)
Net export MW (download)
Spain
Net export MW (download)
PV MW (download)
Wind MW (download)
Load MW (download)
Exchanges MW (download)
2012
Denmark
Load MW (download)
Wind MW (download)
Net export MW (download)
Onshore wind MW (download)
Offshore wind MW (download)
West Denmark
Load MW (download)
Wind MW (download)
Spot price €/MWh (download)
Balancing prices €/MWh (download)
Net export MW (download)
East Denmark
Load MW (download)
Wind MW (download)
Spot price €/MWh (download)
Balancing prices €/MWh (download)
Net export MW (download)
Germany
Wind MW (download)
PV MW (download)
Spot price €/MWh (download)
Load MW * (download)
Export MW (download)
TenneT
Wind MW (download)
Offshore wind MW (download)
PV MW (download)
Amprion (former RWE)
Wind MW (download)
PV MW (download)
TransnetBW (former EnBW)
Wind MW (download)
PV MW (download)
50Hertz
Wind MW (download)
PV MW (from 20 Jan) (download)
Ireland
Load MW (download)
Wind MW (download)
Great Britain
Wind MW (download)
Load MW (download)
Net export MW (download)
System prices £/MWh (download)
France - Updated 31.07.2013
Wind MW (download)
Load MW (download)
Nuclear MW (download)
Net export MW (download)
PV MW (download)
Spain
Net export MW (download)
PV MW (download)
Wind MW (download)
Load MW (download)
Exchanges MW (download)
Belgium
Offshore wind MW (download)
Load MW (download)
Czech Republic
Net export MW (download)
PV MW (download)
Wind MW (download)
Load MW (download)
Exchanges MW (download)
2013
Denmark
Load MW (download)
Wind MW (download)
Net export MW (download)
Onshore wind MW (download)
Offshore wind MW (download)
Exchanges MW (download)
Sweden
Wind MW (download)
Load MW (download)
Nuclear MW (download)
Hydro MW (download)
Net export MW (download)
East Denmark
Load MW (download)
Wind MW (download)
Spot price €/MWh (download)
Balancing prices €/MWh (download)
Net export MW (download)
Germany
Wind MW (download)
Spot price €/MWh (download)
PV MW (download)
Load MW * (download)
Export MW (download) Q1+Q2
TenneT
Wind MW (download)
Offshore wind MW (download)
PV MW (download)
Amprion (former RWE)
Wind MW (download)
PV MW (download)
TransnetBW (former EnBW)
Wind MW (download)
PV MW (download)
50Hertz
Wind MW (download)
PV MW (download)
Ireland
Load MW (download)
Wind MW (download)
CO2 t/h (download)
Great Britain
Wind MW (download)
Load MW (download)
Net export MW (download)
System prices £/MWh (download)
Exchanges MW (download)
France
Wind MW (download)
Load MW (download)
Nuclear MW (download)
Net export MW (download)
PV MW (download)
Exchanges MW (download)
Spain
Net export MW (download)
PV MW (download)
Wind MW (download)
Load MW (download)
Exchanges MW (download)
Belgium
Onshore wind MW (download)
Offshore wind MW (download)
Total wind MW (download)
Load MW (download)
Czech Republic
Net export MW (download)
PV MW (download)
Wind MW (download)
Load MW (download)
Exchanges MW (download)
Finland
Net export MW (download)
Spot price €/MW (download)
Wind MW (download)
Load MW (download)
Exchanges MW (download)
Italy
Wind MW (download)
Load MW (download)
PV MW (download)
Geothermal MW (download)
Sweden
Wind MW (download)
Load MW (download)
Nuclear MW (download)
Hydro MW (download)
Net export MW (download)
2014
Denmark
Load MW (download)
Wind MW (download)
Net export MW (download)
Onshore wind MW (download)
Offshore wind MW (download)
West Denmark
Spot price €/MWh (download)
East Denmark
Spot price €/MWh (download)
Germany
Wind MW (download)
Spot price €/MWh (download)
PV MW (download)
Load MW * (download)
Ireland
Load MW (download)
Wind MW (download)
CO2 t/h (download)
Great Britain
Wind MW (download)
Load MW (download)
Net export MW (download)
France
Wind MW (download)
Load MW (download)
Nuclear MW (download)
Net export MW (download)
PV MW (download)
Spain
Net export MW (download)
PV MW (download)
Wind MW (download)
Load MW (download)
Exchanges MW (download)
Nuclear MW (download)
Belgium
Onshore wind MW (download)
Offshore wind MW (download)
Total wind MW (download)
Load MW (download)
Czech Republic
Net export MW (download)
PV MW (download)
Wind MW (download)
Load MW (download)
Exchanges MW (download)
Finland
Net export MW (download)
Spot price €/MW (download)
Wind MW (download)
Load MW (download)
Exchanges MW (download)
Sweden
Wind MW (download)
Load MW (download)
Nuclear MW (download)
Hydro MW (download)
Net export MW (download)
2015
Denmark
Load MW (download)
Wind MW (download)
Net export MW (download)
Onshore wind MW (download)
Offshore wind MW (download)
Exchanges MW (download)
PV MW (download)
West Denmark
Spot price €/MWh (download)
East Denmark
Spot price €/MWh (download)
Germany
Wind MW (download)
Spot price €/MWh (download)
PV MW (download)
Load MW * (download)
Republic of Ireland
Load MW (download)
Wind MW (download)
Great Britain
Wind MW (download)
Load MW (download)
Exchanges MW (download)
Coal MW (download)
Nuclear MW (download)
CCGT MW (download)
France
Wind MW (download)
Load MW (download)
Nuclear MW (download)
PV MW (download)
Spain
PV MW (download)
Wind MW (download)
Load MW (download)
Nuclear MW (download)
Spot price €/MWh (download)
Belgium
Load MW (download)
Czech Republic
Net export MW (download)
PV MW (download)
Wind MW (download)
Load MW (download)
Exchanges MW (download)
Nuclear MW (download)
Spot price €/MWh (download)
Poland
Load MW (download)
Northern Ireland
Load MW (download)
Wind MW (download)
2016 - ENTSO-E data: Share of estimates in % *
Denmark (Source: Energinet.dk)
Load MW (download)
Wind MW (download)
Net export MW (download)
Onshore wind MW (download)
Offshore wind MW (download)
Exchanges MW (download)
PV MW (download)
West Denmark
Spot price €/MWh (download)
East Denmark
Spot price €/MWh (download)
Germany
Exchanges MW (download)
Wind MW (download) (2.0%)
Spot price €/MWh (download)
PV MW (download) (1.2%)
Load MW * (download) (0.7%)
Great Britain
Wind MW (download) (0.4%)
Load MW (download) (0.4%)
Exchanges MW (download) (0.4%)
Coal MW (download) (0.4%)
Nuclear MW (download) (0.4%)
CCGT MW (download) (0.4%)
Spot price GBP/MWh (download) (0.5%)
France
Wind MW (download) (0.4%)
Load MW (download (0.4%))
Nuclear MW (download) (0.4%)
PV MW (download) (0.4%)
Spot price €/MWh (download) (0.4%)
Exchanges MW (download)
Spain
PV MW (download) (0.1%)
Wind MW (download) (0.1%)
Load MW (download) (0.1%)
Nuclear MW (download) (0.1%)
Spot price €/MWh (download) (0.0%)
Belgium
Exchanges MW (download)
Czech Republic
Net export MW (download)
PV MW (download)
Wind MW (download)
Load MW (download)
Exchanges MW (download)
Nuclear MW (download)
Spot price €/MWh (download)
Sweden (Source: Svenska Kraftnãt)
Wind MW (download)
Load MW (download)
Nuclear MW (download)
Hydro MW (download)
Export MW (download)
The Netherlands
Offshore wind MW (download) (1.1%)
Onshore wind MW (download) (1.0%)
Total wind MW (download) (1.1%)
Load MW (download) (0.2%)
Spot price €/MWh (download) (0.7%)
Exchanges MW (download)
Norway
Wind MW (download) (0.0%)
Load MW (download) (0.2%)
Hydro MW (download) (0.0%)
Austria
Exchanges MW (download)
Switzerland
Exchanges MW (download)
Poland
Exchanges MW (download)
2017 - Exchanges - ENTSO-E data
Denmark
Exchanges MW (download)
Germany
Exchanges MW (download)
Wind MW (download)
Spot price €/MWh (download)
Great Britain
Exchanges MW (download)
France
Exchanges MW (download)
Spain
Exchanges MW (download)
Belgium
Exchanges MW (download)
Czech Republic
Exchanges MW (download)
Finland
Exchanges MW (download)
Sweden
Exchanges MW (download)
The Netherlands
Exchanges MW (download)
Austria
Exchanges MW (download)
Switzerland
Exchanges MW (download)
Poland
Exchanges MW (download)
Italy
Exchanges MW (download)
Lithuania
Exchanges MW (download)
2018 - ENTSO-E data
Denmark
Exchanges MW (download)
Germany
Exchanges MW (download)
Great Britain
Exchanges MW (download)
France
Exchanges MW (download)
Nuclear MW (download)
Onshore MW (download)
PV MW (download)
Spain
Exchanges MW (download)
Belgium
Exchanges MW (download)
Nuclear MW (download)
Onshore MW (download)
Czech Republic
Exchanges MW (download)
Finland
Exchanges MW (download)
Sweden
Exchanges MW (download)
The Netherlands
Exchanges MW (download)
Austria
Exchanges MW (download)
Switzerland
Exchanges MW (download)
Poland
Exchanges MW (download)
Italy
Exchanges MW (download)
Lithuania
Exchanges MW (download)
Norway
Exchanges MW (download)
2019 - ENTSO-E data
Denmark
Exchanges MW (download)
Production per type and load MW (download)
Germany
Exchanges MW (download)
Production per type and load MW (download)
Ireland
Production per type and load MW (download)
Great Britain
Exchanges MW (download)
Production per type and load MW (download)
France
Exchanges MW (download)
Production per type and load MW (download)
Spain
Exchanges MW (download)
Production per type and load MW (download)
Belgium
Exchanges MW (download)
Production per type and load MW (download)
Czech Republic
Exchanges MW (download)
Production per type and load MW (download)
Finland
Exchanges MW (download)
Production per type and load MW (download)
Sweden
Exchanges MW (download)
Production per type and load MW (download)
The Netherlands
Exchanges MW (download)
Production per type and load MW (download)
Austria
Exchanges MW (download)
Production per type and load MW (download)
Switzerland
Exchanges MW (download)
Poland
Exchanges MW (download)
Production per type and load MW (download)
Italy
Exchanges MW (download)
Production per type and load MW (download)
Lithuania
Exchanges MW (download)
Production per type and load MW (download)
Norway
Exchanges MW (download)
Production per type and load MW (download)
Spot prices 2019
Spot prices EU Nordic €/MWh (download)
Spot prices EU Central €/MWh (download)
Spot prices EU South €/MWh (download)
2020 - ENTSO-E data
Denmark
Exchanges MW (download)
Production per type and load MW (download)
Germany
Exchanges MW (download)
Production per type and load MW (download)
Ireland
Production per type and load MW (download)
Great Britain
Exchanges MW (download)
Production per type and load MW (download)
France
Exchanges MW (download)
Production per type and load MW (download)
Spain
Exchanges MW (download)
Production per type and load MW (download)
Belgium
Exchanges MW (download)
Production per type and load MW (download)
Czech Republic
Exchanges MW (download)
Production per type and load MW (download)
Finland
Exchanges MW (download)
Production per type and load MW (download)
Sweden
Exchanges MW (download)
Production per type and load MW (download)
The Netherlands
Exchanges MW (download)
Production per type and load MW (download)
Austria
Exchanges MW (download)
Production per type and load MW (download)
Switzerland
Exchanges MW (download)
Poland
Exchanges MW (download)
Production per type and load MW (download)
Italy
Exchanges MW (download)
Production per type and load MW (download)
Lithuania
Exchanges MW (download)
Production per type and load MW (download)
Norway
Exchanges MW (download)
Production per type and load MW (download)
Spot prices 2020
Spot prices EU Nordic €/MWh (download)
Spot prices EU Central €/MWh (download)
Spot prices EU South €/MWh (download)
2021 - ENTSO-E data
Denmark
Exchanges MW (download)
Production per type and load MW (download)
Germany
Exchanges MW (download)
Production per type and load MW (download)
Ireland
Production per type and load MW (download)
Great Britain
Exchanges MW (download)
Production per type and load MW (download)
France
Exchanges MW (download)
Production per type and load MW (download)
Spain
Exchanges MW (download)
Production per type and load MW (download)
Belgium
Exchanges MW (download)
Production per type and load MW (download)
Czech Republic
Exchanges MW (download)
Production per type and load MW (download)
Finland
Exchanges MW (download)
Production per type and load MW (download)
Sweden
Exchanges MW (download)
Production per type and load MW (download)
The Netherlands
Exchanges MW (download)
Production per type and load MW (download)
Austria
Exchanges MW (download)
Production per type and load MW (download)
Switzerland
Exchanges MW (download)
Poland
Exchanges MW (download)
Production per type and load MW (download)
Italy
Exchanges MW (download)
Production per type and load MW (download)
Lithuania
Exchanges MW (download)
Production per type and load MW (download)
Norway
Exchanges MW (download)
Production per type and load MW (download)
Spot prices 2021
Spot prices EU Nordic €/MWh (download)
Spot prices EU Central €/MWh (download)
Spot prices EU South €/MWh (download)
Spot prices Great Britain £/MWh (download)
2022 - ENTSO-E data
Denmark
Exchanges MW (download)
Production per type and load MW (download)
Germany
Exchanges MW (download)
Production per type and load MW (download)
Ireland
Production per type and load MW (download)
Great Britain
Exchanges MW (download)
Production per type and load MW (download)
France
Exchanges MW (download)
Production per type and load MW (download)
Spain
Exchanges MW (download)
Production per type and load MW (download)
Belgium
Exchanges MW (download)
Production per type and load MW (download)
Czech Republic
Exchanges MW (download)
Production per type and load MW (download)
Finland
Exchanges MW (download)
Production per type and load MW (download)
Sweden
Exchanges MW (download)
Production per type and load MW (download)
The Netherlands
Exchanges MW (download)
Production per type and load MW (download)
Austria
Exchanges MW (download)
Production per type and load MW (download)
Switzerland
Exchanges MW (download)
Poland
Exchanges MW (download)
Production per type and load MW (download)
Italy
Exchanges MW (download)
Production per type and load MW (download)
Lithuania
Exchanges MW (download)
Production per type and load MW (download)
Norway
Exchanges MW (download)
Production per type and load MW (download)
Spot prices 2022
Spot prices EU Nordic €/MWh (download)
Spot prices EU Central €/MWh (download)
Spot prices EU South €/MWh (download)
Spot prices Great Britain £/MWh (download)
The collection of data includes the following types of data:
 - Load MW: total electricity consumption
 - Wind MW: total wind power production
 - Net export MW: Net exchange, export>0
 - Spot price €/MWh: NordPool and EEX spot prices
 - Balancing prices €/MWh: Nordic Operation Information System (NOIS)
 - System prices (SSP and SBP) £/MWh: Great Britain
 - Onshore wind MW: onshore wind power production
 - Offshore wind MW: offshore wind power production
 - PV MW: solar photovoltaic production
 - Nuclear MW: nuclear power production
 - CO2 t/h: CO2 emissions

Please report any problems or errors by mail to "pfbpost" at "gmail" dot "com".
 
I would welcome information on studies and analyses using my data, and I would appreciate a reference to the data source in publications based on this collection of data.
 
Data sources:

Denmark:
http://energinet.dk/
Germany:
http://www.tennettso.de/
http://www.50hertz-transmission.net/
http://www.amprion.de/
http://transnet-bw.de/ (former EnBW)
http://www.entsoe.net/ **
Ireland (Republic of Ireland):
http://www.eirgrid.com/
Great Britain (England, Wales and Scotland):
https://www.elexonportal.co.uk/ (login required)
France:
Data extracted from the eCO2mix/RTE web site by Hubert Flocard
Spain, Red Eléctrica de España (Address includes date):
https://demanda.ree.es/movil/peninsula/demanda/tablas/2014-01-01/2
Belgium:
Data provided by Hubert Flocard
The Czech Republic::
http://www.ceps.cz/ENG/Data/Vsechna-data/Pages/Zatizeni.aspx
Finland:
http://www.fingrid.fi/en/electricity-market/Pages/default.aspx
Sweden:
http://www.svk.se/aktorsportalen/elmarknad/statistik/
For 2015 each sheet includes the source.

* ENTSO-E data are preliminary and incomplete. Estimates replace missing data. Share of replacements in %. Cells with estimated data are yellow in the datasheets."
** ENTSO-E reservation on German load data:
According to experience gained in the past before the liberalization of the electricity industry, these values cover around 91% of the total supply. That means that industry's own production for own consumption and some parts of German railways are not included in the "Common / Public supply" and the hourly load values for that part are not available.
 
Background
In 2009 I collected Danish and German time series from 2006 to 2008 for the Renewable Energy Foundation in London. The data was used for a study on wind power and spot prices. Since then data for the following years has been added to the collection and the geographic coverage has been extended to all German control areas and to other countries.
 
With a limited access to facts interested people are discussing the smoothing of wind power output by international aggregation. Hopefully the easy access to relevant time series of data will contribute to a more qualified discussion.
 
The publishers of the data in the countries concerned are using different data formats and different download procedures. It is time consuming to download, convert, check and correct time series from different countries. Common procedures and formats could be helpful.
 
Opdateret d. 16.2.2022
.