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
The newest data is days old. This dataset normally refreshes within 3 days, so the automatic refresh may have stalled. Data status
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…
01
Prices over time
Average day-ahead price with the range of hourly prices. Day by day for up to a year, month by month beyond.
02
Negative and zero prices
How often the price falls to zero or below, and at what time of day.
03
Prices by hour of day
The duck curve: cheap middays when solar floods the market, expensive mornings and evenings. A dot marks an average below zero.
04
Capture prices
What solar and wind actually earned per MWh on the day-ahead market, against the baseload price.
05
Daily spreads
The gap between expensive and cheap hours each day: the room for batteries and flexible demand.
06
Price duration curves
Every hour of a year, sorted. The curve’s tail below zero grows each year. Follows the period filter.
07
Solar buildout and negative hours
Installed solar from the official register next to negative-price hours. Two measures, two charts, the same years.
08
The last five weeks
Quarter-hour prices since the 15-minute day-ahead market started, with generation and load.
09
Month by month
Every measure for each month of the period, latest first. Sort by any column.
10
Year by year
The long view since the bidding zone began.
11
Day by day
Every day of the period, the days with the most negative hours first.
Method
How these numbers are built
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.
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).
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.
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.