Data / Wholesale power · Germany

Power prices & negative hours

Every hour of the German day-ahead market since the DE-LU bidding zone began in October 2018: 71,305 hourly prices with generation and load. See when power is cheap, how often it is negative, and what solar, wind and batteries earn. Every view can be shared as a link or downloaded as CSV.

Source
SMARD, Bundesnetzagentur
Data to
18 Nov 2026
Coverage
Day-ahead DE-LU · Oct 2018 – today · 39,748 quarter-hours since Oct 2025
Refresh
Daily, automatic

Open data: Download these tables (Parquet, CSV) on Hugging Face

Key insights · 18 Nov 2026

What the prices say

  • Negative prices · 2025576 h

    Hours with a negative day-ahead price in 2025, up from 457 in 2024. 2026 so far: 475 h, against 576 h by the same date last year.

    See negative hours →
  • Solar capture rate · 202552%

    Solar earned 52% of the average price in 2025 (46 vs 89 EUR/MWh), down from 78% in 2021. Onshore wind kept 87%.

    See capture prices →
  • Duck curve · Apr–Sep 2025126 €

    Gap per MWh between the evening peak (19–21 h, 139 EUR/MWh) and midday (12–14 h, 14 EUR/MWh) in the sunny half of 2025. This gap is what batteries and flexible demand earn.

    See prices by hour →
  • Daily spread · 2025100 €/MWh

    Average gap between the 4 most expensive and the 4 cheapest hours of each day in 2025, against 89 in 2024: the day-ahead room for a 2-hour battery cycling once a day, before losses and fees.

    See spreads →

Explorer

Slice the market

Loading the price data…

Method

How these numbers are built

  1. Pull

    Every day, after the day-ahead auction, a scheduled job reads SMARD’s published series: the day-ahead price of the DE-LU bidding zone (hourly since Oct 2018, quarter-hourly since 1 Oct 2025), realised net generation by source, grid load and residual load. It recomputes the whole history each time, so corrections apply everywhere.

  2. Hours

    All hours are in local time (Europe/Berlin), so a day has 23 or 25 hours at the clock change. Since the 15-minute market, the hourly price is the mean of the four quarter-hours, computed from the unrounded quarter-hour prices (SMARD rounds its hourly mean to the cent, which hides prices like −0.0025 €/MWh).

  3. Measures

    Baseload = mean of all hours; peakload = mean of 08:00–20:00 on weekdays. Capture price = Σ(generation × price) ÷ Σ generation, per technology. Daily spread = mean of the 4 most expensive minus the 4 cheapest hours of each day.

  4. Validate

    Annual average prices and negative-hour counts for 2021–2025 match Fraunhofer ISE’sEnergy-Charts exactly (e.g. 457 negative hours in 2024,576 in 2025). Our 2025 capture prices against the official EEG annual market values (Netztransparenz): solar 4.61 vs 4.51 ct/kWh, onshore wind7.73 vs 7.44, offshore8.55 vs 8.06. The official values weight prices with the TSOs’ feed-in projections, ours with SMARD realised generation; use the official ones for EEG settlement.

Data: Bundesnetzagentur | SMARD.de, licensed under CC BY 4.0(terms). Generation data runs a few hours behind prices. Latest complete year: 2025 (baseload 89.32 EUR/MWh, solar capture rate 52%). Script: scripts/data/smard_prices.py. Built 2026-11-17.

Glossary

What the labels mean

Day-ahead market
The day-ahead auction (EPEX SPOT and other exchanges, coupled across Europe) sets one price per hour (per quarter-hour since 1 Oct 2025) for the next day. It is the reference price for most power contracts.
Baseload
Baseload price: the average day-ahead price over all hours of the period (EUR/MWh).
Peakload
Peakload price: the average over 08:00–20:00 on weekdays (EEX definition). Not defined for weekends.
Negative hours
Hours in which the day-ahead price of the DE-LU bidding zone was below zero. Since 1 Oct 2025 the price is set per quarter-hour; an hour counts as negative when the mean of its four quarter-hours is below zero.
Zero-price hours
Hours with a price of exactly zero. Often caused by renewables bidding at zero.
Capture price and rate
Capture price: what a technology earned on the day-ahead market, i.e. the average price weighted by its hourly generation. Capture rate = capture price ÷ baseload price. A falling solar capture rate is cannibalisation: solar produces when prices are lowest.
Daily spread
Daily spread: the average price of the 4 most expensive hours minus the 4 cheapest hours of each day, averaged over the period. A simple proxy for what a 2-hour battery cycling once a day could earn on the day-ahead market (before losses and fees).
Price duration curve
A price duration curve sorts every hour of a year from the most expensive to the cheapest. The point where it crosses zero is the share of hours with negative prices.
Generation share
Share of net public generation (excluding pumped-storage generation), from SMARD realised generation.
Official market values
Official EEG market values (Marktwerte) are calculated by the TSOs on their own feed-in projections. Our capture prices use SMARD realised generation, so they can differ by a few percent.