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

Forecast Inputs

@kaggle.kapilverma_uk_energy_trading.forecast_inputs

1.12 MB
14880 rows
19 columns

date_wet Date (WET)	demand_plus_system_margin Demand Plus System Margin	demand Demand	within_day_availability Within Day Availability	margin Margin	within_day_margin Within Day Margin	long_term_wind Long Term Wind	long_term_solar Long Term Solar	long_term_wind_over_demand Long Term Wind Over Demand	long_term_wind_over_margin Long Term Wind Over Margin	long_term_solar_over_demand Long Term Solar Over Demand	long_term_solar_over_margin Long Term Solar Over Margin	margin_over_demand Margin Over Demand	snsp_forecast Snsp Forecast	stack_price Stack Price	within_day_potential_stack_price Within Day Potential Stack Price	previous_day_ahead_price Previous Day Ahead Price	previous_continuous_half_hour_vwap Previous Continuous Half Hour Vwap	inertia_forecast Inertia Forecast
nan	MW	MW	MW	MW	MW	GBP/MWh	MW	%	%	%	%	%	%	GBP/MWh	GBP/MWh	GBP/MWh	GBP/MWh	GVA.s
[01/01/2021 00:00]	56513.64	30182	40389.06	-26331.64	-15268.7	-3674.64	0	-12	-14	0	0	-87	29.95	67.79	68.88	65.02	59.69	214.67
[01/01/2021 01:00]	56506.94	29269	40389.06	-27237.94	-16191	-3667.94	0	-13	-14	0	0	-93	31.05	67.79	68.45	62	51.86	205.47
[01/01/2021 02:00]	56502.2	27245	40389.06	-29257.2	-18226.26	-3663.2	0	-14	-13	0	0	-108	32.8	67.73	67.79	54.16	46.29	191.12
[01/01/2021 03:00]	56487.24	25545.5	40389.06	-30941.74	-19935.3	-3648.24	0	-15	-12	0	0	-121	34.95	67.61	67.73	51.94	54.22	176.23
[01/01/2021 04:00]	56373.63	24180	40389.06	-32193.63	-21212.69	-3534.63	0	-15	-11	0	0	-134	36.7	66.48	67.67	49.17	57.26	163.59
[01/01/2021 05:00]	56247.17	24396.5	40389.06	-31850.67	-20893.73	-3408.17	0	-14	-11	0	0	-131	35.9	66.67	67.67	50.07	56.57	166.91
[01/01/2021 06:00]	56114.37	25267.5	40389.06	-30846.87	-19877.43	-3275.37	0	-13	-11	0	0	-122	34.6	67.59	67.79	54.59	60.09	172.7
[01/01/2021 07:00]	56114.82	26175	40389.06	-29939.82	-18945.88	-3275.82	0	-13	-11	0	0	-115	33.2	67.67	67.79	50.07	49.27	182.07
[01/01/2021 08:00]	56139.97	27364	40389.06	-28775.97	-17831.53	-3300.97	-72.5	-12	-12	0	0	-105	31.75	67.73	67.79	58.93	49.61	193.95


CREATE TABLE forecast_inputs (
  "date_wet" VARCHAR,
  "demand_plus_system_margin" VARCHAR,
  "demand" VARCHAR,
  "within_day_availability" VARCHAR,
  "margin" VARCHAR,
  "within_day_margin" VARCHAR,
  "long_term_wind" VARCHAR,
  "long_term_solar" VARCHAR,
  "long_term_wind_over_demand" VARCHAR,
  "long_term_wind_over_margin" VARCHAR,
  "long_term_solar_over_demand" VARCHAR,
  "long_term_solar_over_margin" VARCHAR,
  "margin_over_demand" VARCHAR,
  "snsp_forecast" VARCHAR,
  "stack_price" VARCHAR,
  "within_day_potential_stack_price" VARCHAR,
  "previous_day_ahead_price" VARCHAR,
  "previous_continuous_half_hour_vwap" VARCHAR,
  "inertia_forecast" VARCHAR
);