> For the complete documentation index, see [llms.txt](https://docs.jua.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.jua.ai/api-v2/query-engine/open-api-reference/epex-spot.md).

# Epex Spot

## Query EPEX SPOT market data

> Query EPEX SPOT electricity market data including:\
> \- Intraday continuous prices (VWAP, last, low, high) and volumes\
> \- Intraday continuous price indices: IDFULL (full session), ID1 (last 1h\
> &#x20; before delivery), ID3 (last 3h before delivery) — all at 60-minute resolution\
> \- Day-ahead auction clearing prices and volumes (quarter-hourly)\
> \- Intraday auction (IDA1/IDA2/IDA3) prices and volumes\
> \- Day-ahead official index prices\
> \
> \*\*Response Formats:\*\*\
> \- \`json\`: Columnar JSON format \`{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":[],"servers":[{"url":"https://query.jua.ai","description":"Production"}],"security":[{"HTTPBearer":[]}],"paths":{"/v1/epex-spot/data":{"post":{"tags":["epex-spot"],"summary":"Query EPEX SPOT market data","description":"Query EPEX SPOT electricity market data including:\n- Intraday continuous prices (VWAP, last, low, high) and volumes\n- Intraday continuous price indices: IDFULL (full session), ID1 (last 1h\n  before delivery), ID3 (last 3h before delivery) — all at 60-minute resolution\n- Day-ahead auction clearing prices and volumes (quarter-hourly)\n- Intraday auction (IDA1/IDA2/IDA3) prices and volumes\n- Day-ahead official index prices\n\n**Response Formats:**\n- `json`: Columnar JSON format `{column: [values], ...}`\n- `arrow`: Apache Arrow IPC stream for efficient processing\n\n**Authentication**: Requires API key.","operationId":"post_epex_spot_data_v1_epex_spot_data_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'"},{"name":"include_units","in":"query","required":false,"schema":{"type":"boolean","description":"When true, JSON responses are wrapped in {data, units}.","default":false,"title":"Include Units"},"description":"When true, JSON responses are wrapped in {data, units}."}],"requestBody":{"required":true,"content":{"application/json":{"schema":{"$ref":"#/components/schemas/EpexSpotTimeseriesQuery"}}}},"responses":{"200":{"description":"Successfully retrieved EPEX SPOT 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":{"EpexSpotTimeseriesQuery":{"properties":{"variables":{"anyOf":[{"items":{"$ref":"#/components/schemas/EpexSpotVariable"},"type":"array"},{"type":"null"}],"title":"Variables","description":"Variables to query. If not set, returns all."},"start_time":{"type":"string","format":"date-time","title":"Start Time","description":"Start time for the query (inclusive, filters on delivery_start)"},"end_time":{"anyOf":[{"type":"string","format":"date-time"},{"type":"null"}],"title":"End Time","description":"End time for the query (exclusive). If None, no upper bound."},"market_area":{"anyOf":[{"type":"string"},{"type":"null"}],"title":"Market Area","description":"Market area filter (e.g. 'DE', 'GB'). Defaults to DE so GB GBP rows cannot mix with DE EUR. v2 public serving is DE and DE-LU; GB is internal-only. v1 serves DE and DE-LU only. Other-provider codes are ignored.","default":"DE"},"time_zone":{"anyOf":[{"type":"string"},{"type":"null"}],"title":"Time Zone","description":"IANA time zone for time formatting (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. 'delivery_start__desc')."},"pagination":{"anyOf":[{"$ref":"#/components/schemas/Pagination"},{"type":"null"}],"description":"Pagination parameters"}},"type":"object","required":["start_time"],"title":"EpexSpotTimeseriesQuery","description":"Query parameters for EPEX SPOT market data.\n\nEach variable maps to a specific ClickHouse table and column.\nThe query builder generates the appropriate SQL UNION for variables\nspanning different tables."},"EpexSpotVariable":{"type":"string","enum":["continuous_weighted_avg_price","continuous_last_price","continuous_low_price","continuous_high_price","continuous_volume_buy","continuous_volume_sell","continuous_index_price","continuous_idfull_price","continuous_id1_price","continuous_id3_price","da_price","ida1_price","ida2_price","ida3_price","da_volume","ida1_volume","ida2_volume","ida3_volume","da_index_price","da_hourly_price","da_hourly_volume"],"title":"EpexSpotVariable","description":"EPEX SPOT user-facing variable types."},"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","minimum":0,"title":"Limit","default":100},"offset":{"type":"integer","minimum":0,"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 EPEX SPOT intraday continuous individual trades

> Query row-level intraday continuous trades from EPEX SPOT.\
> \
> Each row is a single executed trade (price, volume, side, delivery area,\
> trade phase, execution time). This dataset is high-volume (\~1.2M trades/day\
> for Germany), so requests are capped per response format and will return\
> HTTP 400 if too large — narrow the delivery-date / execution-time range, add\
> filters, or paginate.\
> \
> \*\*Filters:\*\* market\_area, delivery\_areas, sides, products, trade\_phases,\
> execution-time window (start\_time/end\_time), delivery-date window\
> (delivery\_date\_start/delivery\_date\_end).\
> \
> \*\*Response Formats:\*\* \`json\` (columnar) or \`arrow\` (IPC stream).\
> \
> \*\*Authentication\*\*: Requires API key.

```json
{"openapi":"3.1.0","info":{"title":"Jua Query Engine API","version":"0.1.0"},"tags":[],"servers":[{"url":"https://query.jua.ai","description":"Production"}],"security":[{"HTTPBearer":[]}],"paths":{"/v1/epex-spot/trades":{"post":{"tags":["epex-spot"],"summary":"Query EPEX SPOT intraday continuous individual trades","description":"Query row-level intraday continuous trades from EPEX SPOT.\n\nEach row is a single executed trade (price, volume, side, delivery area,\ntrade phase, execution time). This dataset is high-volume (~1.2M trades/day\nfor Germany), so requests are capped per response format and will return\nHTTP 400 if too large — narrow the delivery-date / execution-time range, add\nfilters, or paginate.\n\n**Filters:** market_area, delivery_areas, sides, products, trade_phases,\nexecution-time window (start_time/end_time), delivery-date window\n(delivery_date_start/delivery_date_end).\n\n**Response Formats:** `json` (columnar) or `arrow` (IPC stream).\n\n**Authentication**: Requires API key.","operationId":"post_epex_spot_trades_v1_epex_spot_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/EpexSpotTradesQuery"}}}},"responses":{"200":{"description":"Successfully retrieved EPEX SPOT trades","content":{"application/json":{"schema":{}},"application/vnd.apache.arrow.stream":{"description":"Apache Arrow IPC stream format"}}},"400":{"description":"Invalid query parameters or response too large"},"401":{"description":"Authentication required"},"422":{"description":"Validation Error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/HTTPValidationError"}}}}}}}},"components":{"schemas":{"EpexSpotTradesQuery":{"properties":{"market_area":{"anyOf":[{"type":"string"},{"type":"null"}],"title":"Market Area","description":"Market area filter (e.g. 'DE', 'GB'). Defaults to DE so GB GBP rows cannot mix with DE EUR. v2 public serving is DE and DE-LU; GB is internal-only. v1 serves DE and DE-LU only. Other-provider codes are ignored.","default":"DE"},"market_areas":{"anyOf":[{"items":{"type":"string"},"type":"array"},{"type":"null"}],"title":"Market Areas","description":"Market area IN-filter. Takes precedence over market_area."},"delivery_areas":{"anyOf":[{"items":{"type":"string"},"type":"array"},{"type":"null"}],"title":"Delivery Areas","description":"Delivery area codes to filter by (e.g. ['DE1', 'DE4'])."},"sides":{"anyOf":[{"items":{"type":"string"},"type":"array"},{"type":"null"}],"title":"Sides","description":"Trade sides to filter by ('BUY' and/or 'SELL')."},"products":{"anyOf":[{"items":{"type":"string"},"type":"array"},{"type":"null"}],"title":"Products","description":"Product codes to filter by (e.g. ['XBID_Hour_Power'])."},"trade_phases":{"anyOf":[{"items":{"type":"string"},"type":"array"},{"type":"null"}],"title":"Trade Phases","description":"Trade phases to filter by (e.g. ['CONT'])."},"start_time":{"anyOf":[{"type":"string","format":"date-time"},{"type":"null"}],"title":"Start Time","description":"Start execution time (inclusive, filters on execution_time)."},"end_time":{"anyOf":[{"type":"string","format":"date-time"},{"type":"null"}],"title":"End Time","description":"End execution time (exclusive, filters on execution_time)."},"delivery_date_start":{"anyOf":[{"type":"string","format":"date"},{"type":"null"}],"title":"Delivery Date Start","description":"Start delivery date (inclusive). EPEX CET/CEST trading day (Europe/Berlin, including GB), not a UTC calendar date."},"delivery_date_end":{"anyOf":[{"type":"string","format":"date"},{"type":"null"}],"title":"Delivery Date End","description":"End delivery date (inclusive). EPEX CET/CEST trading day (Europe/Berlin, including GB), not a UTC calendar date."},"delivery_start_from":{"anyOf":[{"type":"string","format":"date-time"},{"type":"null"}],"title":"Delivery Start From","description":"Inclusive lower bound on delivery_start (UTC)."},"delivery_start_to":{"anyOf":[{"type":"string","format":"date-time"},{"type":"null"}],"title":"Delivery Start To","description":"Exclusive upper bound on delivery_start (UTC)."},"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. 'execution_time__desc')."},"pagination":{"anyOf":[{"$ref":"#/components/schemas/Pagination"},{"type":"null"}],"description":"Pagination parameters (requires order_by)."},"keyset_after":{"anyOf":[{"additionalProperties":true,"type":"object"},{"type":"null"}],"title":"Keyset After","description":"Exclusive lower bound for keyset pagination matching the v2 total order (market_area, execution_time, delivery_date, trade_id, side, delivery_area). When set, OFFSET is ignored."}},"type":"object","title":"EpexSpotTradesQuery","description":"Query parameters for EPEX SPOT intraday continuous individual trades.\n\nFetches row-level trades from ``epex_spot_continuous_trades``. Filter by\nmarket area, delivery area, side, product, trade phase, a trade-execution\ntime window, and/or a delivery-date window. ``delivery_date`` is the table's\nprimary-index / partition key, so a ``delivery_date_*`` filter is the\ncheapest way to scope a query."},"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","minimum":0,"title":"Limit","default":100},"offset":{"type":"integer","minimum":0,"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 EPEX SPOT aggregated supply/demand curves

> Query EPEX SPOT Day-Ahead aggregated supply/demand curves (full order-book\
> step curves). Each delivery period contains many price/volume points per side\
> (Sell = supply, Purchase = demand), so this returns a row-shaped result rather\
> than a scalar timeseries.\
> \
> Responses can be large; use \`pagination\` (with \`order\_by\`) or a narrow time\
> window to bound the result.\
> \
> \*\*Authentication\*\*: Requires API key.

```json
{"openapi":"3.1.0","info":{"title":"Jua Query Engine API","version":"0.1.0"},"tags":[],"servers":[{"url":"https://query.jua.ai","description":"Production"}],"security":[{"HTTPBearer":[]}],"paths":{"/v1/epex-spot/auction-curves":{"post":{"tags":["epex-spot"],"summary":"Query EPEX SPOT aggregated supply/demand curves","description":"Query EPEX SPOT Day-Ahead aggregated supply/demand curves (full order-book\nstep curves). Each delivery period contains many price/volume points per side\n(Sell = supply, Purchase = demand), so this returns a row-shaped result rather\nthan a scalar timeseries.\n\nResponses can be large; use `pagination` (with `order_by`) or a narrow time\nwindow to bound the result.\n\n**Authentication**: Requires API key.","operationId":"post_epex_spot_auction_curves_v1_epex_spot_auction_curves_post","requestBody":{"content":{"application/json":{"schema":{"$ref":"#/components/schemas/EpexSpotCurveQuery"}}},"required":true},"responses":{"200":{"description":"Successful Response","content":{"application/json":{"schema":{"$ref":"#/components/schemas/AuctionCurvesResult"}}}},"400":{"description":"Invalid query parameters"},"401":{"description":"Authentication required"},"422":{"description":"Validation Error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/HTTPValidationError"}}}}}}}},"components":{"schemas":{"EpexSpotCurveQuery":{"properties":{"start_time":{"type":"string","format":"date-time","title":"Start Time","description":"Start time (inclusive, filters on delivery_start)."},"end_time":{"anyOf":[{"type":"string","format":"date-time"},{"type":"null"}],"title":"End Time","description":"End time (exclusive). If None, no upper bound."},"market_area":{"anyOf":[{"type":"string"},{"type":"null"}],"title":"Market Area","description":"Market area filter (e.g. 'DE', 'GB'). Defaults to DE so GB GBP rows cannot mix with DE EUR. v2 public serving is DE and DE-LU; GB is internal-only. v1 serves DE and DE-LU only. Other-provider codes are ignored.","default":"DE"},"market_areas":{"anyOf":[{"items":{"type":"string"},"type":"array"},{"type":"null"}],"title":"Market Areas","description":"Market area IN-filter. Takes precedence over market_area."},"auction":{"anyOf":[{"type":"string"},{"type":"null"}],"title":"Auction","description":"Auction filter (e.g. 'DA')."},"auctions":{"anyOf":[{"items":{"type":"string"},"type":"array"},{"type":"null"}],"title":"Auctions","description":"Auction IN-filter. Takes precedence over auction."},"area_auctions":{"anyOf":[{"items":{"prefixItems":[{"type":"string"},{"type":"string"}],"type":"array","maxItems":2,"minItems":2},"type":"array"},{"type":"null"}],"title":"Area Auctions","description":"Per-area (market_area, auction) pairs. When set, binds (market_area, auction) IN and skips the independent auction predicate. Rejects an empty list — ClickHouse IN [] is invalid."},"resolution":{"anyOf":[{"type":"string","enum":["PT15M","PT30M","PT60M"]},{"type":"null"}],"title":"Resolution","description":"Resolution filter: PT15M, PT30M, or PT60M."},"resolutions":{"anyOf":[{"items":{"type":"string","enum":["PT15M","PT30M","PT60M"]},"type":"array"},{"type":"null"}],"title":"Resolutions","description":"Resolution IN-filter. Takes precedence over resolution."},"time_zone":{"anyOf":[{"type":"string"},{"type":"null"}],"title":"Time Zone","description":"IANA time zone for delivery_start/_end formatting."},"pagination":{"anyOf":[{"$ref":"#/components/schemas/Pagination"},{"type":"null"}],"description":"Pagination parameters (requires order_by)."},"keyset_after":{"anyOf":[{"additionalProperties":true,"type":"object"},{"type":"null"}],"title":"Keyset After","description":"Exclusive keyset lower bound; when set, OFFSET is ignored."},"side":{"anyOf":[{"type":"string","enum":["Sell","Purchase"]},{"type":"null"}],"title":"Side","description":"Curve side filter: Sell (supply) or Purchase (demand)."},"sides":{"anyOf":[{"items":{"type":"string","enum":["Sell","Purchase"]},"type":"array"},{"type":"null"}],"title":"Sides","description":"Curve side IN-filter. Takes precedence over side."},"order_by":{"anyOf":[{"items":{"$ref":"#/components/schemas/OrderByItem_str_"},"type":"array"},{"type":"null"}],"title":"Order By","description":"Columns to order by (e.g. 'delivery_start', 'point_index__desc')."}},"type":"object","required":["start_time"],"title":"EpexSpotCurveQuery","description":"Query for EPEX SPOT aggregated supply/demand curves."},"Pagination":{"properties":{"limit":{"type":"integer","minimum":0,"title":"Limit","default":100},"offset":{"type":"integer","minimum":0,"title":"Offset","default":0}},"type":"object","title":"Pagination"},"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."},"AuctionCurvesResult":{"properties":{"data":{"items":{"$ref":"#/components/schemas/CurvePoint"},"type":"array","title":"Data"}},"type":"object","required":["data"],"title":"AuctionCurvesResult","description":"Result for an aggregated-curves query."},"CurvePoint":{"properties":{"delivery_start":{"type":"string","format":"date-time","title":"Delivery Start"},"delivery_end":{"type":"string","format":"date-time","title":"Delivery End"},"market_area":{"type":"string","title":"Market Area"},"auction":{"type":"string","title":"Auction"},"resolution":{"type":"string","title":"Resolution"},"side":{"type":"string","title":"Side"},"point_index":{"type":"integer","title":"Point Index"},"price":{"type":"number","title":"Price"},"volume":{"type":"number","title":"Volume"}},"type":"object","required":["delivery_start","delivery_end","market_area","auction","resolution","side","point_index","price","volume"],"title":"CurvePoint","description":"A single point of an aggregated supply/demand curve."},"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 EPEX SPOT block bids

> Query EPEX SPOT Day-Ahead block bids (normalized long: one row per block per\
> delivery period, non-zero volumes only).\
> \
> Use \`pagination\` (with \`order\_by\`) or a narrow time window to bound the result.\
> \
> \*\*Authentication\*\*: Requires API key.

```json
{"openapi":"3.1.0","info":{"title":"Jua Query Engine API","version":"0.1.0"},"tags":[],"servers":[{"url":"https://query.jua.ai","description":"Production"}],"security":[{"HTTPBearer":[]}],"paths":{"/v1/epex-spot/block-bids":{"post":{"tags":["epex-spot"],"summary":"Query EPEX SPOT block bids","description":"Query EPEX SPOT Day-Ahead block bids (normalized long: one row per block per\ndelivery period, non-zero volumes only).\n\nUse `pagination` (with `order_by`) or a narrow time window to bound the result.\n\n**Authentication**: Requires API key.","operationId":"post_epex_spot_block_bids_v1_epex_spot_block_bids_post","requestBody":{"content":{"application/json":{"schema":{"$ref":"#/components/schemas/EpexSpotBlockBidQuery"}}},"required":true},"responses":{"200":{"description":"Successful Response","content":{"application/json":{"schema":{"$ref":"#/components/schemas/AuctionBlockBidsResult"}}}},"400":{"description":"Invalid query parameters"},"401":{"description":"Authentication required"},"422":{"description":"Validation Error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/HTTPValidationError"}}}}}}}},"components":{"schemas":{"EpexSpotBlockBidQuery":{"properties":{"start_time":{"type":"string","format":"date-time","title":"Start Time","description":"Start time (inclusive, filters on delivery_start)."},"end_time":{"anyOf":[{"type":"string","format":"date-time"},{"type":"null"}],"title":"End Time","description":"End time (exclusive). If None, no upper bound."},"market_area":{"anyOf":[{"type":"string"},{"type":"null"}],"title":"Market Area","description":"Market area filter (e.g. 'DE', 'GB'). Defaults to DE so GB GBP rows cannot mix with DE EUR. v2 public serving is DE and DE-LU; GB is internal-only. v1 serves DE and DE-LU only. Other-provider codes are ignored.","default":"DE"},"market_areas":{"anyOf":[{"items":{"type":"string"},"type":"array"},{"type":"null"}],"title":"Market Areas","description":"Market area IN-filter. Takes precedence over market_area."},"auction":{"anyOf":[{"type":"string"},{"type":"null"}],"title":"Auction","description":"Auction filter (e.g. 'DA')."},"auctions":{"anyOf":[{"items":{"type":"string"},"type":"array"},{"type":"null"}],"title":"Auctions","description":"Auction IN-filter. Takes precedence over auction."},"area_auctions":{"anyOf":[{"items":{"prefixItems":[{"type":"string"},{"type":"string"}],"type":"array","maxItems":2,"minItems":2},"type":"array"},{"type":"null"}],"title":"Area Auctions","description":"Per-area (market_area, auction) pairs. When set, binds (market_area, auction) IN and skips the independent auction predicate. Rejects an empty list — ClickHouse IN [] is invalid."},"resolution":{"anyOf":[{"type":"string","enum":["PT15M","PT30M","PT60M"]},{"type":"null"}],"title":"Resolution","description":"Resolution filter: PT15M, PT30M, or PT60M."},"resolutions":{"anyOf":[{"items":{"type":"string","enum":["PT15M","PT30M","PT60M"]},"type":"array"},{"type":"null"}],"title":"Resolutions","description":"Resolution IN-filter. Takes precedence over resolution."},"time_zone":{"anyOf":[{"type":"string"},{"type":"null"}],"title":"Time Zone","description":"IANA time zone for delivery_start/_end formatting."},"pagination":{"anyOf":[{"$ref":"#/components/schemas/Pagination"},{"type":"null"}],"description":"Pagination parameters (requires order_by)."},"keyset_after":{"anyOf":[{"additionalProperties":true,"type":"object"},{"type":"null"}],"title":"Keyset After","description":"Exclusive keyset lower bound; when set, OFFSET is ignored."},"execution":{"anyOf":[{"type":"string","enum":["Y","N"]},{"type":"null"}],"title":"Execution","description":"Execution flag filter: Y or N."},"order_by":{"anyOf":[{"items":{"$ref":"#/components/schemas/OrderByItem_str_"},"type":"array"},{"type":"null"}],"title":"Order By","description":"Columns to order by (e.g. 'delivery_start', 'block_id')."}},"type":"object","required":["start_time"],"title":"EpexSpotBlockBidQuery","description":"Query for EPEX SPOT block bids."},"Pagination":{"properties":{"limit":{"type":"integer","minimum":0,"title":"Limit","default":100},"offset":{"type":"integer","minimum":0,"title":"Offset","default":0}},"type":"object","title":"Pagination"},"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."},"AuctionBlockBidsResult":{"properties":{"data":{"items":{"$ref":"#/components/schemas/BlockBid"},"type":"array","title":"Data"}},"type":"object","required":["data"],"title":"AuctionBlockBidsResult","description":"Result for a block-bids query."},"BlockBid":{"properties":{"delivery_date":{"type":"string","format":"date","title":"Delivery Date"},"delivery_start":{"type":"string","format":"date-time","title":"Delivery Start"},"delivery_end":{"type":"string","format":"date-time","title":"Delivery End"},"market_area":{"type":"string","title":"Market Area"},"auction":{"type":"string","title":"Auction"},"resolution":{"type":"string","title":"Resolution"},"block_id":{"type":"string","title":"Block Id"},"block_type":{"type":"string","title":"Block Type"},"block_code_prm":{"type":"string","title":"Block Code Prm"},"execution":{"type":"string","title":"Execution"},"limit_price":{"type":"number","title":"Limit Price"},"volume":{"type":"number","title":"Volume"},"currency":{"type":"string","title":"Currency"}},"type":"object","required":["delivery_date","delivery_start","delivery_end","market_area","auction","resolution","block_id","block_type","block_code_prm","execution","limit_price","volume","currency"],"title":"BlockBid","description":"A single (block, delivery period) bid row."},"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 EPEX SPOT variables

> Get a list of available EPEX SPOT variables with metadata including:\
> \- Variable name\
> \- Description\
> \- Unit of measurement\
> \- Source table\
> \
> \*\*Authentication\*\*: Requires API key.

```json
{"openapi":"3.1.0","info":{"title":"Jua Query Engine API","version":"0.1.0"},"tags":[],"servers":[{"url":"https://query.jua.ai","description":"Production"}],"security":[{"HTTPBearer":[]}],"paths":{"/v1/epex-spot/variables":{"get":{"tags":["epex-spot"],"summary":"List available EPEX SPOT variables","description":"Get a list of available EPEX SPOT variables with metadata including:\n- Variable name\n- Description\n- Unit of measurement\n- Source table\n\n**Authentication**: Requires API key.","operationId":"get_epex_spot_variables_v1_epex_spot_variables_get","responses":{"200":{"description":"Successful Response","content":{"application/json":{"schema":{"$ref":"#/components/schemas/jua_query_v2__epex_spot__types__AvailableVariablesResult"}}}},"422":{"description":"Validation Error","content":{"application/json":{"schema":{"$ref":"#/components/schemas/HTTPValidationError"}}}}}}}},"components":{"schemas":{"jua_query_v2__epex_spot__types__AvailableVariablesResult":{"properties":{"variables":{"items":{"$ref":"#/components/schemas/EpexSpotVariableInfo"},"type":"array","title":"Variables"}},"type":"object","required":["variables"],"title":"AvailableVariablesResult","description":"Result for available EPEX SPOT variables query."},"EpexSpotVariableInfo":{"properties":{"name":{"type":"string","title":"Name"},"description":{"type":"string","title":"Description"},"unit":{"type":"string","title":"Unit"},"table":{"type":"string","title":"Table"}},"type":"object","required":["name","description","unit","table"],"title":"EpexSpotVariableInfo","description":"Information about an EPEX SPOT variable."},"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 the delivery-anchored continuous-trade VWAP surface

> Return the volume-weighted average price of EPEX SPOT continuous (XBID) trades,\
> self-trades excluded, per (delivery\_start, trading\_bucket), where bucket b is the 15-minute window\
> \[delivery\_start - 15\*(b+1) min, delivery\_start - 15\*b min), e.g. bucket 4 is\
> \[T-75, T-60). Trading stops at gate closure (delivery\_start minus 5 minutes), so\
> bucket 0 only covers \[T-15, T-5]. Used by the trade-recommendations PnL engine to\
> price the continuous intraday venue by execution time.\
> \
> Responses can be large (one row per delivery slot and trading bucket); use a\
> narrow time window to bound the result.\
> \
> \*\*Authentication\*\*: Requires API key.

```json
{"openapi":"3.1.0","info":{"title":"Jua Query Engine API","version":"0.1.0"},"tags":[],"servers":[{"url":"https://query.jua.ai","description":"Production"}],"security":[{"HTTPBearer":[]}],"paths":{"/v1/epex-spot/continuous-vwap-surface":{"post":{"tags":["epex-spot"],"summary":"Query the delivery-anchored continuous-trade VWAP surface","description":"Return the volume-weighted average price of EPEX SPOT continuous (XBID) trades,\nself-trades excluded, per (delivery_start, trading_bucket), where bucket b is the 15-minute window\n[delivery_start - 15*(b+1) min, delivery_start - 15*b min), e.g. bucket 4 is\n[T-75, T-60). Trading stops at gate closure (delivery_start minus 5 minutes), so\nbucket 0 only covers [T-15, T-5]. Used by the trade-recommendations PnL engine to\nprice the continuous intraday venue by execution time.\n\nResponses can be large (one row per delivery slot and trading bucket); use a\nnarrow time window to bound the result.\n\n**Authentication**: Requires API key.","operationId":"post_epex_spot_continuous_vwap_surface_v1_epex_spot_continuous_vwap_surface_post","requestBody":{"content":{"application/json":{"schema":{"$ref":"#/components/schemas/ContinuousVwapSurfaceRequest"}}},"required":true},"responses":{"200":{"description":"Successful Response","content":{"application/json":{"schema":{"$ref":"#/components/schemas/ContinuousVwapSurfaceResult"}}}},"400":{"description":"Result set too large; narrow the time window"},"401":{"description":"Authentication required"},"422":{"description":"Invalid query parameters"}}}}},"components":{"schemas":{"ContinuousVwapSurfaceRequest":{"properties":{"start_time":{"type":"string","format":"date-time","title":"Start Time"},"end_time":{"type":"string","format":"date-time","title":"End Time"},"market_area":{"type":"string","title":"Market Area","default":"DE"}},"type":"object","required":["start_time","end_time"],"title":"ContinuousVwapSurfaceRequest","description":"Request body for the delivery-anchored continuous VWAP surface."},"ContinuousVwapSurfaceResult":{"properties":{"delivery_start":{"items":{"type":"string","format":"date-time"},"type":"array","title":"Delivery Start"},"bucket":{"items":{"type":"integer"},"type":"array","title":"Bucket"},"vwap":{"items":{"anyOf":[{"type":"number"},{"type":"null"}]},"type":"array","title":"Vwap"},"volume":{"items":{"anyOf":[{"type":"number"},{"type":"null"}]},"type":"array","title":"Volume"}},"type":"object","required":["delivery_start","bucket","vwap","volume"],"title":"ContinuousVwapSurfaceResult","description":"Columnar VWAP surface response: parallel lists, one entry per cell.\n\nDocumented in the OpenAPI schema so SDK / dashboard types are generated."}}}}
```


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

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

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.jua.ai/api-v2/query-engine/open-api-reference/epex-spot.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.
