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

50.96 kB
2,952 rows
2 columns

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

Daily TVL Per Chain

@defillama.tvl.daily_tvl_per_chain

76.95 MB
15,168,908 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

664.29 MB
69,133,837 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

227.14 MB
659,222 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
);