io.github.sly13/cryptoetf

Get daily net ETF flow history for a single crypto asset over the last 30 days. Returns a time series of net USD millions per day (positive = inflow, negative = outflow). Figures are asset-level totals; the per-fund breakdown (IBIT, FBTC, ETHA and others) is returned by get_fund_flows.

Get net creations of US spot Bitcoin ETFs in BTC against newly mined bitcoin. Windows: the last full week (Monday to Sunday), 30 days, year to date and since launch (11 Jan 2024), each with ETF net BTC, mined BTC and their ratio (null when ETFs had net outflows). Also the number of consecutive full weeks with ETF demand above new supply and the last 12 weeks. ETF BTC is the daily USD net flow divided by the volume-weighted bitcoin price of that day; mined BTC is the block subsidy times blocks between midnights UTC.

Returns the composite CEFI (Crypto ETF Flow Index): a 0–100 index of money moving through US spot crypto ETFs on all 16 tracked assets. Net flows of all funds are added up in dollars, and three components are scored against the past year: flow (today's net flow, smoothed, 40%), trend (net flow over 20 trading days, 30%) and breadth (share of funds with inflows, 30%). 50 = zero net flow; a typical inflow day scores about 69, a typical outflow day about 31. Each component is on the same 0–100 scale. Zones: 0–20 extreme fear, 20–40 fear, 40–60 neutral, 60–80 greed, 80–100 extreme greed.

Get the estimated average entry price per coin of US spot crypto ETF holders for one asset or all 16: coins accumulated through net flows, money invested, average entry, the latest coin price and unrealised P&L. Also how many consecutive days holders have been above or below their entry and since when. The entry is built from daily creations and redemptions valued at the volume-weighted price of each day; coins of converted trusts (GBTC, ETHE) are not included.

Get the coins held in trust by US spot crypto ETFs for one asset or all 16, and the share of the coin's circulating supply they represent (`supplyPct`, percent). Per fund: coins held, share of the asset's ETF coins and `coinsBasis` — reported (published by the issuer, or shares times the published coins per share) or estimated (net assets per share at the same-day coin price, for issuers that do not publish coins). Includes 7- and 30-day changes in coins and the last 30 days of daily history.

Get the latest-day net ETF inflow/outflow (USD millions) for every tracked crypto asset: BTC (Bitcoin), ETH (Ethereum), SOL (Solana), XRP, HYP (Hyperliquid), DOGE (Dogecoin), LINK (Chainlink), AVAX (Avalanche), HBAR (Hedera), LTC (Litecoin), BNB, DOT (Polkadot), SUI, NEAR, TRX (TRON) and ZEC (Zcash). Positive = inflow, negative = outflow. Flows are published one business day in arrears, so `referenceIsToday` is normally false: the figures belong to `referenceDate`, the last trading day published, not to the current date. On Mondays the freshest data is Friday's. `totalUsdM` is the sum across all assets for `referenceDate`. `netFlowUsdM` is null for an asset that has no figure for `referenceDate` yet; its latest reported day is then in `lastReportedDate`, and it is not part of `totalUsdM`. Figures are asset-level totals; the per-fund breakdown (IBIT, FBTC, ETHA and others) is returned by get_fund_flows, net assets by get_funds.

Get daily net flows of every spot ETF on one crypto asset, fund by fund (IBIT, FBTC, ETHA, …), over the last 30 days. Each trading day lists the funds trading that day with ticker, issuer and net USD millions (positive = inflow, negative = outflow), plus `totalUsdM` for the day. `netFlowUsdM` is null when there is no figure for the fund that day, usually because it has not reported yet; 0 means no creations or redemptions. Flows are published one business day in arrears.

Get the US spot crypto ETFs that have started trading, for one asset or all 16: ticker, name, issuer, exchange, listing date, sponsor fee (percent per year), current net assets (`netAssetsUsdM`, USD millions) and coins held, plus the total net assets of each asset. Net assets are a current snapshot, not a history. `netAssetsBasis` is reported (published by the issuer for `netAssetsDate`), repriced (the latest published figure moved to that day by the NAV change of other funds) or estimated (coins times price, for issuers without daily holdings). `coinsHeld` is null for issuers that do not publish holdings in coins. Each fund also has `effectiveFeePct` and `feeWaiver` (a fee waiver in effect today), `feeRevenueUsdMPerYear` (net assets times the fee charged today, USD millions), `supplySharePct` (its coins as a share of circulating supply), `staking` (status from SEC filings, share staked, net yield and how rewards are paid) and `delistedAt` for a closed fund.

Get estimated sponsor fee revenue of US spot crypto ETFs: net assets times the prospectus sponsor fee, with temporary fee waivers applied. Per fund: net assets, nominal and effective fee (percent per year), revenue per day and annualised at current assets, and the sum for the last 30 days where a daily series exists. Totals by issuer and for the whole market. Arithmetic on the published fee, not the issuer's reported revenue; the sponsor's share of staking rewards is not included.

Get current spot prices (USD) and 24-hour percentage change for all 16 tracked crypto assets: BTC, ETH, SOL, XRP, HYP, DOGE, LINK, AVAX, HBAR, LTC, BNB, DOT, SUI, NEAR, TRX, ZEC. Prices are sourced from major exchanges and refreshed frequently.

Get the staking status of US spot crypto ETFs: active, allowed_not_started, pending_amendment, no, not_stakeable (proof-of-work assets and XRP) or unknown, from SEC filings. For staking funds: cap and share of assets staked, the staking yield as disclosed by the issuer with its date, providers, whether rewards are kept in the fund or paid in cash, the last cash payout per share, and `coinsPerShare` — the annualised growth of coins behind each share from daily issuer snapshots (shown only where the series is clean). Per asset: funds staking and the estimated coins staked.

Get 7-day aggregated ETF flow analytics for all tracked assets. Returns total net flow, the number of trading days in the window, average flow per trading day, and count of positive vs negative days per asset. Weekends are excluded. A compact momentum summary without the full daily series.