Loading...

Realtime Market Data

Total antal rækker: 158,444


2020-01-14 22:00Z 2020-01-14 23:00 DK2 None None 0.00 0.00 92.67 12.40 -22.42 -3.00 -22.42 -3.00 None None None None
2020-01-14 22:00Z 2020-01-14 23:00 DK1 826.7 0.0 0.00 0.00 92.67 12.40 -22.42 -3.00 -22.42 -3.00 None None None None
2020-01-14 21:00Z 2020-01-14 22:00 DK2 None None 0.00 0.00 166.65 22.30 166.65 22.30 166.65 22.30 None None None None
2020-01-14 21:00Z 2020-01-14 22:00 DK1 483.6 0.0 0.00 0.00 166.65 22.30 166.65 22.30 166.65 22.30 None None None None
2020-01-14 20:00Z 2020-01-14 21:00 DK2 None None 0.00 0.00 178.01 23.82 171.88 23.00 171.88 23.00 None None None None
2020-01-14 20:00Z 2020-01-14 21:00 DK1 660.6 0.0 0.00 0.00 178.01 23.82 171.88 23.00 171.88 23.00 None None None None
2020-01-14 19:00Z 2020-01-14 20:00 DK2 None None 0.00 0.00 187.73 25.12 171.88 23.00 171.88 23.00 None None None None
2020-01-14 19:00Z 2020-01-14 20:00 DK1 281.2 0.0 0.00 0.00 187.73 25.12 171.88 23.00 171.88 23.00 None None None None
2020-01-14 18:00Z 2020-01-14 19:00 DK2 None None 0.00 0.00 193.56 25.90 171.88 23.00 171.88 23.00 None None None None
2020-01-14 18:00Z 2020-01-14 19:00 DK1 126.6 0.0 0.00 0.00 193.56 25.90 171.88 23.00 171.88 23.00 None None None None
2020-01-14 17:00Z 2020-01-14 18:00 DK2 None None 0.00 91.10 672.59 90.00 197.67 26.45 672.59 90.00 None None None None
2020-01-14 17:00Z 2020-01-14 18:00 DK1 141.7 0.0 0.00 0.00 197.67 26.45 197.67 26.45 197.67 26.45 None None None None
2020-01-14 16:00Z 2020-01-14 17:00 DK2 None None 0.00 164.00 2,060.00 275.66 200.88 26.88 2,060.00 275.66 None None None None
2020-01-14 16:00Z 2020-01-14 17:00 DK1 121.5 0.0 0.00 0.00 200.88 26.88 200.88 26.88 200.88 26.88 None None None None
2020-01-14 15:00Z 2020-01-14 16:00 DK2 None None 0.00 0.00 198.41 26.55 198.41 26.55 198.41 26.55 None None None None
2020-01-14 15:00Z 2020-01-14 16:00 DK1 56.7 0.0 0.00 0.00 198.41 26.55 198.41 26.55 198.41 26.55 None None None None
2020-01-14 14:00Z 2020-01-14 15:00 DK2 None None 0.00 0.00 195.80 26.20 195.80 26.20 195.80 26.20 None None None None
2020-01-14 14:00Z 2020-01-14 15:00 DK1 0.0 -71.0 0.00 0.00 195.80 26.20 195.80 26.20 195.80 26.20 None None None None
2020-01-14 13:00Z 2020-01-14 14:00 DK2 None None 0.00 0.00 192.51 25.76 192.51 25.76 192.51 25.76 None None None None
2020-01-14 13:00Z 2020-01-14 14:00 DK1 0.0 -74.8 0.00 0.00 192.51 25.76 192.51 25.76 192.51 25.76 None None None None
2020-01-14 12:00Z 2020-01-14 13:00 DK2 None None 0.00 0.00 191.31 25.60 171.88 23.00 171.88 23.00 None None None None
2020-01-14 12:00Z 2020-01-14 13:00 DK1 0.0 -133.9 0.00 0.00 191.31 25.60 171.88 23.00 171.88 23.00 None None None None
2020-01-14 11:00Z 2020-01-14 12:00 DK2 None None 0.00 0.00 190.64 25.51 171.88 23.00 171.88 23.00 None None None None
2020-01-14 11:00Z 2020-01-14 12:00 DK1 0.0 -94.7 0.00 0.00 190.64 25.51 171.88 23.00 171.88 23.00 None None None None
2020-01-14 10:00Z 2020-01-14 11:00 DK2 None None 0.00 0.00 191.54 25.63 171.88 23.00 171.88 23.00 None None None None
2020-01-14 10:00Z 2020-01-14 11:00 DK1 0.0 -149.7 0.00 0.00 191.54 25.63 171.88 23.00 171.88 23.00 None None None None
2020-01-14 09:00Z 2020-01-14 10:00 DK2 None None 0.00 0.00 192.36 25.74 166.00 22.21 166.00 22.21 None None None None
2020-01-14 09:00Z 2020-01-14 10:00 DK1 0.0 -164.8 0.00 0.00 192.36 25.74 166.00 22.21 166.00 22.21 None None None None
2020-01-14 08:00Z 2020-01-14 09:00 DK2 None None 0.00 0.00 192.73 25.79 166.00 22.21 166.00 22.21 None None None None
2020-01-14 08:00Z 2020-01-14 09:00 DK1 69.6 0.0 0.00 0.00 192.73 25.79 166.00 22.21 166.00 22.21 None None None None
2020-01-14 07:00Z 2020-01-14 08:00 DK2 None None 0.00 0.00 201.78 27.00 193.11 25.84 201.78 27.00 None None None None
2020-01-14 07:00Z 2020-01-14 08:00 DK1 0.0 -86.4 0.00 0.00 201.78 27.00 193.11 25.84 201.78 27.00 None None None None
2020-01-14 06:00Z 2020-01-14 07:00 DK2 None None 0.00 0.00 202.75 27.13 202.75 27.13 202.75 27.13 None None None None
2020-01-14 06:00Z 2020-01-14 07:00 DK1 0.0 -39.3 0.00 0.00 202.75 27.13 202.75 27.13 202.75 27.13 None None None None
2020-01-14 05:00Z 2020-01-14 06:00 DK2 None None 0.00 0.00 201.78 27.00 184.06 24.63 201.78 27.00 None None None None
2020-01-14 05:00Z 2020-01-14 06:00 DK1 15.8 0.0 0.00 11.00 201.78 27.00 188.55 25.23 201.78 27.00 None None None None
2020-01-14 04:00Z 2020-01-14 05:00 DK2 None None 0.00 0.00 151.78 20.31 101.86 13.63 101.86 13.63 None None None None
2020-01-14 04:00Z 2020-01-14 05:00 DK1 0.0 -104.9 0.00 0.00 105.60 14.13 101.86 13.63 101.86 13.63 None None None None
2020-01-14 03:00Z 2020-01-14 04:00 DK2 None None 0.00 0.00 138.25 18.50 44.84 6.00 44.84 6.00 None None None None
2020-01-14 03:00Z 2020-01-14 04:00 DK1 0.0 -49.3 0.00 0.00 11.81 1.58 11.81 1.58 11.81 1.58 None None None None
2020-01-14 02:00Z 2020-01-14 03:00 DK2 None None 0.00 0.00 95.36 12.76 15.09 2.02 15.09 2.02 None None None None
2020-01-14 02:00Z 2020-01-14 03:00 DK1 0.0 -41.3 0.00 0.00 11.36 1.52 11.36 1.52 11.36 1.52 None None None None
2020-01-14 01:00Z 2020-01-14 02:00 DK2 None None 0.00 0.00 92.00 12.31 92.00 12.31 92.00 12.31 None None None None
2020-01-14 01:00Z 2020-01-14 02:00 DK1 0.0 -226.6 0.00 0.00 66.44 8.89 66.44 8.89 66.44 8.89 None None None None
2020-01-14 00:00Z 2020-01-14 01:00 DK2 None None 0.00 0.00 128.09 17.14 128.09 17.14 128.09 17.14 None None None None
2020-01-14 00:00Z 2020-01-14 01:00 DK1 0.0 -285.2 0.00 0.00 123.31 16.50 123.31 16.50 123.31 16.50 None None None None
2020-01-13 23:00Z 2020-01-14 00:00 DK2 None None 0.00 0.00 165.98 22.21 165.98 22.21 165.98 22.21 None None None None
2020-01-13 23:00Z 2020-01-14 00:00 DK1 0.0 -401.5 0.00 0.00 168.82 22.59 168.82 22.59 168.82 22.59 None None None None
2020-01-13 22:00Z 2020-01-13 23:00 DK2 None None 0.00 0.00 174.87 23.40 161.41 21.60 161.41 21.60 None None None None
2020-01-13 22:00Z 2020-01-13 23:00 DK1 279.0 0.0 0.00 0.00 174.87 23.40 161.41 21.60 161.41 21.60 None None None None

