Dataset: DefiLlama TVL

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

45.01 KB
2584 rows
2 columns


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

Daily TVL Per Token

@defillama.tvl.daily_tvl_per_token

502.35 MB
55193779 rows
4 columns


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

Daily TVL Per Chain

@defillama.tvl.daily_tvl_per_chain

99.11 MB
12553689 rows
4 columns


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

Total Value Locked (TVL) Overview

@defillama.tvl.overview_tvl

139.31 MB
421773 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,
  "oracles" VARCHAR,
  "listedat" DOUBLE,
  "methodology" VARCHAR,
  "tvl" DOUBLE,
  "chaintvls" VARCHAR,
  "change_1h" DOUBLE,
  "change_1d" DOUBLE,
  "change_7d" DOUBLE,
  "tokenbreakdowns" VARCHAR,
  "mcap" DOUBLE,
  "audit_links" VARCHAR,
  "parentprotocol" VARCHAR,
  "wrongliquidity" VARCHAR,
  "hallmarks" VARCHAR,
  "referralurl" VARCHAR,
  "treasury" VARCHAR,
  "opensource" VARCHAR,
  "governanceid" VARCHAR,
  "github" VARCHAR,
  "staking" DOUBLE,
  "previousnames" VARCHAR,
  "assettoken" VARCHAR,
  "oraclesbreakdown" VARCHAR,
  "tokensexcludedfromparent" VARCHAR,
  "oraclesbychain" VARCHAR,
  "pool2" DOUBLE,
  "forkedfromids" VARCHAR,
  "tags" VARCHAR,
  "stablecoins" VARCHAR,
  "misrepresentedtokens" VARCHAR,
  "language" VARCHAR,
  "deadurl" VARCHAR,
  "deadfrom" VARCHAR,
  "rugged" VARCHAR,
  "deprecated" VARCHAR,
  "year" INTEGER,
  "month" INTEGER,
  "day" INTEGER
);