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

205.29 MB
7533337 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

182.46 MB
1214106 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
);