DefiLlama DeFi Data Export – TVL, Stablecoins, DEX Volumes, Fees & Yields

Export the most-used DefiLlama DeFi datasets as clean, flat tables, ready for Excel, Google Sheets, BI tools, databases, n8n/Make/Zapier workflows and AI agents. One run = one table, with a snapshotAt timestamp on every row.

dataset	What you get (one row per…)
protocols	protocol: name, slug, category, chains, TVL, 1h/1d/7d TVL change %, market cap, mcap/TVL, top chains, website
chains_tvl	chain: TVL, share of total DeFi TVL %, native token, chain ID
protocol_history	protocol × day (optionally × chain): daily TVL for the last N days, change vs previous point
stablecoins	stablecoin: symbol, peg type & mechanism, price, circulating supply (USD), 1d/7d/30d supply change %, top chains
stablecoin_chains	chain: total stablecoin supply (USD), share %, USD/EUR/other-pegged split
dex_volumes	DEX: 24h / 7d / 30d / 1y / all-time volume, 1d/7d/1m change %
fees_revenue	protocol: 24h / 7d / 30d / 1y fees and revenue, change %
yields	yield pool: project, chain, symbol, TVL, APY, base APY, reward APY, 30d mean APY, stablecoin flag, IL risk, exposure

No API key, no login, no proxies. A typical run takes 3–10 seconds.

Who it is for

• Analysts, researchers and journalists who need DeFi TVL, stablecoin or fee numbers in a spreadsheet without writing code.
• Data teams loading daily DeFi snapshots into a warehouse (schedule the actor and append the dataset).
• Dashboard builders (Looker Studio, Power BI, Metabase, Notion) who want stable column names.
• AI agents and LLM apps that need a reliable "current DeFi data" tool via MCP.

Why this actor

• 8 datasets in one actor with one consistent, flat schema per dataset. No nested JSON to unpack: chains are comma-separated strings and percentages are plain numbers.
• Useful filters that the raw API does not have: chains, categories, protocol slugs, stablecoin symbols, minimum TVL, minimum APY, stablecoin-only pools, Top N.
• Computed fields: chain market share %, stablecoin supply changes, mcap/TVL ratio, TVL on your selected chains, fees and revenue merged into one row.
• Handles the big endpoints: protocol history and yield pools are streamed to disk and parsed incrementally, so even 100 MB+ responses run on 512 MB memory.
• CEX reserves are excluded by default so the protocols table is DeFi only (toggle excludeCex).
• Cheap and capped: $0.20 per 1,000 rows, with a hard maxRows cap (default 100).

Input

Default input (top 20 DeFi protocols by TVL):

{
  "dataset": "protocols",
  "topN": 20
}

More examples:

{ "dataset": "protocols", "categories": ["Lending"], "chains": ["Base"], "topN": 10 }
{ "dataset": "chains_tvl", "topN": 25 }
{ "dataset": "protocol_history", "protocols": ["aave", "lido"], "days": 90, "includeChainBreakdown": true, "chains": ["Ethereum", "Arbitrum"], "maxRows": 1000 }
{ "dataset": "stablecoins", "stablecoinSymbols": ["USDT", "USDC", "USDe", "DAI"] }
{ "dataset": "dex_volumes", "chains": ["Solana"], "topN": 15 }
{ "dataset": "fees_revenue", "topN": 50 }
{ "dataset": "yields", "chains": ["Ethereum"], "stablecoinPoolsOnly": true, "minTvlUsd": 10000000, "topN": 50 }

Field	Description
dataset	One of the 8 datasets above.
topN	Keep the N largest entries after filtering (by TVL, supply, 24h volume or fees; yields by TVL or APY). 0 = no limit. Not applied to protocol_history.
maxRows	Hard cap on output rows (= billable events). Default 100.
chains	Chain names, case-insensitive (Ethereum, Solana, Base, Arbitrum, BSC, Tron …).
categories	DefiLlama categories (Lending, Dexs, Liquid Staking, Bridge, CDP, Restaking, Derivatives …).
protocols	DefiLlama slugs (as in defillama.com/protocol/<slug>). Needed for protocol_history (max 25, defaults to aave and lido); filters other datasets. For yields use project names like aave-v3, lido.
stablecoinSymbols	USDT, USDC, DAI … for stablecoins; for yields keeps pools containing that token.
minTvlUsd	Minimum TVL (or circulating supply for stablecoins).
excludeCex	Drop centralized-exchange reserve entries from protocols (default on).
days, includeChainBreakdown	History length and per-chain rows for protocol_history.
stablecoinPoolsOnly, minApy, yieldsSortBy	Yield pool filters and ranking.

Output

Every row has dataset, rank, snapshotAt (UTC), source and status. Real rows from a test run on 2026-11-06:

protocols (default input):

