Cleaned open data, ready to query.

import duckdb

# one row per zone per hour, UTC - already clean
duckdb.sql("""
  SELECT zone, date_trunc('month', ts) AS m,
         avg(price_eur_mwh) AS avg_price
  FROM   'european-day-ahead-prices.parquet'
  GROUP  BY 1, 2 ORDER BY 1, 2
""")
# → 40 bidding zones · 2017-2026 · 4.3M rows · no parsing

# owners & All-Access: automate it in one curl - conditional download
curl -sfO --etag-compare etag.txt --etag-save etag.txt \
     -H "Authorization: Bearer rs_live_…" \
     https://getreadyset.app/api/v1/download/european-day-ahead-prices
# 200 → fresh build streamed · 304 Not Modified → 0 bytes, nothing re-pulled