Dataset: DefiLlama Yield Analytics

About this Dataset

DefiLlama Yield Analytics

This dataset provides a detailed overview of yield-generating DeFi pools, sourced from the DeFiLlama API.
It includes current and historical APY, Total Value Locked (TVL), and risk indicators across multiple blockchain networks,
helping users analyze yield trends and liquidity movements.

Tables

Overview Yields

@defillama.yields.overview_yields

185.01 MB
1239236 rows
32 columns


CREATE TABLE overview_yields (
  "data_obtained_at" TIMESTAMP,
  "pool" VARCHAR,
  "chain" VARCHAR,
  "project" VARCHAR,
  "symbol" VARCHAR,
  "tvlusd" BIGINT,
  "apybase" DOUBLE,
  "apyreward" DOUBLE,
  "apy" DOUBLE,
  "rewardtokens" VARCHAR,
  "apypct1d" DOUBLE,
  "apypct7d" DOUBLE,
  "apypct30d" DOUBLE,
  "stablecoin" BOOLEAN,
  "ilrisk" VARCHAR,
  "exposure" VARCHAR,
  "predictions" VARCHAR,
  "poolmeta" VARCHAR,
  "mu" DOUBLE,
  "sigma" DOUBLE,
  "count" BIGINT,
  "outlier" BOOLEAN,
  "underlyingtokens" VARCHAR,
  "il7d" DOUBLE,
  "apybase7d" DOUBLE,
  "apymean30d" DOUBLE,
  "volumeusd1d" DOUBLE,
  "volumeusd7d" DOUBLE,
  "apybaseinception" DOUBLE,
  "year" INTEGER,
  "month" INTEGER,
  "day" INTEGER
);

Daily Yields

@defillama.yields.daily_yields

182.7 MB
6459325 rows
8 columns


CREATE TABLE daily_yields (
  "pool" VARCHAR,
  "timestamp" TIMESTAMP,
  "tvlusd" BIGINT,
  "apy" DOUBLE,
  "apybase" DOUBLE,
  "apyreward" DOUBLE,
  "il7d" DOUBLE,
  "apybase7d" DOUBLE
);