UK Energy Trading

Dataset which will be instrumental to develop automated trading strategies.

@kaggle.kapilverma_uk_energy_trading

Table List

3 tables(1.89 MB)

Auction Data

Forecast Inputs

System Prices

Auction Data

@kaggle.kapilverma_uk_energy_trading.auction_data

481.26 KB
14880 rows
6 columns

date_wet Date (WET)	price_first_auction Price First Auction	price_second_auction Price Second Auction	traded_volume_first_auction Traded Volume First Auction	traded_volume_second_auction Traded Volume Second Auction	price_forecast_first_auction Price Forecast First Auction
nan	GBP/MWh	GBP/MWh	MW	MW	GBP/MWh
[01/01/2021 00:00]	68	65.73	2923.7	5102.4	54.19
[01/01/2021 01:00]	62.7	64.96	2825	4771.5	53.42
[01/01/2021 02:00]	56	60.47	2611.4	4176.2	50.13
[01/01/2021 03:00]	50.1	52.5	2669.3	3755.9	50.28
[01/01/2021 04:00]	50	48.98	2741.4	4047.5	47.19
[01/01/2021 05:00]	48	48.95	2791.1	4172.7	42.15
[01/01/2021 06:00]	50	48.96	2817.8	3977.3	51.04
[01/01/2021 07:00]	40	52.02	3938.3	9598.4	38.79
[01/01/2021 08:00]	45.9	51.05	3854.2	8562.6	44.03


CREATE TABLE auction_data (
  "date_wet" VARCHAR,
  "price_first_auction" VARCHAR,
  "price_second_auction" VARCHAR,
  "traded_volume_first_auction" VARCHAR,
  "traded_volume_second_auction" VARCHAR,
  "price_forecast_first_auction" VARCHAR
);