Hourly European Power Market Prices by Kaggle | Finance and Economics

About this Dataset

Hourly European Power Market Prices

Price Comparisons by System, Type and Currency

About this dataset

This dataset contains hourly European Day-Ahead Market Power Prices from various systems, types and currencies to give users an in depth look into energy markets. It helps businesses, researchers and analysts make strategic decisions by providing information on current prices as well as trends across different systems, allowing them to better anticipate the energy markets and their needs. This dataset covers everything from prices in euros or British pounds, to different types like wind power or solar energy. With origin data of the source countries included as well, users can analyze the up-to-date market information with unparalleled convenience! Pick your system, type and currency combinations for details that can help you take advantage of both expected and unexpected changes in this ever dynamic market

More Datasets

For more datasets, click here.

Featured Notebooks

🚨 Your notebook can be here! 🚨!

How to use the dataset

This dataset contains hourly European Day-Ahead Market Power Price data from various systems, types and currencies. It can be used by anyone looking to compare power market prices between regions and systems, or by energy producers or traders seeking to estimate future prices.

To use this dataset, users need to first select the column that corresponds with their desired price metric (sistema). Then they must select the type of currency (tipo_moneda) for which they want to analyze the data. Lastly, users should select the system (sistema) for which they want to get price information for their selected currency type.
Once these criteria are defined, users can then analyze trends in pricing over time by using the fecha and hora columns. Furthermore, using the origen_dato column allows users to easily identify the source of their data if needed. Additionally, info on when each price was last updated is available in fecha_actualizacion column as well as a flag indicating whether a certain price is valid or invalid as indicated by bandera column.

Utilizing this dataset in its entirety will allow investors an easy way of identifying pricing differences between markets and systems quickly while also affording them with greater insights into various power markets across Europe

Research Ideas

Comparing the regional prices of electricity and natural gas in Europe by hour, system and currency to determine where costs are highest and lowest.

Investigating the correlation between types of energy, systems, currencies and prices over time to identify market trends.

Analyzing price variations over a given period of time to inform decisions regarding investments or procurement strategies in energy markets across Europe

Acknowledgements

If you use this dataset in your research, please credit the original authors.
Data Source

License

License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: da_market_data.csv

Column name	Description
fecha	Date of the price. (Date)
hora	Hour of the price. (Time)
sistema	System of the price. (String)
bandera	Flag of the price. (String)
precio	Price of the system. (Float)
tipo_moneda	Currency type of the price. (String)
origen_dato	Data source of the price. (String)
fecha_actualizacion	Date of the last update. (Date)

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit .

Tables

Da Market Data

@kaggle.thedevastator_hourly_european_power_market_prices.da_market_data

11.11 MB
1831555 rows
9 columns


CREATE TABLE da_market_data (
  "unnamed_0" BIGINT,
  "fecha" TIMESTAMP,
  "hora" BIGINT,
  "sistema" VARCHAR,
  "bandera" BIGINT,
  "precio" DOUBLE,
  "tipo_moneda" BIGINT,
  "origen_dato" BIGINT,
  "fecha_actualizacion" TIMESTAMP
);