# Crypto ETF Flow Tracker - BTC/ETH/SOL Spot ETFs Daily API (`gochujang/crypto-etf-flow-tracker`) Actor

Daily institutional flows for US-listed Bitcoin, Ethereum, and Solana spot ETFs. Net inflow/outflow USD, AUM, value traded, cumulative flow. 300d history. Telegram alerts on outsized flows. SoSoValue-powered.

- **URL**: https://apify.com/gochujang/crypto-etf-flow-tracker.md
- **Developed by:** [Hojun Lee](https://apify.com/gochujang) (community)
- **Categories:** Developer tools, Automation, News
- **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, NaN bookmarks
- **User rating**: No ratings yet

## Pricing

$1.00 / 1,000 flow day trackeds

This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events.

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

## What's an Apify Actor?

Actors are a software tools running on the Apify platform, for all kinds of web data extraction and automation use cases.
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.

In JavaScript/TypeScript projects, use official [JavaScript/TypeScript client](https://docs.apify.com/api/client/js.md):

```bash
npm install apify-client
```

In Python projects, use official [Python client library](https://docs.apify.com/api/client/python.md):

```bash
pip install apify-client
```

In shell scripts, use [Apify CLI](https://docs.apify.com/cli/docs.md):

````bash
# MacOS / Linux
curl -fsSL https://apify.com/install-cli.sh | bash
# Windows
irm https://apify.com/install-cli.ps1 | iex
```bash

In AI frameworks, you might use the [Apify MCP server](https://docs.apify.com/platform/integrations/mcp.md).

If your project is in a different language, use 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

## Crypto ETF Flow Tracker

> Track daily institutional flows into **US-listed Bitcoin, Ethereum, and Solana spot ETFs**. Spot smart-money rotation and supply-absorption trends. No API key required.

---

### What It Does

Pulls daily net inflow/outflow data for all US-listed spot crypto ETFs (BlackRock IBIT, Fidelity FBTC, ARK ARKB, BlackRock ETHA, Fidelity FETH, etc.) — aggregated by issuer category. Use it to:

- Track BTC ETF accumulation trends (institutional flows are a leading indicator)
- Compare BTC vs ETH vs SOL flow strength to detect rotation
- Watch cumulative AUM growth across all issuers
- Alert when daily flows spike — large outflows often precede dumps; large inflows often precede rallies

---

### Why ETF Flows Matter

Since the January 2024 SEC approval of US spot Bitcoin ETFs, institutional flow data has become the most reliable leading indicator for major moves:

- **Sustained inflows** ($500M+/day) often precede 5–15% rallies within a week
- **Sustained outflows** signal de-risking — historically aligned with multi-week drawdowns
- **Rotation patterns** (BTC outflows ↔ ETH inflows) reveal smart-money sector bets

This Actor gives you the raw daily series in a machine-readable format you can plug into your bot, dashboard, or alert pipeline.

---

### Input

| Field | Type | Default | Description |
|-------|------|---------|-------------|
| `etfTypes` | string[] | `["us-btc-spot","us-eth-spot","us-sol-spot"]` | Which ETFs to track. Supported: `us-btc-spot`, `us-eth-spot`, `us-sol-spot` |
| `lookbackDays` | integer | `30` | Days of history to return (1–300) |
| `sortBy` | string | `date_desc` | `date_desc`, `date_asc`, `abs_inflow_desc` |
| `alertOutflowUsd` | integer | `0` | Alert when latest day's net outflow exceeds this $ amount. 0 = disabled |
| `alertInflowUsd` | integer | `0` | Alert when latest day's net inflow exceeds this $ amount. 0 = disabled |
| `telegramBotToken` | string (secret) | — | Telegram bot token for alerts |
| `telegramChatId` | string | — | Chat ID to receive alerts |

#### Example: Last 7 days, all ETFs
```json
{
  "etfTypes": ["us-btc-spot", "us-eth-spot", "us-sol-spot"],
  "lookbackDays": 7,
  "sortBy": "date_desc"
}
````

#### Example: Telegram alert on any BTC ETF day with > $1B outflow

```json
{
  "etfTypes": ["us-btc-spot"],
  "lookbackDays": 1,
  "alertOutflowUsd": 1000000000,
  "telegramBotToken": "<token>",
  "telegramChatId": "<chat_id>"
}
```

***

### Output

Each record is one daily aggregate per ETF type:

```json
{
  "etf_type": "us-btc-spot",
  "date": "2026-06-01",
  "net_inflow_usd": -483760871.60,
  "value_traded_usd": 2963023284.40,
  "total_net_assets_usd": 91160255779.37,
  "cum_net_inflow_usd": 55178763954.85,
  "aum_change_pct": -3.20,
  "is_inflow": false,
  "is_outflow": true,
  "row_index": 299
}
```

| Field | Description |
|-------|-------------|
| `net_inflow_usd` | Daily creation minus redemption value. Negative = net outflow |
| `cum_net_inflow_usd` | All-time cumulative net flow into the asset class |
| `total_net_assets_usd` | Total AUM across all ETFs in this category at end of day |
| `value_traded_usd` | Daily dollar volume across all ETFs in this category |
| `aum_change_pct` | Day-over-day AUM change (combines flows + price movement) |

***

### Pricing

Pay-Per-Event (PPE):

- **$0.001 per daily flow row returned**

Examples:

- 30 days × 3 ETFs = 90 rows = **$0.09**
- Full 300 days × 3 ETFs = 900 rows = **$0.90**

***

### Use Cases

**Daily flow dashboard** — Run every morning and pipe results into Notion/Sheets:

```bash
curl -X POST "https://api.apify.com/v2/acts/gochujang~crypto-etf-flow-tracker/runs?token=YOUR_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"lookbackDays": 30, "sortBy": "date_desc"}'
```

**Outflow panic alert** — Alert when BTC ETFs lose >$500M in a single day:

```json
{
  "etfTypes": ["us-btc-spot"],
  "lookbackDays": 1,
  "alertOutflowUsd": 500000000,
  "telegramBotToken": "<token>",
  "telegramChatId": "<chat>"
}
```

***

### Data Source

All data comes from [SoSoValue](https://sosovalue.com/) — the industry-standard public ETF flow aggregator covering all approved US spot crypto ETFs. Data updates ~1 hour after US market close.

- No API key required
- No rate limits at single-actor scale
- Up to ~300 days of historical daily data per ETF type

***

### Related Actors

Build a complete crypto edge with these actors from the same author:

- **[Smart Money Wallet Tracker](https://apify.com/gochujang/smart-money-tracker)** — Track 238 smart wallets to see early on-chain moves before ETF data updates.
- **[CEX Funding Rate Aggregator](https://apify.com/gochujang/cex-funding-aggregator)** — Detect over-leveraged positioning across Binance/Bybit/OKX.
- **[Token Unlock Calendar](https://apify.com/gochujang/token-unlock-calendar)** — Track upcoming token unlocks before VC dumps.

***

### Feedback

If this Actor saves you time, a quick review helps others find it: [Leave a review on Apify Store](https://apify.com/gochujang/crypto-etf-flow-tracker#reviews)

# Actor input Schema

## `etfTypes` (type: `array`):

Which spot ETFs to track. Supported: us-btc-spot, us-eth-spot, us-sol-spot.

## `lookbackDays` (type: `integer`):

Return the last N days of daily flow data. Max 300.

## `sortBy` (type: `string`):

Sort order across the returned dataset.

## `alertOutflowUsd` (type: `integer`):

Send Telegram alert when the most recent day's net outflow exceeds this $ amount. 0 = disabled. Requires telegramBotToken + telegramChatId.

## `alertInflowUsd` (type: `integer`):

Send Telegram alert when the most recent day's net inflow exceeds this $ amount. 0 = disabled.

## `telegramBotToken` (type: `string`):

Telegram bot token for flow alerts. Leave empty to disable.

## `telegramChatId` (type: `string`):

Chat ID (user or group) to receive flow alerts.

## Actor input object example

```json
{
  "etfTypes": [
    "us-btc-spot",
    "us-eth-spot",
    "us-sol-spot"
  ],
  "lookbackDays": 30,
  "sortBy": "date_desc",
  "alertOutflowUsd": 0,
  "alertInflowUsd": 0,
  "telegramChatId": ""
}
```

# 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 = {
    "etfTypes": [
        "us-btc-spot",
        "us-eth-spot",
        "us-sol-spot"
    ]
};

// Run the Actor and wait for it to finish
const run = await client.actor("gochujang/crypto-etf-flow-tracker").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 = { "etfTypes": [
        "us-btc-spot",
        "us-eth-spot",
        "us-sol-spot",
    ] }

# Run the Actor and wait for it to finish
run = client.actor("gochujang/crypto-etf-flow-tracker").call(run_input=run_input)

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

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

```

## CLI example

```bash
echo '{
  "etfTypes": [
    "us-btc-spot",
    "us-eth-spot",
    "us-sol-spot"
  ]
}' |
apify call gochujang/crypto-etf-flow-tracker --silent --output-dataset

```

## MCP server setup

```json
{
    "mcpServers": {
        "apify": {
            "command": "npx",
            "args": [
                "mcp-remote",
                "https://mcp.apify.com/?tools=gochujang/crypto-etf-flow-tracker",
                "--header",
                "Authorization: Bearer <YOUR_API_TOKEN>"
            ]
        }
    }
}

```

## OpenAPI specification

```json
{
    "openapi": "3.0.1",
    "info": {
        "title": "Crypto ETF Flow Tracker - BTC/ETH/SOL Spot ETFs Daily API",
        "description": "Daily institutional flows for US-listed Bitcoin, Ethereum, and Solana spot ETFs. Net inflow/outflow USD, AUM, value traded, cumulative flow. 300d history. Telegram alerts on outsized flows. SoSoValue-powered.",
        "version": "0.1",
        "x-build-id": "XWSy2nGfkN92vT11w"
    },
    "servers": [
        {
            "url": "https://api.apify.com/v2"
        }
    ],
    "paths": {
        "/acts/gochujang~crypto-etf-flow-tracker/run-sync-get-dataset-items": {
            "post": {
                "operationId": "run-sync-get-dataset-items-gochujang-crypto-etf-flow-tracker",
                "x-openai-isConsequential": false,
                "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.",
                "tags": [
                    "Run Actor"
                ],
                "requestBody": {
                    "required": true,
                    "content": {
                        "application/json": {
                            "schema": {
                                "$ref": "#/components/schemas/inputSchema"
                            }
                        }
                    }
                },
                "parameters": [
                    {
                        "name": "token",
                        "in": "query",
                        "required": true,
                        "schema": {
                            "type": "string"
                        },
                        "description": "Enter your Apify token here"
                    }
                ],
                "responses": {
                    "200": {
                        "description": "OK"
                    }
                }
            }
        },
        "/acts/gochujang~crypto-etf-flow-tracker/runs": {
            "post": {
                "operationId": "runs-sync-gochujang-crypto-etf-flow-tracker",
                "x-openai-isConsequential": false,
                "summary": "Executes an Actor and returns information about the initiated run in response.",
                "tags": [
                    "Run Actor"
                ],
                "requestBody": {
                    "required": true,
                    "content": {
                        "application/json": {
                            "schema": {
                                "$ref": "#/components/schemas/inputSchema"
                            }
                        }
                    }
                },
                "parameters": [
                    {
                        "name": "token",
                        "in": "query",
                        "required": true,
                        "schema": {
                            "type": "string"
                        },
                        "description": "Enter your Apify token here"
                    }
                ],
                "responses": {
                    "200": {
                        "description": "OK",
                        "content": {
                            "application/json": {
                                "schema": {
                                    "$ref": "#/components/schemas/runsResponseSchema"
                                }
                            }
                        }
                    }
                }
            }
        },
        "/acts/gochujang~crypto-etf-flow-tracker/run-sync": {
            "post": {
                "operationId": "run-sync-gochujang-crypto-etf-flow-tracker",
                "x-openai-isConsequential": false,
                "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.",
                "tags": [
                    "Run Actor"
                ],
                "requestBody": {
                    "required": true,
                    "content": {
                        "application/json": {
                            "schema": {
                                "$ref": "#/components/schemas/inputSchema"
                            }
                        }
                    }
                },
                "parameters": [
                    {
                        "name": "token",
                        "in": "query",
                        "required": true,
                        "schema": {
                            "type": "string"
                        },
                        "description": "Enter your Apify token here"
                    }
                ],
                "responses": {
                    "200": {
                        "description": "OK"
                    }
                }
            }
        }
    },
    "components": {
        "schemas": {
            "inputSchema": {
                "type": "object",
                "properties": {
                    "etfTypes": {
                        "title": "ETF Types",
                        "type": "array",
                        "description": "Which spot ETFs to track. Supported: us-btc-spot, us-eth-spot, us-sol-spot.",
                        "default": [
                            "us-btc-spot",
                            "us-eth-spot",
                            "us-sol-spot"
                        ],
                        "items": {
                            "type": "string"
                        }
                    },
                    "lookbackDays": {
                        "title": "Lookback (days)",
                        "minimum": 1,
                        "maximum": 300,
                        "type": "integer",
                        "description": "Return the last N days of daily flow data. Max 300.",
                        "default": 30
                    },
                    "sortBy": {
                        "title": "Sort By",
                        "enum": [
                            "date_desc",
                            "date_asc",
                            "abs_inflow_desc"
                        ],
                        "type": "string",
                        "description": "Sort order across the returned dataset.",
                        "default": "date_desc"
                    },
                    "alertOutflowUsd": {
                        "title": "Telegram Alert: Daily Outflow Threshold (USD)",
                        "minimum": 0,
                        "type": "integer",
                        "description": "Send Telegram alert when the most recent day's net outflow exceeds this $ amount. 0 = disabled. Requires telegramBotToken + telegramChatId.",
                        "default": 0
                    },
                    "alertInflowUsd": {
                        "title": "Telegram Alert: Daily Inflow Threshold (USD)",
                        "minimum": 0,
                        "type": "integer",
                        "description": "Send Telegram alert when the most recent day's net inflow exceeds this $ amount. 0 = disabled.",
                        "default": 0
                    },
                    "telegramBotToken": {
                        "title": "Telegram Bot Token",
                        "type": "string",
                        "description": "Telegram bot token for flow alerts. Leave empty to disable."
                    },
                    "telegramChatId": {
                        "title": "Telegram Chat ID",
                        "type": "string",
                        "description": "Chat ID (user or group) to receive flow alerts.",
                        "default": ""
                    }
                }
            },
            "runsResponseSchema": {
                "type": "object",
                "properties": {
                    "data": {
                        "type": "object",
                        "properties": {
                            "id": {
                                "type": "string"
                            },
                            "actId": {
                                "type": "string"
                            },
                            "userId": {
                                "type": "string"
                            },
                            "startedAt": {
                                "type": "string",
                                "format": "date-time",
                                "example": "2025-01-08T00:00:00.000Z"
                            },
                            "finishedAt": {
                                "type": "string",
                                "format": "date-time",
                                "example": "2025-01-08T00:00:00.000Z"
                            },
                            "status": {
                                "type": "string",
                                "example": "READY"
                            },
                            "meta": {
                                "type": "object",
                                "properties": {
                                    "origin": {
                                        "type": "string",
                                        "example": "API"
                                    },
                                    "userAgent": {
                                        "type": "string"
                                    }
                                }
                            },
                            "stats": {
                                "type": "object",
                                "properties": {
                                    "inputBodyLen": {
                                        "type": "integer",
                                        "example": 2000
                                    },
                                    "rebootCount": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "restartCount": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "resurrectCount": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "computeUnits": {
                                        "type": "integer",
                                        "example": 0
                                    }
                                }
                            },
                            "options": {
                                "type": "object",
                                "properties": {
                                    "build": {
                                        "type": "string",
                                        "example": "latest"
                                    },
                                    "timeoutSecs": {
                                        "type": "integer",
                                        "example": 300
                                    },
                                    "memoryMbytes": {
                                        "type": "integer",
                                        "example": 1024
                                    },
                                    "diskMbytes": {
                                        "type": "integer",
                                        "example": 2048
                                    }
                                }
                            },
                            "buildId": {
                                "type": "string"
                            },
                            "defaultKeyValueStoreId": {
                                "type": "string"
                            },
                            "defaultDatasetId": {
                                "type": "string"
                            },
                            "defaultRequestQueueId": {
                                "type": "string"
                            },
                            "buildNumber": {
                                "type": "string",
                                "example": "1.0.0"
                            },
                            "containerUrl": {
                                "type": "string"
                            },
                            "usage": {
                                "type": "object",
                                "properties": {
                                    "ACTOR_COMPUTE_UNITS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATASET_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATASET_WRITES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "KEY_VALUE_STORE_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "KEY_VALUE_STORE_WRITES": {
                                        "type": "integer",
                                        "example": 1
                                    },
                                    "KEY_VALUE_STORE_LISTS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "REQUEST_QUEUE_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "REQUEST_QUEUE_WRITES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATA_TRANSFER_INTERNAL_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATA_TRANSFER_EXTERNAL_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "PROXY_RESIDENTIAL_TRANSFER_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "PROXY_SERPS": {
                                        "type": "integer",
                                        "example": 0
                                    }
                                }
                            },
                            "usageTotalUsd": {
                                "type": "number",
                                "example": 0.00005
                            },
                            "usageUsd": {
                                "type": "object",
                                "properties": {
                                    "ACTOR_COMPUTE_UNITS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATASET_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATASET_WRITES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "KEY_VALUE_STORE_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "KEY_VALUE_STORE_WRITES": {
                                        "type": "number",
                                        "example": 0.00005
                                    },
                                    "KEY_VALUE_STORE_LISTS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "REQUEST_QUEUE_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "REQUEST_QUEUE_WRITES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATA_TRANSFER_INTERNAL_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATA_TRANSFER_EXTERNAL_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "PROXY_RESIDENTIAL_TRANSFER_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "PROXY_SERPS": {
                                        "type": "integer",
                                        "example": 0
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    }
}
```
