JouloDocs
Api referenceEnergy

Get the EPEX price history since 2015

The bare EPEX day-ahead electricity price of the Netherlands since 1 January 2015, per hour, day, month or year, in euro per kWh. It excludes VAT, energy tax and the supplier markup, because those changed over the years. For what a dynamic contract costs on one day, use /prices. Each row follows columns: the time-weighted average, the lowest and highest slot, the hours with a negative price, and the hours with a price. summary covers the whole window. Buckets and dates are Amsterdam time, and to is inclusive. With hour the window is at most 92 days, with day at most ten years. Source: EPEX via the ENTSO-E Transparency Platform. The data is the same for everyone, so any personal token may read it.

GET
/prices/history
AuthorizationBearer <token>

API token from the Joulo dashboard, or an OAuth2 access token.

In: header

Query Parameters

from?string

First day (YYYY-MM-DD), from 2015-01-01. Default: one year before to.

Formatdate
to?string

Last day (YYYY-MM-DD), inclusive, at most tomorrow. Default: today.

Formatdate
bucket?string

Period per row.

Default"month"
Value in"hour" | "day" | "month" | "year"

Response Body

curl -X GET "https://api.joulo.nl/functions/v1/api/prices/history?from=2025-01-01&to=2025-12-31&bucket=hour"
{
  "source": "EPEX day-ahead via ENTSO-E Transparency Platform, bidding zone NL",
  "unit": "EUR/kWh excl. VAT, energy tax and supplier markup",
  "timezone": "Europe/Amsterdam",
  "bucket": "year",
  "from": "2022-01-01",
  "to": "2023-12-31",
  "count": 2,
  "summary": {
    "average_eur_per_kwh": 0.18456,
    "hours_with_price": 17520,
    "negative_hours": 329,
    "lowest": {
      "time_local": "2023-07-02 14:00",
      "eur_per_kwh": -0.5
    },
    "highest": {
      "time_local": "2022-08-29 19:00",
      "eur_per_kwh": 0.871
    }
  },
  "columns": [
    "period_start_local",
    "average_eur_per_kwh",
    "lowest_eur_per_kwh",
    "highest_eur_per_kwh",
    "negative_hours",
    "hours_with_price"
  ],
  "rows": [
    [
      "2022-01-01",
      0.24237,
      -0.0105,
      0.871,
      85,
      8760
    ],
    [
      "2023-01-01",
      0.09674,
      -0.5,
      0.4893,
      244,
      8760
    ]
  ],
  "available": {
    "first_local": "2015-01-01 00:00",
    "last_local": "2026-10-29 23:45"
  }
}
{
  "error": "window_too_long",
  "detail": "With bucket hour the window is at most 92 days."
}
{
  "error": "Missing or invalid API token"
}