# Finnish day-ahead electricity price statistics

Covers 2025-06-15 to 2026-07-31 (9,886 hours)

Live version and methodology: https://parassahko.fi/en/statistics
Archived snapshots and their version numbers: https://doi.org/10.5281/zenodo.21701225

## What this dataset contains

Realised day-ahead electricity prices for the Finnish price area (Nord Pool FI)
and statistics derived from them, captured into ParasSähkö.fi's own database at
the time each price was published.

| File | Contents | Rows |
|---|---|---|
| `parassahko-spot-kuukausitilastot.csv` | Monthly averages, extremes and shares | 13 |
| `parassahko-spot-paivittain.csv` | Daily averages and daily extremes | 412 |
| `parassahko-spot-tuntiprofiili.csv` | Average price by hour of day, weekday and weekend | 24 |
| `parassahko-spot-tilastot.json` | All series plus metadata in one file | – |

Always-current versions: https://parassahko.fi/tilastot/data.csv ,
/paivittain.csv , /tunnit.csv and /data.json (CORS enabled).

## Columns

`parassahko-spot-kuukausitilastot.csv`

- `month` — calendar month, YYYY-MM
- `avg_snt_kwh_incl_vat` — monthly average, weighted by period duration
- `min_snt_kwh`, `max_snt_kwh` — lowest and highest single quotation in the month
- `negative_price_share_pct` — share of TIME at a negative price
- `below_1_cent_share_pct` — share of time below 1 c/kWh
- `hours_covered` — hours the data covers in that month

`parassahko-spot-paivittain.csv`

- `day` — Finnish calendar day, YYYY-MM-DD
- `avg_snt_kwh_incl_vat` — daily average, weighted by period duration
- `min_snt_kwh`, `max_snt_kwh` — lowest and highest quotation that day
- `hours_covered` — hours covered (24, or 23/25 on clock-change days)

`parassahko-spot-tuntiprofiili.csv`

- `hour` — local hour 0–23 (Europe/Helsinki)
- `weekday_snt_kwh_incl_vat` — average, Monday to Friday
- `weekend_snt_kwh_incl_vat` — average, Saturday and Sunday
- `all_snt_kwh_incl_vat` — average across the whole series
- An empty cell means no observations. **Zero is a price, not missing data.**

CSV files use a dot as the decimal separator and a comma as the field separator.
Prices are in cents per kWh (snt/kWh in the column names).

## Method and limitations

**VAT.** All prices include Finnish VAT at 25.5 %. Electricity transmission and
electricity tax are NOT included, because they are not set on the exchange.

**Weighting.** Averages are weighted by period duration, because the series
contains both hourly and quarter-hourly periods: an unweighted mean would give a
quarter-hour four times the weight of an hour.

**Resolution, and its limitation.** Day-ahead prices have been quoted in
15-minute periods since 1 October 2025 (Nord Pool, an EU-wide change). The price
API this dataset draws on continued to serve hourly values until 14 June 2026, so
this series is hourly up to that date and quarter-hourly from 15 June 2026
onwards. Sub-hourly prices therefore existed for eight months that this dataset
cannot see, and they cannot be backfilled: the API's history endpoint offers
hourly values only.

**Time zone.** Months, days and hours are computed in Finnish local time
(Europe/Helsinki), so daylight saving is accounted for.

**Whole months only.** The monthly file contains complete calendar months only: a
part-month average is not comparable with a full one.

**Whole days only.** The daily file ends at the last complete day. Nord Pool's
delivery day runs 00-24 Central European Time, an hour behind Finnish time, so the
newest delivery day always extends one hour into the next Finnish calendar day. One
hour is not a daily average and is not published as one.

**Known gaps.** Some periods are missing from these days. The average is computed from the
periods that are present, and the `hours_covered` column states how many. The known
causes are the repeated hour at the autumn clock change and the price API's
resolution switch on 15 June 2026. Day length is read from the calendar, so the
23-hour spring clock-change day is not a gap.

| Day | Hours | Expected |
|---|---|---|
| 2025-10-26 | 24 | 25 |
| 2026-06-15 | 23 | 24 |

**Intra-hour spread** (`intraHourSpread` in the JSON) is computed only from the
quarter-hourly part of the series, and only from hours where all four quarters are
present (1,128 hours), so a partially ingested hour cannot
masquerade as a calm one.

**Contract market** (`contractMarket` in the JSON, 9 groups)
is a cross-section at capture time, not a time series. It covers comparable
products generally offered to consumers; tiered-consumption products are excluded
because their price depends on the volume consumed. **Every group is included,
single-product terms among them** (3, 15, 18 and 36 months are typically such).
The `count` field states the product count: a median and a range over fewer than
five products do not describe a market, so the website's table shows only groups of
five or more — the dataset itself withholds nothing.

**The dataset is accumulating.** It is not backfilled: the series begins when
collection started, and no earlier data exists.

## Source and licence

The underlying price source is the Nord Pool day-ahead market, Finnish price area.
The statistics published here are derivatives computed by ParasSähkö.fi.

Licence: Creative Commons Attribution 4.0 International (CC BY 4.0). Free to use,
including commercially, provided the source is credited.

## Citation

    Pasanen, I. (2026). Suomen pörssisähkön hintatilastot (Finnish day-ahead
    electricity price statistics) [Data set]. Zenodo.
    https://doi.org/10.5281/zenodo.21701225

Contact: info@parassahko.fi