Microproduct data guideintermediate

ECB Statistical Data Warehouse

Euro-area official statistics on exchange rates, prices, and monetary aggregates for building policy-rate and inflation monitors.

Start the guide Open official source

At a glance

Difficulty
Intermediate — some data preparation helps
Size
Medium · ≤1 GB
Formats
JSON, CSV, SDMX
Access
API or Download
API key
Not required
Provider
European Central Bank
Updates
Daily
Data terms
ECB copyright and reuse notice

From source to product signal

Test a product idea in four steps

The ECB SDMX 2.1 API returns official euro-area statistics. Start with one exchange-rate series and a short observation window. Series keys are dense, vintages can be revised, and a rate observation is not a trading signal.

1

Check the setup

  • Python 3.10 or newer
  • A notebook environment such as Jupyter or Google Colab
  • An internet connection
2

Access the data

  1. 1.Open the ECB Data Portal and the SDMX web-service help.
  2. 2.Request the last ten daily USD/EUR reference rates.
  3. 3.Keep the series key, observation date, and value.
Open official source
3

Run the Python example

Install the packages, then run the notebook cell.

python -m pip install pandas requests

import pandas as pd
import requests

response = requests.get(
    "https://data-api.ecb.europa.eu/service/data/EXR/D.USD.EUR.SP00.A",
    params={"lastNObservations": 10, "format": "jsondata"},
    headers={"Accept": "application/json"},
    timeout=30,
)
response.raise_for_status()
payload = response.json()
series = payload["dataSets"][0]["series"]
observations = next(iter(series.values()))["observations"]
dates = payload["structure"]["dimensions"]["observation"][0]["values"]
rows = [
    {"date": dates[int(index)]["id"], "usd_per_eur": value[0]}
    for index, value in observations.items()
]
rates = pd.DataFrame(rows)
print(rates)
4

Test a useful signal

Chart recent USD per EUR reference rates

Test whether one ECB series can power a bounded FX monitor.

  1. 01Keep observation dates and USD-per-EUR values from the EXR dataflow.
  2. 02Plot the last ten daily observations and record the series key.
  3. 03Explain that ECB reference rates are not transaction prices and can be revised.

Dataset details

European Central Bank is an intergovernmental source. Last verified 2026-08-18. Temporal coverage: euro-area series with varying starts.

Theme

Markets & Economics

Domains

MacroeconomicsFinanceInternational Statistics

Data types

Time Series

Tasks

Trend AnalysisPolicy MonitoringMarket Research

Geography

Europe

Formats

JSONCSVSDMX

Provider

European Central Bank

Data terms

ECB copyright and reuse notice