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.75 kB
2,998 rows
2 columns

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

Daily TVL Per Chain

@defillama.tvl.daily_tvl_per_chain

80.97 MB
15,980,173 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

708.1 MB
73,482,271 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

327.33 MB
947,299 rows
57 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,
  "previousnames" VARCHAR,
  "staking" DOUBLE,
  "assettoken" VARCHAR,
  "forkedfromids" VARCHAR,
  "tokensexcludedfromparent" VARCHAR,
  "pool2" DOUBLE,
  "deprecated" VARCHAR,
  "oracles" VARCHAR,
  "tags" VARCHAR,
  "language" VARCHAR,
  "stablecoins" VARCHAR,
  "deadurl" VARCHAR,
  "excludetvlfromparent" VARCHAR,
  "warningbanners" VARCHAR,
  "rugged" VARCHAR,
  "deadfrom" VARCHAR
);