Name: DefiLlama TVL
Creator: DefiLlama
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

DefiLlama TVL

This dataset provides detailed information about Total Value Locked (TVL) across multiple DeFi protocols, sourced from the DefiLlama API. It includes an overview of protocols, historical TVL data per blockchain, and token-level TVL breakdowns.

Tables

Daily TVL

@defillama.tvl.daily_tvl

51.16 kB
2,964 rows
2 columns

CREATE TABLE daily_tvl (
  "timestamp" TIMESTAMP,
  "tvl" BIGINT
);

Daily TVL Per Chain

@defillama.tvl.daily_tvl_per_chain

77.88 MB
15,372,322 rows
4 columns

CREATE TABLE daily_tvl_per_chain (
  "protocol" VARCHAR,
  "timestamp" TIMESTAMP,
  "chain" VARCHAR,
  "tvl" BIGINT
);

Daily TVL Per Token

@defillama.tvl.daily_tvl_per_token

675.52 MB
70,285,066 rows
4 columns

CREATE TABLE daily_tvl_per_token (
  "protocol" VARCHAR,
  "timestamp" TIMESTAMP,
  "token" VARCHAR,
  "tvl" DOUBLE
);

Total Value Locked (TVL) Overview

@defillama.tvl.overview_tvl

252.5 MB
732,080 rows
56 columns

CREATE TABLE overview_tvl (
  "slug" VARCHAR,
  "data_obtained_at" TIMESTAMP,
  "id" VARCHAR,
  "name" VARCHAR,
  "address" VARCHAR,
  "symbol" VARCHAR,
  "url" VARCHAR,
  "description" VARCHAR,
  "chain" VARCHAR,
  "logo" VARCHAR,
  "audits" VARCHAR,
  "audit_note" VARCHAR,
  "gecko_id" VARCHAR,
  "cmcid" VARCHAR,
  "category" VARCHAR,
  "chains" VARCHAR,
  "module" VARCHAR,
  "twitter" VARCHAR,
  "forkedfrom" VARCHAR,
  "listedat" DOUBLE,
  "methodology" VARCHAR,
  "misrepresentedtokens" BOOLEAN,
  "tvl" DOUBLE,
  "chaintvls" VARCHAR,
  "change_1h" DOUBLE,
  "change_1d" DOUBLE,
  "change_7d" DOUBLE,
  "tokenbreakdowns" VARCHAR,
  "mcap" DOUBLE,
  "oraclesbreakdown" VARCHAR,
  "audit_links" VARCHAR,
  "parentprotocol" VARCHAR,
  "wrongliquidity" VARCHAR,
  "dimensions" VARCHAR,
  "hallmarks" VARCHAR,
  "parentprotocolslug" VARCHAR,
  "referralurl" VARCHAR,
  "treasury" VARCHAR,
  "opensource" VARCHAR,
  "governanceid" VARCHAR,
  "github" VARCHAR,
  "staking" DOUBLE,
  "assettoken" VARCHAR,
  "tokensexcludedfromparent" VARCHAR,
  "forkedfromids" VARCHAR,
  "previousnames" VARCHAR,
  "pool2" DOUBLE,
  "oracles" VARCHAR,
  "tags" VARCHAR,
  "stablecoins" VARCHAR,
  "language" VARCHAR,
  "warningbanners" VARCHAR,
  "deadurl" VARCHAR,
  "excludetvlfromparent" VARCHAR,
  "deprecated" VARCHAR,
  "rugged" VARCHAR
);