# ROT A2 flow feed: sources for the Coder's daily loader (v1, 7 Oct 2026, Bangkok)

## Read this first
- Coder: this is WHAT to load for the flow feed. You own HOW. Do not run my script in production; it is the reference fetcher.
- Reference fetcher (tested): research-box `/opt/rot/a2/fetch_flows.py`. Output is one tidy table: `date (UTC day), source, metric, entity, value` in `/opt/rot/a2/data/flows_daily.csv.gz`. Suggest table `flows_daily` with the same 5 columns, key (date, metric, entity).
- All calls: browser User-Agent, no retry loops, ~0.35 s gap. Full history in about 350 calls (about 7 minutes on research-box). A daily refresh can keep closed days and overwrite the last 3.

## Sources (all free, all reach research-box)
| # | Series | Endpoint | Grain | Entities |
|---|---|---|---|---|
| 1 | Stablecoin supply per chain | `https://stablecoins.llama.fi/stablecoincharts/{Chain}` (and `/all`) | daily | 20 chains, names from `/stablecoinchains` |
| 2 | DEX volume per chain | `https://api.llama.fi/overview/dexs/{Chain}?excludeTotalDataChart=false&excludeTotalDataChartBreakdown=true` | daily | same chains |
| 3 | Fees per chain | `https://api.llama.fi/overview/fees/{Chain}?excludeTotalDataChart=false&excludeTotalDataChartBreakdown=true&dataType=dailyFees` | daily | same chains |
| 4 | TVL per chain | `https://api.llama.fi/v2/historicalChainTvl/{Chain}` | daily | same chains (USD, so price contaminated: info only) |
| 5 | Launchpad and retail trading app fees, split by chain | `https://api.llama.fi/summary/fees/{slug}?dataType=dailyFees` (field `totalDataChartBreakdown`) | daily | 26 slugs: pump.fun, pumpswap, bonk.fun-launchpad, launchlab, meteora-dynamic-bonding-curve, bags, four.meme, flap-sh, clanker, zora-coins, virtuals-protocol, pons-v2, pons-v1, fables, o1-launchpad, pools, flaunch, liquidlaunch, moonshot-create, axiom, gmgn, fomo-wallet, photon, bullx, maestro, bonkbot ("believe" returns 400, dropped) |
| 6 | Funding per major | `https://fapi.binance.com/fapi/v1/fundingRate?symbol={S}USDT&startTime=..&limit=1000` | 8h, summed to day | BTC ETH SOL BNB HYPE SUI AVAX ARB TRX TON APT DOGE XRP S |
| 7 | Open interest (contracts, not USD) | `https://api.bybit.com/v5/market/open-interest?category=linear&symbol={S}USDT&intervalTime=1d&limit=200&cursor=..` | daily (1h available) | same majors |
| 8 | Chain native prices and CEX volume | `https://api.binance.com/api/v3/klines?symbol={S}USDT&interval=1d` | daily (1h available) | BTC ETH SOL BNB ARB TRX SUI AVAX S TON POL APT OP HYPE DOGE XRP |
| 9 | Binance new listings | `https://www.binance.com/bapi/composite/v1/public/cms/article/list/query?type=1&catalogId=48&pageNo=1&pageSize=50` | event | title + releaseDate (ms) |
| 10 | Coinbase new listings | `https://api.exchange.coinbase.com/products` | snapshot | no dates in API: store a daily snapshot, new id = listing |

## Not available free (gaps, stated)
- Bridge net flow: DefiLlama bridges API is paid (HTTP 402). Stablecoin supply change per chain is the free stand in.
- Launchpad new coin counts: needs Dune (credits) or a chain indexer. Launchpad fees (row 5) cover activity. Price Predict already counts RH and Solana launches; supervisor can ask PP for a read only copy.
- LunarCrush attention: works only inside a Claude session (MCP), limited mode, no API key on any server, so it cannot feed a daily loader. twitterapi.io (~$0.15 per 1,000 posts) can count X posts per sector term; cap 20k posts a day (~$3) if the supervisor wants it.

## What matters most for the loader (from Task 2)
- Funding (row 6) is the only series that led price. Make it reliable first, and hourly if possible.
- Rows 1 to 5 and 8 lag price by about a week: keep them for the crowding and confirm layers, not for NEXT.

Version: v1, 7 Oct 2026, 11:30 Bangkok. Latest: http://159.223.88.168/hx-c9ois/rot/a2-sources.md