Name: DefiLlama Yield Analytics
Creator: DefiLlama
License: https://creativecommons.org/licenses/by/4.0/

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

Daily Yields

@defillama.yields.daily_yields

215.7 MB
7,578,784 rows
8 columns

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

Overview Yields

@defillama.yields.overview_yields

362.91 MB
2,306,084 rows
29 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
);