Difference between revisions of "Energy data"

From embargo
Jump to navigation Jump to search
Line 106: Line 106:
 
</code>
 
</code>
  
Python scripts: git clone https://git.embargo.energy/entsog.git
+
Python scripts: <code>git clone https://git.embargo.energy/entsog.git</code>
  
 
== EU: Energy prices ==
 
== EU: Energy prices ==
  
 
* {{Citation | vauthors=((European Commission)) | title=EU: Energy price dashboard - historical data | url=https://energy.ec.europa.eu/data-and-analysis/energy-prices-and-costs-europe/dashboard-energy-prices-eu-and-main-trading-partners_en | access-date=23 July 2022}}
 
* {{Citation | vauthors=((European Commission)) | title=EU: Energy price dashboard - historical data | url=https://energy.ec.europa.eu/data-and-analysis/energy-prices-and-costs-europe/dashboard-energy-prices-eu-and-main-trading-partners_en | access-date=23 July 2022}}

Revision as of 19:37, 7 August 2022

Here we list energy open data:

Germany

Trading Hub Europe

THE, Germany: Daily gas consumption

Bundesnetzagentur

BNetzA, Germany: Daily briefings about gas imports, storage, and consumption

Realized gas savings in 2022
Month 2021 2022 Diff. Diff.
TWh TWh TWh %
Jan 142.3 129 -13.3 -9.3 %
Feb 121.2 106 -15.2 -12.5 %
Mar 109.7 92.5 -17.2 -15.7%
Apr 95.9 82.0 -13.9 -14.5%
May 68.2 51.0 -17.2 -25.2%
Jun 46.1 33.6 -12.5 -27.1%
Jul 40.4
Aug 38.8
Sep 45.3
Oct 73.2
Nov 109.7
Dec 125.6
TOTAL 1016.4 -89.3

BDEW

BDEW: Monthly gas consumption in Germany 2022 vs. 2021

Eurostat

EU

Gas storage inventory

Data not in AGSI summary:

Bruegel

ENTSOG gas data

ENTSOG example query to get physical flows on 01 March 2022:

Some analyses (experimental, feedback welcome):

ENTSOG data as relational database

(Experimental, physical flow data from 01 Jan 2021 to 05 Aug 2022, where flow value is not null)

Postgres access: psql -h embargo.energy -U embargo entsog ; password: 9mTc_9hPjk}&D27/F,VHC8qG

Some tentative examples:

Give out consumption (apparently underestimation)

select left(operatorkey,2), date_trunc('month', periodto), round(sum(value)) from flows where pointkey in (select pointKey from operator where pointtype = 'Aggregated Point - Final Consumers') and flowstatus = 'Confirmed' group by left(operatorkey,2), date_trunc('month', periodto) order by left(operatorkey,2), date_trunc('month', periodto);

Sort by distribution points select pointlabel, operatorlabel, sum(value) from flows where pointkey in (select pointKey from operator where pointtype = 'Aggregated Point - Final Consumers') and periodto > '2022-07-01' and periodto <= '2022-08-01' and left(operatorkey,2) = 'DE' group by operatorlabel, pointlabel order by operatorlabel ;

Python scripts: git clone https://git.embargo.energy/entsog.git

EU: Energy prices