Data Dictionary

Column Type Label Beskrivelse
HourUTC timestamptz
HourDK timestamp
PriceArea text
ImbalanceSurplus float8
ImbalanceDeficit float8
RegulatingPowerDown float8
RegulatingPowerUp float8
BalancingPowerPriceUpDKK float8
BalancingPowerPriceUpEUR float8
BalancingPowerPriceDownDKK float8
BalancingPowerPriceDownEUR float8
BalancingPowerConsumptionPriceDKK float8
BalancingPowerConsumptionPriceEUR float8
IGCC_PriceUpDKK float8
IGCC_PriceUpEUR float8
IGCC_PriceDownDKK float8
IGCC_PriceDownEUR float8

Hour UTC

Navn Hour UTC
Beskrivelse

A date and time (interval), shown in UTC time zone, where the values are valid. 00:00 o\u2019clock is the first hour of a given day interval 00:00 - 00:59 and 01:00 covers the second hour (interval) of the day and so forth. Please note: The naming is based on the length of the interval of the finest grain of the resolution.

Kommentar

Please note that the format shown in the example applies to data download as JSON, XML or fetched through the API and is in accordance with the ISO 8601 standard. The format is slightly different when it is shown on screen or downloaded manually as CSV or XLSX. This is mainly due to readability and consideration for Excel users.

