# ECB Statistical Data Warehouse Scraper (`parseforge/ecb-statistical-data-warehouse-scraper`) Actor

Scrapes ECB Statistical Data Warehouse series by dataflow, series key, and start period. Returns each observation as a flat row with dimensions and values. Export to CSV, JSON, Excel, or XML.

- **URL**: https://apify.com/parseforge/ecb-statistical-data-warehouse-scraper.md
- **Developed by:** [ParseForge](https://apify.com/parseforge) (community)
- **Categories:** Automation, Integrations, Business
- **Stats:** 2 total users, 1 monthly users, 89.7% runs succeeded, 0 bookmarks
- **User rating**: No ratings yet

## Pricing

from $7.50 / 1,000 results

This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events.
Since this Actor supports Apify Store discounts, the price gets lower the higher subscription plan you have.

Learn more: https://docs.apify.com/actors/running/actors-in-store.md#pay-per-event

## What's an Apify Actor?

Actors are web data automations that power AI and operations. They run on the Apify platform to scrape websites, process data, connect APIs, and automate workflows.
In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours,
and optionally produces a well-defined JSON output, datasets with results, or files in key-value store.
In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server.
Actors are written with capital "A".

## How to integrate an Actor?

If asked about integration, you help developers integrate Actors into their projects.
You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready.
The best way to integrate Actors is as follows.

- **AI agents and MCP clients** — the [Apify MCP server](https://docs.apify.com/integrations/mcp.md) at `https://mcp.apify.com` (remote, streamable HTTP, OAuth on first use).
- **Agentic workflows and local Actor development** — [Agent Skills](https://apify.com/.well-known/agent-skills/index.json) with the [Apify CLI](https://docs.apify.com/cli/docs.md): `npm install -g apify-cli`, then `apify login`.
- **JavaScript/TypeScript projects** — the official [JS/TS client](https://docs.apify.com/api/client/js/docs.md): `npm install apify-client`.
- **Python projects** — the official [Python client](https://docs.apify.com/api/client/python/docs.md): `pip install apify-client`.
- **Any other language** — the [REST API](https://docs.apify.com/api/v2.md).

For usage examples, see the [API](#api) section below.

For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt).

# README

[![ParseForge](https://raw.githubusercontent.com/ParseForge/apify-assets/main/banner.jpg)](https://apify.com/parseforge?fpr=vmoqkp)

### ECB Statistical Data Warehouse Scraper

**Scrape ECB Statistical Data Warehouse series by dataflow, series key, or date range.** Each run returns the full time series with observations, dimensions, and metadata. No API key or registration. Export to CSV, JSON, Excel, or XML.

The ECB Statistical Data Warehouse publishes thousands of official euro area series, but its web interface is built for browsing one chart at a time. This Actor reads the underlying SDMX data directly, so you can pull exchange rates, balance sheet items, interest rates, and other series by dataflow or series key, filtered by period, into one flat dataset.

| Who uses it | What they scrape ECB Statistical Data Warehouse for |
|---|---|
| Financial analysts | Pull daily or monthly ECB reference rates for valuation models |
| Economists | Build long-run datasets of monetary aggregates or balance of payments |
| Data engineers | Feed ECB series into internal dashboards or data warehouses |
| Researchers | Collect consistent euro area statistics for academic work |

### What it does

This Actor collects ECB Statistical Data Warehouse series by dataflow, series key, and start period, and returns each observation as a flat row with its dimensions and values.

- 🔎 **Dataflow filter:** pass an ECB dataflow id like EXR, BSI, or ICP to limit results to one dataset.
- 🔑 **Series key filter:** request a specific series such as D.USD.EUR.SP00.A for daily USD/EUR exchange rate.
- 📅 **Start period filter:** set a YYYY-MM-DD start date to retrieve only observations from that date onward.
- 📦 **Bulk collection:** set maxItems up to 1,000,000 to pull large numbers of series in a single run.

Results export to CSV, JSON, Excel, or XML, or straight from the API.

### What you can do with ECB Statistical Data Warehouse data

**💱 Track daily exchange rates.**

A financial analyst runs the Actor with series key D.USD.EUR.SP00.A to collect the daily USD/EUR reference rate for a valuation model.

**📊 Monitor monetary statistics.**

An economist pulls the BSI dataflow to build a monthly dataset of euro area bank balance sheet items.

**🏦 Feed internal dashboards.**

A data engineer schedules the Actor to collect selected ECB series and load them into a company data warehouse.

**🎓 Gather research data.**

A researcher collects long-run interest rate series by dataflow for an empirical study on monetary policy.

### Why choose this scraper

| | What you get |
|---|---|
| **Official source** | Data comes directly from the European Central Bank's Statistical Data Warehouse |
| **No API key** | No registration or authentication required |
| **Flexible filters** | Filter by dataflow, series key, or start period |
| **Flat output** | Each observation is returned as a flat row ready for analysis |
| **Bulk ready** | Collect up to 1,000,000 series per run |

### How it compares

No other Store actor targets ECB Statistical Data Warehouse the same way, so the honest comparison is with the alternatives teams actually weigh.

| | ECB Statistical Data Warehouse Scraper | Build it in-house | By hand |
|---|---|---|---|
| Setup | Run it now, zero config | Days of engineering | None, but hours per pull |
| When ECB Statistical Data Warehouse changes | Maintained for you | You fix it | You re-learn the page |
| Proxies, retries, anti-bot | Built in | Your problem | Browser only |
| Output | Fixed JSON schema, CSV/Excel export | Whatever you build | Copy-paste |
| Cost | Pay per result | Engineering time | Analyst hours |

### Configure the run

Drive the Actor from dataflow, series key, and start period, alone or together, and filters are forwarded to the ECB Statistical Data Warehouse so only matching series reach your dataset. The Input tab lists every parameter.

A first run with the defaults:

```json
{
 "maxItems": 10,
 "flow": "EXR",
 "seriesKey": "D.USD.EUR.SP00.A"
}
```

A larger pull:

```json
{
 "maxItems": 200,
 "flow": "EXR",
 "seriesKey": "D.USD.EUR.SP00.A"
}
```

### Pricing

Pay-per-result: **$0.0085 per result** collected. You pay only for the results written to your dataset.

| Results collected | Approximate cost |
|---|---|
| 100 results | $0.85 |
| 1,000 results | $8.50 |
| 10,000 results | $85.00 |

New Apify accounts start with $5 in free credit.

### Free users

Free-plan runs return up to 10 results as a preview. [Upgrade your Apify plan](https://console.apify.com/sign-up?fpr=vmoqkp) to collect up to 1,000,000 results per run.

### Run it

1. [Create a free Apify account with $5 in credit](https://console.apify.com/sign-up?fpr=vmoqkp).
2. Open the [ECB Statistical Data Warehouse Scraper](https://apify.com/parseforge/ecb-statistical-data-warehouse-scraper?fpr=vmoqkp).
3. Set your inputs and any filters, then click **Start**.
4. Export the results as CSV, Excel, JSON, or XML from the **Dataset** tab.

Run it programmatically through the [Apify API](https://docs.apify.com/api/v2) (`run-sync-get-dataset-items`) or the [ApifyClient](https://docs.apify.com/api/client/js) for JavaScript and Python.

### Use with AI agents (MCP)

Give an AI agent live access to ECB Statistical Data Warehouse through the Model Context Protocol. Add the Actor to Claude, Cursor, or any MCP client:

```bash
claude mcp add --transport http apify "https://mcp.apify.com/?tools=parseforge/ecb-statistical-data-warehouse-scraper"
```

Then prompt it in plain language to run the scraper and read back the results.

### Troubleshooting

**Why am I getting no results?**

Check that your dataflow or series key is valid. You can browse available dataflows and series keys on the ECB Statistical Data Warehouse website.

**Why are my results missing recent observations?**

Make sure the start period is not set too late. If you leave it empty, the Actor returns the full available history.

**Why did the run stop before collecting all series?**

The maxItems field limits the number of series per run. Increase it if you need more, up to 1,000,000.

**Why do I see an error about an invalid series key?**

Series keys are case-sensitive and must follow the ECB format, for example D.USD.EUR.SP00.A. Verify the key on the ECB website.

### FAQ

| Question | Answer |
|---|---|
| What is the ECB Statistical Data Warehouse? | It is the European Central Bank's online repository for euro area statistics, including exchange rates, monetary aggregates, balance of payments, and other official series. |
| Do I need an API key to use this Actor? | No. The Actor reads the public SDMX interface of the ECB Statistical Data Warehouse, so no registration or API key is required. |
| What is a dataflow? | A dataflow is an ECB dataset identifier such as EXR for exchange rates, BSI for balance sheet items, or ICP for international comparisons. You can pass one to limit results to that dataset. |
| What is a series key? | A series key uniquely identifies one statistical series, for example D.USD.EUR.SP00.A for the daily USD/EUR exchange rate. You can pass a series key to retrieve only that series. |
| How do I filter by date? | Use the start period field with a YYYY-MM-DD date. The Actor will return observations from that date onward. |
| Can I collect multiple series in one run? | Yes. If you do not specify a series key, the Actor can collect all series matching the dataflow, up to the maxItems limit. |
| What output formats are supported? | You can export the results to CSV, JSON, Excel, or XML from the Apify dataset. |
| Is the data official? | Yes. The Actor retrieves data directly from the ECB Statistical Data Warehouse, the official source for euro area statistics. |
| Can I schedule this Actor to run regularly? | Yes. You can set up a schedule in Apify to run the Actor daily, weekly, or at any interval you need. |
| What is the maximum number of series I can collect? | The maxItems field allows up to 1,000,000 series per run. |

### Related actors

Browse the full [ParseForge collection](https://apify.com/parseforge?fpr=vmoqkp) for more scrapers.

🆘 **Need help?** Email parseforge@protonmail.com with your run ID, your input, and what you expected.

⚠️ **Disclaimer.** This Actor is unofficial and is not affiliated with, endorsed by, or sponsored by European Central Bank. It collects only publicly available data. You are responsible for using the collected data in compliance with the source's terms of service and applicable data-protection laws, including GDPR, CCPA, and PIPL. Do not use it to collect personal data unlawfully.

# Actor input Schema

## `maxItems` (type: `integer`):

How many data series to collect per run.

## `flow` (type: `string`):

ECB dataflow id (e.g. EXR, BSI, ICP).

## `seriesKey` (type: `string`):

Series key (e.g. D.USD.EUR.SP00.A for USD/EUR daily).

## `startPeriod` (type: `string`):

YYYY-MM-DD.

## Actor input object example

```json
{
  "maxItems": 10,
  "flow": "EXR",
  "seriesKey": "D.USD.EUR.SP00.A"
}
```

# Actor output Schema

## `results` (type: `string`):

No description

# API

You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup.

## JavaScript example

```javascript
import { ApifyClient } from 'apify-client';

// Initialize the ApifyClient with your Apify API token
// Replace the '<YOUR_API_TOKEN>' with your token
const client = new ApifyClient({
    token: '<YOUR_API_TOKEN>',
});

// Prepare Actor input
const input = {
    "maxItems": 10,
    "flow": "EXR",
    "seriesKey": "D.USD.EUR.SP00.A"
};

// Run the Actor and wait for it to finish
const run = await client.actor("parseforge/ecb-statistical-data-warehouse-scraper").call(input);

// Fetch and print Actor results from the run's dataset (if any)
console.log('Results from dataset');
console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
const { items } = await client.dataset(run.defaultDatasetId).listItems();
items.forEach((item) => {
    console.dir(item);
});

// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs

```

## Python example

```python
from apify_client import ApifyClient

# Initialize the ApifyClient with your Apify API token
# Replace '<YOUR_API_TOKEN>' with your token.
client = ApifyClient("<YOUR_API_TOKEN>")

# Prepare the Actor input
run_input = {
    "maxItems": 10,
    "flow": "EXR",
    "seriesKey": "D.USD.EUR.SP00.A",
}

# Run the Actor and wait for it to finish
run = client.actor("parseforge/ecb-statistical-data-warehouse-scraper").call(run_input=run_input)

# Fetch and print Actor results from the run's dataset (if there are any)
print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
for item in client.dataset(run.default_dataset_id).iterate_items():
    print(item)

# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

```

## CLI example

```bash
echo '{
  "maxItems": 10,
  "flow": "EXR",
  "seriesKey": "D.USD.EUR.SP00.A"
}' |
apify call parseforge/ecb-statistical-data-warehouse-scraper --silent --output-dataset

```

## MCP server setup

```json
{
    "mcpServers": {
        "apify": {
            "type": "http",
            "url": "https://mcp.apify.com/?tools=fetch-actor-details,parseforge/ecb-statistical-data-warehouse-scraper"
        }
    }
}

```

The hosted server signs you in with OAuth on first connect, so no API token belongs in this config. Clients without OAuth support can send an `Authorization: Bearer <APIFY_API_TOKEN>` header instead, using a token from API & Integrations in Apify Console (https://console.apify.com/settings/integrations).

## OpenAPI specification

Download the OpenAPI definition: https://api.apify.com/v2/actors/bCFKyklsGJJnSxbD9/builds/bAipq2EsEE08qDb1f/openapi.json