Entsoe

Query ENTSOE energy market data including prices, load, and generation.

Query ENTSOE timeseries data

post

Query ENTSOE energy market timeseries data including:

Day-ahead and imbalance prices
Load and generation actuals and forecasts
Cross-border flows and scheduled exchanges
Wind and solar forecasts

Supported Variables:

day_ahead_prices: Day-ahead electricity market prices
imbalance_prices: Imbalance settlement prices
load_actual: Actual total load
load_forecast_da: Day-ahead load forecast
generation_actual: Actual power generation by source type
generation_forecast_da: Day-ahead generation forecast
crossborder_flows: Physical cross-border power flows
wind_solar_forecast_da: Day-ahead wind/solar forecast
And more...

Response Formats:

json: Columnar JSON format {column: [values], ...}
arrow: Apache Arrow IPC stream for efficient processing

Authentication: Requires API key.

For more information, see docs.jua.ai.

Authorizations

Query parameters

formatstring · enumOptional

Response format: 'json' for columnar JSON or 'arrow' for Apache Arrow format

Default: jsonPossible values:

include_unitsbooleanOptional

When true, JSON responses are wrapped in {data, units}. Units are always sent via X-Variable-Units header regardless.

Default: false

Body

Query parameters for ENTSOE timeseries data.

Supports filtering by:

variables: List of ENTSOE variable types (optional, returns all if not set)
zone_keys: List of zone codes for zone-based data
zone_from/zone_to: For cross-border flow queries
psr_types: For generation data by source type
start_time: Start of time range (required)
end_time: End of time range (optional - if None, no upper bound applied)

Note: end_time can be None to include all future data, which is useful for day-ahead forecasts that extend into tomorrow.

start_timestring · date-timeRequired

Start time for the query (inclusive)

Example: 2025-12-01T00:00:00Z

end_timestring · date-time · nullableOptional

End time for the query (exclusive). If None, no upper bound is applied (useful for day-ahead forecasts)

Example: 2025-12-15T00:00:00Z

aggregationstring · enumOptional

Temporal aggregation to apply

Default: nonePossible values:

include_metadatabooleanOptional

Include metadata column in response

Default: false

time_zonestring · nullableOptional

IANA time zone name for time formatting (e.g., 'Europe/Berlin', 'America/New_York'). Defaults to UTC

Example: UTC

Responses

200

Successfully retrieved ENTSOE data

anyOptional

400

Invalid query parameters

401

Authentication required

403

Insufficient permissions

422

Validation Error

application/json

post/v1/entsoe/data

POST /v1/entsoe/data HTTP/1.1
Content-Type: application/json
Accept: */*
Content-Length: 126

{
  "variables": [
    "day_ahead_prices"
  ],
  "zone_keys": [
    "DE_LU"
  ],
  "start_time": "2025-12-01T00:00:00Z",
  "end_time": "2025-12-15T00:00:00Z"
}

{
  "time": [
    "2025-12-01T00:00:00Z",
    "2025-12-01T01:00:00Z"
  ],
  "variable_name": [
    "day_ahead_prices",
    "day_ahead_prices"
  ],
  "zone_key": [
    "DE_LU",
    "DE_LU"
  ],
  "zone_key_from": [
    "",
    ""
  ],
  "zone_key_to": [
    "",
    ""
  ],
  "psr_type": [
    "",
    ""
  ],
  "other_type": [
    "",
    ""
  ],
  "value": [
    85.5,
    82.3
  ],
  "unit": [
    "EUR/MWh",
    "EUR/MWh"
  ],
  "currency": [
    "EUR",
    "EUR"
  ]
}

Query ENTSOE data in pivoted wide-column format

post

Returns ENTSO-E generation+load data pivoted into one column per PSR type, with optional derived columns (wind_total, renewables_total, residual_load) and linear interpolation — all computed inside ClickHouse.

Authorizations

Query parameters

formatstring · enumOptional

Response format: 'json' or 'arrow'

Default: jsonPossible values:

Body

Query that returns ENTSO-E data pivoted into wide-column format.

Pivots PSR-based generation data into per-source columns, optionally joins load, and interpolates to a regular time grid in ClickHouse. Derived columns (wind_total / renewables_total / residual_load) are computed post-query in query_pivoted_data via the shared compute_derived_power_columns helper — same code path as UK power and the api-server pivoted view, so null-propagation semantics match everywhere. Callers declare intent via needed_derived_vars (the set of derived column names they want); feasibility (does this zone have onshore+offshore? does the frame have load?) is decided by the derivation helper itself, not by the call site.

generation_variablestring · enum · nullableOptional

ENTSO-E variable for generation data

Possible values:

load_variablestring · enum · nullableOptional

ENTSO-E variable for load data

Possible values:

start_timestring · date-timeRequired

Start time (inclusive)

end_timestring · date-time · nullableOptional

End time (exclusive)

temporal_resolution_minutesinteger · nullableOptional

Target resolution; None to skip interpolation

Default: 15

model_labelstringOptional

Value for the 'model' column in output rows

Default: ENTSO-E Actual

needed_derived_varsstring[] · nullableOptional

Set of derived column names to attempt to compute (wind_total_mw / renewables_total_mw / residual_load_mw). compute_derived_power_columns silently skips any whose input columns aren't in the frame, so callers don't have to mirror the feasibility logic. None means no derivation.

load_colstringOptionalDefault: load_mw

Responses

200

Successful Response

application/json

anyOptional

422

Validation Error

application/json

post/v1/entsoe/pivoted

POST /v1/entsoe/pivoted HTTP/1.1
Content-Type: application/json
Accept: */*
Content-Length: 414