{
  "dataset": "protocols",
  "rank": 1,
  "name": "Lido",
  "slug": "lido",
  "category": "Liquid Staking",
  "chains": "Ethereum, Solana, Terra, Moonriver, Moonbeam",
  "chainCount": 5,
  "tvlUsd": 21772660694.61,
  "change1hPct": 0.51,
  "change1dPct": -7.4,
  "change7dPct": 0.55,
  "mcapUsd": 277250073.15,
  "mcapToTvl": 0.013,
  "symbol": "LDO",
  "topChainsByTvl": "Ethereum, Solana",
  "url": "https://lido.fi/",
  "defillamaUrl": "https://defillama.com/protocol/lido",
  "twitter": "LidoFinance",
  "listedAt": null,
  "snapshotAt": "2026-11-06T11:26:57Z",
  "source": "DefiLlama",
  "status": "ok"
}

The rest of that run's top 5: LayerZero V2 ($17.1B), Aave V3 ($15.2B), SSV Network ($11.7B), Morpho Blue ($11.0B).

protocol_history (aave, Arbitrum):

{
  "dataset": "protocol_history",
  "protocol": "Aave",
  "slug": "aave",
  "chain": "Arbitrum",
  "date": "2026-11-05",
  "timestamp": "2026-11-05T00:00:00Z",
  "isIntraday": false,
  "tvlUsd": 509999354,
  "changeVsPrevPointPct": null,
  "snapshotAt": "2026-11-06T11:27:17Z",
  "source": "DefiLlama",
  "status": "ok"
}

The last point of each history series is DefiLlama's current (intraday) value and is marked isIntraday: true.

Other datasets use these columns:

• chains_tvl: chain, tvlUsd, sharePct, tokenSymbol, chainId, geckoId, defillamaUrl
• stablecoins: symbol, name, pegType, pegMechanism, priceUsd, circulating, circulatingUsd, change1dPct, change7dPct, change30dPct, chainCount, topChains, geckoId
• stablecoin_chains: chain, stablecoinSupplyUsd, sharePct, usdPeggedUsd, eurPeggedUsd, otherPeggedUsd
• dex_volumes: protocol, slug, category, chains, volume24hUsd, volume7dUsd, volume30dUsd, volume1yUsd, volumeAllTimeUsd, change1dPct, change7dPct, change1mPct
• fees_revenue: protocol, slug, category, chains, fees24hUsd, fees7dUsd, fees30dUsd, fees1yUsd, feesChange1dPct, feesChange7dPct, revenue24hUsd, revenue7dUsd, revenue30dUsd, revenue1yUsd, revenueChange7dPct
• yields: pool, project, chain, symbol, poolMeta, tvlUsd, apy, apyBase, apyReward, apyMean30d, apyChange1d/7d/30d, stablecoin, ilRisk, exposure, volume1dUsd, outlier, predictedClass, rewardTokens, defillamaUrl

Download as JSON, CSV, Excel or HTML from the dataset tab or the API.

Pricing

Pay per event: $0.0002 per output row ($0.20 per 1,000 rows), plus Apify's tiny actor start fee. The default run (20 rows) costs about $0.004. Error rows (e.g. an unknown protocol slug) are free. maxRows caps your cost per run.

Use it via API, n8n, Make or MCP

API (synchronous, returns the rows directly):

curl -X POST "https://api.apify.com/v2/acts/fast_data_asap~defillama-defi-data/run-sync-get-dataset-items?token=YOUR_APIFY_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{"dataset":"stablecoins","topN":10}'

Python:

from apify_client import ApifyClient
rows = ApifyClient("YOUR_APIFY_TOKEN").actor("fast_data_asap/defillama-defi-data") \
    .call(run_input={"dataset": "chains_tvl", "topN": 20}).dataset().list_items().items

n8n / Make / Zapier: use the Apify node or app, choose "Run actor and get dataset items", actor fast_data_asap/defillama-defi-data. Schedule it daily to build your own DeFi time series.

MCP (Claude, Cursor, other AI agents): add https://mcp.apify.com?tools=fast_data_asap/defillama-defi-data as an MCP server. Your agent can then ask for things like "top 10 lending protocols on Base by TVL" or "stablecoin supply by chain".

Data source, rate limits and fair use

All data comes from the free public DefiLlama API (api.llama.fi, stablecoins.llama.fi, yields.llama.fi). Credit for collecting and maintaining the data goes to DefiLlama and its open-source adapter contributors. Please credit DefiLlama when you publish the data.

To respect DefiLlama's free API limits, the actor sends requests one at a time, fetches each endpoint at most once per run (cached), spaces protocol-history requests about 1 second apart, caps history at 25 protocols per run, and backs off on HTTP 429 or 5xx responses. It identifies itself with a descriptive User-Agent.

This actor is not affiliated with DefiLlama. Values are DefiLlama's methodology (for example, TVL excludes borrowed and staked governance tokens by default) and may change or be revised by DefiLlama.

Disclaimer

The data is provided for information and research only, as published by DefiLlama, without warranty of accuracy or completeness. It is not financial advice or a recommendation to buy, sell or use any protocol or token. APY figures are historical or current values reported by the protocols and are not guaranteed.