DeFi Flows and Events

Bridge Flows

Tool: defillama:getbridgeflows

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

ETF Flows

Tool: defillama:getetfflows

• 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:getstablecoinsupply

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

Institutional Holdings (DAT)

Tool: defillama:getdatholdings

• 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:getevents with eventtype: "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:getevents with eventtype: "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:getevents with eventtype: "protocol_events"

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

CEX Volumes

Tool: defillama:getcexvolumes

• 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:getopeninterest

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

Treasury

Tool: defillama:get_treasury

• Aggregates with SUM/GROUP BY for proper protocol-level totals
• treasuryexclown_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, startdate, enddate, sort_by, limit

Examples

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

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

Example 3: User: "Biggest DeFi hacks in 2024" Tool call: defillama:getevents(eventtype: "hacks", sortby: "amount desc", limit: 10, startdate: "2024-01-01", end_date: "2024-12-31")

Example 4: User: "USDT supply across chains" Tool call: defillama:getstablecoinsupply(stablecoin: "coingecko:tether", sortby: "circulatingsupply desc")

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

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

Example 7: User: "Binance trading volume" Tool call: defillama:getcexvolumes(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:getetfflows(token: "bitcoin", startdate: "2025-02-01", enddate: "2025-02-28")