In preview (in the GUI) all timestamps are shown as (display convention) YYYY-MM-DD hh:mmZ e.g. 2017-07-14 08:00Z. The Z will remind viewers that this is UTC.

In download (CSV and XLSX) the date time are exported as YYYY-MM-DD hh:mm e.g. 2017-07-14 08:00. That is without the \u201cT\u201d and the \u201cZ\u201d and the seconds. Excel will recognize it as date-time. The user must remember the convention about time zones.

In download (JSON and XML) the full format is used YYYY-MM-DDThh:mmZ e.g. 2017-07-14T08:00Z.

Eksempel 2017-07-14T08:00Z
Enhed
Felt HourUTC
Property Constraint
Type datetime
Størrelse 17
Format Regex
Validation Rules Always full hours, i.e. minutes are 00

Hour DK

Navn Hour DK
Beskrivelse

A date and time (interval), shown in Danish time zone, where the values are valid. 00:00 o\u2019clock is the first hour of a given day, interval 00:00 - 00:59, and 01:00 covers the second hour period (interval) of the day and so forth.

Kommentar

On one normal day there will be 24 intervals.

When daylight saving times shifts there will be either 23 or 25 intervals.

Please note that the format shown in the example applies to data download as JSON, XML or fetched through the API and is in accordance with the ISO 8601 standard. The format is slightly different when it is shown on screen or downloaded manually as CSV or XLSX. This is mainly due to readability and consideration for Excel users.

In preview (in the GUI) all timestamps are shown as (display convention) YYYY-MM-DD hh:mm e.g. 2017-07-14 08:00. Please note that is no time zone indicator, showning that this is local (Danish) time.

In download (CSV and XLSX) the date time are exported as YYYY-MM-DD hh:mm e.g. 2017-07-14 08:00. That is without the \u201cT\u201d and the seconds. Excel will recognize it as date-time. The user must remember that this is local (Danish) time.

In download (JSON and XML) the format used is YYYY-MM-DDThh:mm e.g. 2017-07-14T08:00.

Eksempel 2017-07-14T08:00
Enhed
Felt HourDK
Property Constraint
Type datetime
Størrelse 17
Format Regex
Validation Rules Always full hours, i.e. minutes are 00

Price area

Navn Price area
Beskrivelse

DK1 is Jutland and Fyen and DK2 is Zealand and islands

Kommentar

DK1 and DK2 are the standard abbreviation for the two Danish price areas

Eksempel DK1
Enhed
Felt PriceArea
Property Constraint
Type string
Størrelse 3
Format Regex
Validation Rules DK1 or DK2

System imbalance - surplus of power

Navn System imbalance - surplus of power
Beskrivelse

Surplus of power at the East Danish system (need for down-regulation) in MWh per hour

Kommentar
Eksempel 184.3
Enhed MWh per hour
Felt ImbalanceSurplus
Property Constraint
Type number
Størrelse 9.1
Format Regex
Validation Rules

System imbalance - deficit of power

Navn System imbalance - deficit of power
Beskrivelse

Deficit of power in the power system. (need for up-regulation) in MWh per hour

Kommentar
Eksempel 184.3
Enhed MWh per hour
Felt ImbalanceDeficit
Property Constraint
Type number
Størrelse 9.1
Format Regex
Validation Rules

Regulating power - downward regulation

Navn Regulating power - downward regulation
Beskrivelse

