SuperAPI AI Directory
Partner with us中文AI newsFavorites
Skillsflows-and-events

flows-and-events

Data & analytics

View repository

Updated 10-15 15:12

About this skill

DeFi Flows and Events

Bridge Flows

Tool: defillama:get_bridge_flows

  • Two-way bridge deduplication is applied automatically when aggregating
  • Grain: bridge x chain (one row per bridge per chain)
  • inflows = deposit_amount - withdraw_amount (pre-computed, positive = net inflow)
  • Params: bridge, chain, period, start_date, end_date, sort_by, limit

ETF Flows

Tool: defillama:get_etf_flows

  • flow_usd is signed: positive = inflow, negative = outflow
  • Filter by underlying: token: "bitcoin" for all BTC ETFs, token: "ethereum" for ETH ETFs
  • Use etf param to filter specific ETF (e.g., "ibit", "fbtc")
  • Current view shows latest day only. Use period: "30d" for historical.

Stablecoin Supply

Tool: defillama:get_stablecoin_supply

  • Supply = issuance on each chain, NOT DeFi deposits
  • Grain: stablecoin x chain (one row per stablecoin per chain)
  • Use circulating_supply (not total_supply) for supply queries
  • Filter by peg_type (usd, eur)
  • Params: stablecoin, chain, peg_type, period, sort_by, limit

Institutional Holdings (DAT)

Tool: defillama:get_dat_holdings

  • Tokens are automatically prefixed with coingecko: if not already (e.g., token: "bitcoin" works)
  • Base response: institution overview (total value, cost, mNAV ratios)
  • include_history: true adds historical holding snapshots
  • include_mnav: true adds mNAV time series
  • transaction_type filters history by transaction type (e.g., "purchase", "sale")

mNAV (multiple of Net Asset Value) -- measures crypto exposure relative to market cap:

  • realized_mnav: conservative estimate
  • realistic_mnav: expected dilution
  • max_mnav: maximum dilution
  • mNAV > 1 means crypto holdings exceed the company's market cap attribution

Hacks and Exploits

Tool: defillama:get_events with event_type: "hacks"

  • Filter by protocol (victim slug), chain (uses = ANY(chains) for array column), min_amount
  • returned_funds shows how much was recovered after the hack
  • Use sort_by: "amount desc" for biggest hacks

Fundraising Rounds

Tool: defillama:get_events with event_type: "raises"

  • Filter by protocol, chain (uses = ANY(chains) for array column), min_amount
  • Use sort_by: "amount desc" for largest rounds

Protocol Events

Tool: defillama:get_events with event_type: "protocol_events"

  • Governance votes, upgrades, launches, and other protocol milestones
  • Additional filters: target_type (filter by target type), sub_protocol (filter by sub-protocol slug)

CEX Volumes

Tool: defillama:get_cex_volumes

  • CEX slugs differ from common names: binance -> binance-cex, huobi -> htx, gate.io -> gate-io
  • Params: cex, period, sort_by, limit

Open Interest

Tool: defillama:get_open_interest

  • Aggregates with SUM/GROUP BY for proper protocol-level totals
  • Params: protocol, chain, period, start_date, end_date, sort_by, limit

Treasury

Tool: defillama:get_treasury

  • Aggregates with SUM/GROUP BY for proper protocol-level totals
  • treasury_excl_own_token is the realistic value (excludes inflation of protocol's own token)
  • treasury_total includes own token (inflated value)
  • Params: treasury, chain (for per-chain breakdown), period, start_date, end_date, sort_by, limit

Examples

Example 1: User: "Bitcoin ETF flows this month" Tool call: defillama:get_etf_flows(token: "bitcoin", period: "30d")

Example 2: User: "MicroStrategy bitcoin holdings" Tool call: defillama:get_dat_holdings(institution: "microstrategy", token: "coingecko:bitcoin", include_history: true)

Example 3: User: "Biggest DeFi hacks in 2024" Tool call: defillama:get_events(event_type: "hacks", sort_by: "amount desc", limit: 10, start_date: "2024-01-01", end_date: "2024-12-31")

Example 4: User: "USDT supply across chains" Tool call: defillama:get_stablecoin_supply(stablecoin: "coingecko:tether", sort_by: "circulating_supply desc")

Example 5: User: "Top bridge volume this week" Tool call: defillama:get_bridge_flows(period: "7d", sort_by: "volume desc", limit: 10)

Example 6: User: "Largest crypto fundraises this year" Tool call: defillama:get_events(event_type: "raises", period: "365d", sort_by: "amount desc", limit: 20)

Example 7: User: "Binance trading volume" Tool call: defillama:get_cex_volumes(cex: "binance-cex")

Example 8: User: "Uniswap treasury breakdown" Tool call: defillama:get_treasury(treasury: "uniswap")

Example 9: User: "ETF flows in February 2025" Tool call: defillama:get_etf_flows(token: "bitcoin", start_date: "2025-02-01", end_date: "2025-02-28")