{
  "zone_keys": [
    "AL"
  ],
  "psr_types": [
    "Biomass"
  ],
  "generation_variable": "countertrading",
  "load_variable": "countertrading",
  "psr_column_map": {
    "ANY_ADDITIONAL_PROPERTY": "text"
  },
  "start_time": "2026-08-11T15:22:43.934Z",
  "end_time": "2026-08-11T15:22:43.934Z",
  "temporal_resolution_minutes": 15,
  "model_label": "ENTSO-E Actual",
  "needed_derived_vars": [
    "text"
  ],
  "load_col": "load_mw",
  "zone_key_remap": {
    "ANY_ADDITIONAL_PROPERTY": "text"
  }
}

No content

Query ENTSOE outages data

post

Query ENTSOE infrastructure outages (generation units and transmission lines).

Features:

Source Types: Generation units (power plants) or Transmission lines
Time Filtering: Real-time snapshots (active_at) or schedule ranges (start_from/to)
Filtering: Filter by zone, plant type, business type (planned/forced)
Aggregation: Optional capacity aggregation summaries

Authentication: Requires API key.

Authorizations

Query parameters

formatstring · enumOptional

Response format: 'json' for columnar JSON or 'arrow' for Apache Arrow format

Default: jsonPossible values:

Body

Query parameters for ENTSOE outages data.

Supports filtering by:

source_type: Generation vs Transmission
zones: biddingzone_domain (gen) or in_domain/out_domain (trans)
time: active_at, or start_from/start_to
attributes: plant_type, business_type, status

source_typestring · enum · nullableOptional

Filter by source type (generation_unit or transmission)

Possible values:

active_atstring · date-time · nullableOptional

Get outages active at this specific time (start <= time < end)

start_fromstring · date-time · nullableOptional

Filter by start time >= this value

start_tostring · date-time · nullableOptional

Filter by start time < this value

exclude_cancelledbooleanOptional

Exclude cancelled outages (docstatus in ['A09', 'Cancelled'])

Default: true

Responses

200

Successfully retrieved outages data

anyOptional

400

Invalid query parameters

401

Authentication required

403

Insufficient permissions

422

Validation Error

application/json

post/v1/entsoe/outages

POST /v1/entsoe/outages HTTP/1.1
Content-Type: application/json
Accept: */*
Content-Length: 99

{
  "source_type": "generation_unit",
  "biddingzone_domain": [
    "DE_LU"
  ],
  "active_at": "2025-12-01T12:00:00Z"
}

{}

List available ENTSOE variables

get

Get a list of available ENTSOE variable types with metadata including:

Variable name
Description
Unit of measurement
Whether variable uses zone_key, zone_from/zone_to, or psr_type filters

Authentication: Requires API key.

Authorizations

Query parameters

zone_keystring · nullableOptional

Optional zone to filter variables by

Responses

200

Successfully retrieved variable list

application/json

Result for available variables query.

401

Authentication required

422

Validation Error

application/json

get/v1/entsoe/variables

GET /v1/entsoe/variables HTTP/1.1
Accept: */*

{
  "variables": [
    {
      "name": "day_ahead_prices",
      "description": "Day-ahead electricity market prices",
      "unit": "EUR/MWh",
      "uses_zone_key": true,
      "uses_zone_from_to": false,
      "uses_psr_type": false
    }
  ]
}

List available ENTSOE zones

get

Get a list of available zone codes (bidding zones, countries).

Optionally filter by variable to see which zones have data for a specific variable.

Authentication: Requires API key.

Authorizations

Query parameters

variablestring · enum · nullableOptional

Optional variable to filter zones by

Possible values:

Responses

200

Successfully retrieved zone list

application/json

Result for available zones query.

zonesstring[]Required

401

Authentication required

422

Validation Error

application/json

get/v1/entsoe/zones

GET /v1/entsoe/zones HTTP/1.1
Accept: */*

{
  "zones": [
    "AT",
    "BE",
    "CH",
    "DE",
    "DK_1",
    "DK_2",
    "FR",
    "NL"
  ]
}

List available PSR types

get

Get a list of available PSR (Production Source Type) codes for generation data.

PSR types include:

Solar, Wind Onshore, Wind Offshore
Nuclear, Hydro (various types)
Fossil fuels (Gas, Coal, Oil, etc.)
Biomass, Geothermal, etc.

Authentication: Requires API key.

Authorizations

Responses

200

Successfully retrieved PSR type list

application/json

Result for available PSR types query.

psr_typesstring[]Required

401

Authentication required

422

Validation Error

application/json

get/v1/entsoe/psr-types

GET /v1/entsoe/psr-types HTTP/1.1
Accept: */*

{
  "psr_types": [
    "Biomass",
    "Fossil Gas",
    "Nuclear",
    "Solar",
    "Wind Offshore",
    "Wind Onshore"
  ]
}

PreviousBenchmarks NextNetztransparenz

Last updated 13 minutes ago