The actual amount of energy down-regulated

Kommentar
Eksempel 500
Enhed MWh per hour
Felt RegulatingPowerDown
Property Constraint
Type number
Størrelse 4
Format Regex
Validation Rules

Regulating power - upward regulation

Navn Regulating power - upward regulation
Beskrivelse

The actual amount of energy up-regulated

Kommentar
Eksempel 500
Enhed MWh per hour
Felt RegulatingPowerUp
Property Constraint
Type number
Størrelse 4
Format Regex
Validation Rules

Balancing power price - up regulation (DKK)

Navn Balancing power price - up regulation (DKK)
Beskrivelse

Comma (,) is used as decimal sign and 1000 separator isn\u2019t allowed

Kommentar
Eksempel 500
Enhed DKK per MWh
Felt BalancingPowerPriceUpDKK
Property Constraint
Type number
Størrelse 9.2
Format Regex
Validation Rules

Balancing power price - up regulation (EUR)

Navn Balancing power price - up regulation (EUR)
Beskrivelse

Comma (,) is used as decimal sign and 1000 separator isn\u2019t allowed

Kommentar

-

Eksempel 500
Enhed EUR per MWh
Felt BalancingPowerPriceUpEUR
Property Constraint
Type number
Størrelse 9.2
Format Regex
Validation Rules

Balancing power price - down regulation (DKK)

Navn Balancing power price - down regulation (DKK)
Beskrivelse

Comma (,) is used as decimal sign and 1000 separator isn\u2019t allowed

Kommentar
Eksempel 500
Enhed DKK per MWh
Felt BalancingPowerPriceDownDKK
Property Constraint
Type number
Størrelse 9.2
Format Regex
Validation Rules

Balancing power price - down regulation (EUR)

Navn Balancing power price - down regulation (EUR)
Beskrivelse

Comma (,) is used as decimal sign and 1000 separator isn\u2019t allowed

Kommentar
Eksempel 500
Enhed EUR per MWh
Felt BalancingPowerPriceDownEUR
Property Constraint
Type number
Størrelse 9.2
Format Regex
Validation Rules

Price for balancing power for consumption (DKK)

Navn Price for balancing power for consumption (DKK)
Beskrivelse

Price for balancing power for consumption, equals either the price of down regulation or up-regulation

Kommentar
Eksempel 500
Enhed DKK per MWh
Felt BalancingPowerConsumptionPriceDKK
Property Constraint
Type number
Størrelse 9.2
Format Regex
Validation Rules

Price for balancing power for consumption (EUR)

Navn Price for balancing power for consumption (EUR)
Beskrivelse

Price for balancing power for consumption, equals either the price of down regulation or up-regulation

Kommentar
Eksempel 500
Enhed EUR per MWh
Felt BalancingPowerConsumptionPriceEUR
Property Constraint
Type number
Størrelse 9.2
Format Regex
Validation Rules

IGCC Price up regulation (DKK)

Navn IGCC Price up regulation (DKK)
Beskrivelse

Up Regulation through netting with TSO's in the IGCC coorporatoin

Kommentar

Is calculated as an average price once a week

Eksempel 43
Enhed DKK per MWh/h
Felt IGCC_PriceUpDKK
Property Constraint
Type number
Størrelse 9.2
Format Regex
Validation Rules >=0

IGCC Price up regulation (EUR)

Navn IGCC Price up regulation (EUR)
Beskrivelse

Up Regulation through netting with TSO's in the IGCC coorporatoin

Kommentar

Is calculated as an average price once a week

Eksempel 6.50
Enhed EUR per MWh/h
Felt IGCC_PriceUpEUR
Property Constraint
Type number
Størrelse 9.2
Format Regex
Validation Rules >=0

IGCC Price down regulation (DKK)

Navn IGCC Price down regulation (DKK)
Beskrivelse

Down Regulation through netting with TSO's in the IGCC coorporatoin

Kommentar

Is calculated as an average price once a week

Eksempel 65
Enhed DKK per MWh/h
Felt IGCC_PriceDownDKK
Property Constraint
Type number
Størrelse 9.2
Format Regex
Validation Rules >=0

IGCC Price down regulation (EUR)

Navn IGCC Price down regulation (EUR)
Beskrivelse

Down Regulation through netting with TSO's in the IGCC coorporatoin

Kommentar

Is calculated as an average price once a week

Eksempel 23
Enhed EUR per MWh/h
Felt IGCC_PriceDownEUR
Property Constraint
Type number
Størrelse 9.2
Format Regex
Validation Rules >=0