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

48.79 KB
2894 rows
2 columns


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

Daily TVL Per Chain

@defillama.tvl.daily_tvl_per_chain

68.81 MB
14157713 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

582.27 MB
63752545 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

101.43 MB
309972 rows
54 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,
  "hallmarks" VARCHAR,
  "parentprotocolslug" VARCHAR,
  "referralurl" VARCHAR,
  "treasury" VARCHAR,
  "opensource" VARCHAR,
  "governanceid" VARCHAR,
  "github" VARCHAR,
  "staking" DOUBLE,
  "assettoken" VARCHAR,
  "tokensexcludedfromparent" VARCHAR,
  "pool2" DOUBLE,
  "forkedfromids" VARCHAR,
  "previousnames" VARCHAR,
  "oracles" VARCHAR,
  "tags" VARCHAR,
  "stablecoins" VARCHAR,
  "language" VARCHAR,
  "warningbanners" VARCHAR,
  "deadurl" VARCHAR,
  "rugged" VARCHAR,
  "deprecated" VARCHAR
);