# Eex Power

Query EEX Group power derivatives market data including EOD settlement prices and individual exchange trades across 33 European market areas.

## Query EEX power settlement prices

> Query EEX Group power derivatives end-of-day settlement prices.\
> \
> Data covers \*\*33 European market areas\*\* (DE, FR, AT, BE, NL, CH, CZ, SK, PL, RO, HU,\
> HR, RS, SI, BG, IT, GR, ES, IE, GB, SE1-SE4, DK1, DK2, FI, NO1-NO5, Phelix, Nordic).\
> \
> Settlements are published daily at \~18:30 UTC on weekdays. Historical data available\
> from November 2020. Includes futures and options (use \`exclude\_options=true\` for\
> futures only).\
> \
> \*\*Response Formats:\*\*\
> \- \`json\`: Columnar JSON \`{column: \[values], ...}\`\
> \- \`arrow\`: Apache Arrow IPC stream for efficient processing\
> \
> \*\*Authentication\*\*: Requires API key.

```json
{"openapi":"3.1.0","info":{"title":"Jua Query Engine API","version":"0.1.0"},"tags":[{"name":"eex-power","description":"Query EEX Group power derivatives market data including EOD settlement prices and individual exchange trades across 33 European market areas."}],"security":[{"HTTPBearer":[]}],"paths":{"/v1/eex-power/settlements":{"post":{"tags":["eex-power"],"summary":"Query EEX power settlement prices","description":"Query EEX Group power derivatives end-of-day settlement prices.\n\nData covers **33 European market areas** (DE, FR, AT, BE, NL, CH, CZ, SK, PL, RO, HU,\nHR, RS, SI, BG, IT, GR, ES, IE, GB, SE1-SE4, DK1, DK2, FI, NO1-NO5, Phelix, Nordic).\n\nSettlements are published daily at ~18:30 UTC on weekdays. Historical data available\nfrom November 2020. Includes futures and options (use `exclude_options=true` for\nfutures only).\n\n**Response Formats:**\n- `json`: Columnar JSON `{column: [values], ...}`\n- `arrow`: Apache Arrow IPC stream for efficient processing\n\n**Authentication**: Requires API key.","operationId":"post_eex_settlements_v1_eex_power_settlements_post","parameters":[{"name":"format","in":"query","required":false,"schema":{"enum":["json","arrow"],"type":"string","description":"Response format: 'json' or 'arrow'","default":"json","title":"Format"},"description":"Response format: 'json' or 'arrow'"}],"requestBody":{"required":true,"content":{"application/json":{"schema":{"$ref":"#/components/schemas/EexSettlementsQuery"}}}},"responses":{"200":{"description":"Successfully retrieved EEX settlement data","content":{"application/json":{"schema":{}},"application/vnd.apache.arrow.stream":{"description":"Apache Arrow IPC stream format"}}},"400":{"description":"Invalid query parameters"},"401":{"description":"Authentication required"},"422":{"description":"Validation Error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/HTTPValidationError"}}}}}}}},"components":{"schemas":{"EexSettlementsQuery":{"properties":{"areas":{"anyOf":[{"items":{"type":"string"},"type":"array"},{"type":"null"}],"title":"Areas","description":"Market area codes to filter by (e.g. ['DE', 'FR']). If not set, returns all areas."},"short_codes":{"anyOf":[{"items":{"type":"string"},"type":"array"},{"type":"null"}],"title":"Short Codes","description":"EEX ShortCodes to filter by (e.g. ['DEBM', 'DEBQ']). If not set, returns all ShortCodes."},"start_date":{"anyOf":[{"type":"string","format":"date"},{"type":"null"}],"title":"Start Date","description":"Start trading date (inclusive)."},"end_date":{"anyOf":[{"type":"string","format":"date"},{"type":"null"}],"title":"End Date","description":"End trading date (inclusive)."},"exclude_options":{"type":"boolean","title":"Exclude Options","description":"When true, excludes option records (option_type != '').","default":false},"as_of":{"anyOf":[{"type":"string","format":"date-time"},{"type":"null"}],"title":"As Of","description":"Point-in-time replay: only return rows whose modelled EEX publication time is on or before this UTC datetime.  The settlements rule is ``max(tm, trd_date 18:00 UTC)`` — EEX publishes EOD settlements in a daily batch that completes around 16:20–16:45 UTC, so a settlement is not visible at an ``as_of`` earlier than that even if its ``tm`` says otherwise.  Used by the /simulate endpoint; live callers should leave unset."},"time_zone":{"anyOf":[{"type":"string"},{"type":"null"}],"title":"Time Zone","description":"IANA time zone for datetime output (e.g. 'Europe/Berlin')."},"order_by":{"anyOf":[{"items":{"$ref":"#/components/schemas/OrderByItem_str_"},"type":"array"},{"type":"null"}],"title":"Order By","description":"Columns to order by (e.g. 'trd_date__desc')."},"pagination":{"anyOf":[{"$ref":"#/components/schemas/Pagination"},{"type":"null"}],"description":"Pagination parameters (requires order_by)."}},"type":"object","title":"EexSettlementsQuery","description":"Query parameters for EEX power settlement prices.\n\nFetches from eex_power_settlements. Filtered by trading date, area,\nand ShortCode. Deleted records (updt_act='Delete') are excluded by default."},"OrderByItem_str_":{"properties":{"field":{"type":"string","title":"Field","description":"Field to sort by"},"direction":{"$ref":"#/components/schemas/SortDirection","description":"Sort direction: 'asc' (default) or 'desc'","default":"asc"},"aggregation":{"anyOf":[{"type":"string","enum":["avg","std","min","max","sum","count","median","quantile","argmin","argmax"]},{"type":"null"}],"title":"Aggregation","description":"Aggregation function when ordering by variable"}},"type":"object","required":["field"],"title":"OrderByItem[str]"},"SortDirection":{"type":"string","enum":["asc","desc"],"title":"SortDirection","description":"Sort direction for ORDER BY clauses."},"Pagination":{"properties":{"limit":{"type":"integer","title":"Limit","default":100},"offset":{"type":"integer","title":"Offset","default":0}},"type":"object","title":"Pagination"},"HTTPValidationError":{"properties":{"detail":{"items":{"$ref":"#/components/schemas/ValidationError"},"type":"array","title":"Detail"}},"type":"object","title":"HTTPValidationError"},"ValidationError":{"properties":{"loc":{"items":{"anyOf":[{"type":"string"},{"type":"integer"}]},"type":"array","title":"Location"},"msg":{"type":"string","title":"Message"},"type":{"type":"string","title":"Error Type"},"input":{"title":"Input"},"ctx":{"type":"object","title":"Context"}},"type":"object","required":["loc","msg","type"],"title":"ValidationError"}}}}
```

## Query EEX power individual trades

> Query individual exchange trades for EEX Group power derivatives.\
> \
> Trades are polled every 5 minutes during trading hours. The \`from\_broken\_spread\`\
> and \`volume\_only\` flags identify spread/cascade legs (no independent price).\
> Use \`exclude\_spread\_legs=true\` for outright trades only.\
> \
> \*\*Authentication\*\*: Requires API key.

```json
{"openapi":"3.1.0","info":{"title":"Jua Query Engine API","version":"0.1.0"},"tags":[{"name":"eex-power","description":"Query EEX Group power derivatives market data including EOD settlement prices and individual exchange trades across 33 European market areas."}],"security":[{"HTTPBearer":[]}],"paths":{"/v1/eex-power/trades":{"post":{"tags":["eex-power"],"summary":"Query EEX power individual trades","description":"Query individual exchange trades for EEX Group power derivatives.\n\nTrades are polled every 5 minutes during trading hours. The `from_broken_spread`\nand `volume_only` flags identify spread/cascade legs (no independent price).\nUse `exclude_spread_legs=true` for outright trades only.\n\n**Authentication**: Requires API key.","operationId":"post_eex_trades_v1_eex_power_trades_post","parameters":[{"name":"format","in":"query","required":false,"schema":{"enum":["json","arrow"],"type":"string","description":"Response format: 'json' or 'arrow'","default":"json","title":"Format"},"description":"Response format: 'json' or 'arrow'"}],"requestBody":{"required":true,"content":{"application/json":{"schema":{"$ref":"#/components/schemas/EexTradesQuery"}}}},"responses":{"200":{"description":"Successfully retrieved EEX trade data","content":{"application/json":{"schema":{}},"application/vnd.apache.arrow.stream":{"description":"Apache Arrow IPC stream format"}}},"400":{"description":"Invalid query parameters"},"401":{"description":"Authentication required"},"422":{"description":"Validation Error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/HTTPValidationError"}}}}}}}},"components":{"schemas":{"EexTradesQuery":{"properties":{"areas":{"anyOf":[{"items":{"type":"string"},"type":"array"},{"type":"null"}],"title":"Areas","description":"Market area codes to filter by (e.g. ['DE', 'FR'])."},"short_codes":{"anyOf":[{"items":{"type":"string"},"type":"array"},{"type":"null"}],"title":"Short Codes","description":"EEX ShortCodes to filter by (e.g. ['DEBM'])."},"start_time":{"anyOf":[{"type":"string","format":"date-time"},{"type":"null"}],"title":"Start Time","description":"Start trade timestamp (inclusive, filters on tm column)."},"end_time":{"anyOf":[{"type":"string","format":"date-time"},{"type":"null"}],"title":"End Time","description":"End trade timestamp (exclusive, filters on tm column)."},"trd_date_start":{"anyOf":[{"type":"string","format":"date"},{"type":"null"}],"title":"Trd Date Start","description":"Start trading date (inclusive, filters on trd_date column)."},"trd_date_end":{"anyOf":[{"type":"string","format":"date"},{"type":"null"}],"title":"Trd Date End","description":"End trading date (inclusive, filters on trd_date column)."},"exclude_spread_legs":{"type":"boolean","title":"Exclude Spread Legs","description":"When true, excludes spread/cascade legs (volume_only = false).","default":false},"exclude_cancellations":{"type":"boolean","title":"Exclude Cancellations","description":"When true, excludes cancelled trades (updt_act != 'Delete').","default":false},"as_of":{"anyOf":[{"type":"string","format":"date-time"},{"type":"null"}],"title":"As Of","description":"Point-in-time replay: only return rows whose modelled REST publication time is on or before this UTC datetime.  The trades rule is ``tm + 5 minutes`` — Jua polls EEX's REST tier every 5 minutes, so a trade with exchange-time ``tm`` is conservatively considered visible to a Jua REST consumer at ``tm + 5min``.  Used by the /simulate endpoint; live callers should leave unset."},"time_zone":{"anyOf":[{"type":"string"},{"type":"null"}],"title":"Time Zone","description":"IANA time zone for datetime output."},"order_by":{"anyOf":[{"items":{"$ref":"#/components/schemas/OrderByItem_str_"},"type":"array"},{"type":"null"}],"title":"Order By","description":"Columns to order by (e.g. 'tm__desc')."},"pagination":{"anyOf":[{"$ref":"#/components/schemas/Pagination"},{"type":"null"}],"description":"Pagination parameters (requires order_by)."}},"type":"object","title":"EexTradesQuery","description":"Query parameters for EEX power individual trades.\n\nFetches from eex_power_trades. Supports filtering by area, ShortCode,\ntrade timestamp, and trading date. Optional flags to exclude spread legs\nand cancellations."},"OrderByItem_str_":{"properties":{"field":{"type":"string","title":"Field","description":"Field to sort by"},"direction":{"$ref":"#/components/schemas/SortDirection","description":"Sort direction: 'asc' (default) or 'desc'","default":"asc"},"aggregation":{"anyOf":[{"type":"string","enum":["avg","std","min","max","sum","count","median","quantile","argmin","argmax"]},{"type":"null"}],"title":"Aggregation","description":"Aggregation function when ordering by variable"}},"type":"object","required":["field"],"title":"OrderByItem[str]"},"SortDirection":{"type":"string","enum":["asc","desc"],"title":"SortDirection","description":"Sort direction for ORDER BY clauses."},"Pagination":{"properties":{"limit":{"type":"integer","title":"Limit","default":100},"offset":{"type":"integer","title":"Offset","default":0}},"type":"object","title":"Pagination"},"HTTPValidationError":{"properties":{"detail":{"items":{"$ref":"#/components/schemas/ValidationError"},"type":"array","title":"Detail"}},"type":"object","title":"HTTPValidationError"},"ValidationError":{"properties":{"loc":{"items":{"anyOf":[{"type":"string"},{"type":"integer"}]},"type":"array","title":"Location"},"msg":{"type":"string","title":"Message"},"type":{"type":"string","title":"Error Type"},"input":{"title":"Input"},"ctx":{"type":"object","title":"Context"}},"type":"object","required":["loc","msg","type"],"title":"ValidationError"}}}}
```

## List available EEX market areas

> Get a list of market area codes with data in ClickHouse.\
> \
> \*\*Authentication\*\*: Requires API key.

```json
{"openapi":"3.1.0","info":{"title":"Jua Query Engine API","version":"0.1.0"},"tags":[{"name":"eex-power","description":"Query EEX Group power derivatives market data including EOD settlement prices and individual exchange trades across 33 European market areas."}],"security":[{"HTTPBearer":[]}],"paths":{"/v1/eex-power/areas":{"get":{"tags":["eex-power"],"summary":"List available EEX market areas","description":"Get a list of market area codes with data in ClickHouse.\n\n**Authentication**: Requires API key.","operationId":"get_eex_areas_v1_eex_power_areas_get","parameters":[{"name":"table","in":"query","required":false,"schema":{"enum":["settlements","trades"],"type":"string","description":"Which table to query for areas ('settlements' or 'trades')","default":"settlements","title":"Table"},"description":"Which table to query for areas ('settlements' or 'trades')"}],"responses":{"200":{"description":"Successful Response","content":{"application/json":{"schema":{"$ref":"#/components/schemas/jua_query_v2__eex_power__types__AvailableAreasResult"}}}},"422":{"description":"Validation Error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/HTTPValidationError"}}}}}}}},"components":{"schemas":{"jua_query_v2__eex_power__types__AvailableAreasResult":{"properties":{"areas":{"items":{"type":"string"},"type":"array","title":"Areas"}},"type":"object","required":["areas"],"title":"AvailableAreasResult","description":"Result type for available EEX market areas."},"HTTPValidationError":{"properties":{"detail":{"items":{"$ref":"#/components/schemas/ValidationError"},"type":"array","title":"Detail"}},"type":"object","title":"HTTPValidationError"},"ValidationError":{"properties":{"loc":{"items":{"anyOf":[{"type":"string"},{"type":"integer"}]},"type":"array","title":"Location"},"msg":{"type":"string","title":"Message"},"type":{"type":"string","title":"Error Type"},"input":{"title":"Input"},"ctx":{"type":"object","title":"Context"}},"type":"object","required":["loc","msg","type"],"title":"ValidationError"}}}}
```

## List available EEX ShortCodes

> Get a list of EEX product ShortCodes (e.g. DEBM, DEBQ, DEBY) with data in ClickHouse.\
> \
> \*\*Authentication\*\*: Requires API key.

```json
{"openapi":"3.1.0","info":{"title":"Jua Query Engine API","version":"0.1.0"},"tags":[{"name":"eex-power","description":"Query EEX Group power derivatives market data including EOD settlement prices and individual exchange trades across 33 European market areas."}],"security":[{"HTTPBearer":[]}],"paths":{"/v1/eex-power/short-codes":{"get":{"tags":["eex-power"],"summary":"List available EEX ShortCodes","description":"Get a list of EEX product ShortCodes (e.g. DEBM, DEBQ, DEBY) with data in ClickHouse.\n\n**Authentication**: Requires API key.","operationId":"get_eex_short_codes_v1_eex_power_short_codes_get","parameters":[{"name":"table","in":"query","required":false,"schema":{"enum":["settlements","trades"],"type":"string","description":"Which table to query for ShortCodes ('settlements' or 'trades')","default":"settlements","title":"Table"},"description":"Which table to query for ShortCodes ('settlements' or 'trades')"}],"responses":{"200":{"description":"Successful Response","content":{"application/json":{"schema":{"$ref":"#/components/schemas/jua_query_v2__eex_power__types__AvailableShortCodesResult"}}}},"422":{"description":"Validation Error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/HTTPValidationError"}}}}}}}},"components":{"schemas":{"jua_query_v2__eex_power__types__AvailableShortCodesResult":{"properties":{"short_codes":{"items":{"type":"string"},"type":"array","title":"Short Codes"}},"type":"object","required":["short_codes"],"title":"AvailableShortCodesResult","description":"Result type for available EEX product ShortCodes."},"HTTPValidationError":{"properties":{"detail":{"items":{"$ref":"#/components/schemas/ValidationError"},"type":"array","title":"Detail"}},"type":"object","title":"HTTPValidationError"},"ValidationError":{"properties":{"loc":{"items":{"anyOf":[{"type":"string"},{"type":"integer"}]},"type":"array","title":"Location"},"msg":{"type":"string","title":"Message"},"type":{"type":"string","title":"Error Type"},"input":{"title":"Input"},"ctx":{"type":"object","title":"Context"}},"type":"object","required":["loc","msg","type"],"title":"ValidationError"}}}}
```


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.jua.ai/api-v2/query-engine/open-api-reference/eex-power.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.