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.
API token from the Joulo dashboard, or an OAuth2 access token.
In: header
Query Parameters
First day (YYYY-MM-DD), from 2015-01-01. Default: one year before to.
dateLast day (YYYY-MM-DD), inclusive, at most tomorrow. Default: today.
datePeriod per row.
"month""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"
}