DE-LU Day-Ahead Electricity Spot Prices - Hourly, 2020-01-01 to 2026-09-24 (QA-verified, CC BY 4.0, CSV+Parquet)
About this data
Machine-readable hourly day-ahead electricity spot prices for the Germany/Luxembourg bidding zone (DE-LU), 2020-01-01 to 2026-09-24 (59,015 records, UTC, EUR/MWh). Built for AI agents and API consumers: fixed schema, strictly chronological, zero gaps, zero duplicates, zero nulls, verified across every DST transition 2020-2026. Negative prices are genuine market values (min -500.00, max 936.28 EUR/MWh; 2,292 negative records), retained as-is. Full provenance per row (source, license, retrieved_at_utc), DCAT-style dataset_metadata.json, machine-readable qa_report.json, and per-file SHA-256 checksums. Source: Bundesnetzagentur | SMARD.de via the energy-charts API (Fraunhofer ISE). Free sample included (Jan 2024, 744 rows) for pre-purchase evaluation. Schema: timestamp_utc, timezone, market, zone, country, price_eur_mwh, currency, unit, source, license, retrieved_at_utc. SCOPE: DE-LU only (not complete Europe). Day-ahead spot. 2026 is partial (through 2026-09-24). Static historical snapshot retrieved 2026-09-23 UTC - no real-time feed, no guaranteed updates. GRANULARITY DISCLOSURE: through 2025-09-30 native hourly auction products; from 2025-10-01 the source moved to 15-minute auction products and this dataset keeps the on-the-hour (:00) value via a documented deterministic selection rule - NOT hourly averages, NOT hourly-native after 2025-10-01. BOUNDARY NOTE: first record 2019-12-31T23:00Z is an opening-boundary/context record only; commercial coverage starts 2020-01-01T00:00:00Z (hence 59,015 records vs 59,014 expected hours). Files in this package: full CSV (59,015 rows, 10.5MB), Parquet (0.7MB), Jan-2024 sample CSV (744 rows), README, DATA_DICTIONARY, PROVENANCE_LICENSE, dataset_metadata.json, qa_report.json, checksums.json. License: CC BY 4.0 (verbatim from source API license_info) - share and adapt including commercially, with attribution; attribution is embedded per-row in source and license columns and must be preserved on redistribution. LIMITATIONS: single-zone snapshot; no warranty of accuracy beyond performed QA; values mirror the upstream official source as retrieved; no live API/x402 endpoint - delivery is file download.
Schema
Schema not available
Sample Data
Download a free sample to inspect the data before purchasing.
$19
Fixed price
Have an API key? Use the REST API →
For AI Agents
# 1. Add to your agent's MCP config (claude_desktop_config.json or similar):
{
"mcpServers": {
"databazaar": { "command": "npx", "args": ["databazaar-mcp"] }
}
}
# 2. Your agent can then call:
search_datasets({ query: "DE-LU Day-Ahead Electricity Sp" })
// Found: 466da43d-404f-49cd-962b-88036e77bb2d
buy_now({ dataset_id: "466da43d-404f-49cd-962b-88036e77bb2d" }) // uses your saved card# Authenticate with your API key:
curl https://api.databazaar.io/datasets/466da43d-404f-49cd-962b-88036e77bb2d \
-H "Authorization: Bearer YOUR_API_KEY"
# Purchase:
curl -X POST https://api.databazaar.io/purchases \
-H "Authorization: Bearer YOUR_API_KEY" \
-H "Content-Type: application/json" \
-d '{"dataset_id": "466da43d-404f-49cd-962b-88036e77bb2d"}'