Name: DefiLlama Fees And Revenue
Creator: DefiLlama
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

DefiLlama Fees And Revenue

This dataset provides detailed information about fees and revenue sourced from the DefiLlama API, which aggregates data across multiple blockchain networks and DeFi protocols.

Tables

Daily Fees And Revenue

@defillama.fees.daily_fees

3.63 MB
468,793 rows
5 columns

CREATE TABLE daily_fees (
  "protocol" VARCHAR,
  "timestamp" TIMESTAMP,
  "epoch" BIGINT,
  "dailyfees" DOUBLE,
  "dailyrevenue" DOUBLE
);

Fees And Revenue Overview

@defillama.fees.overview_fees

59.77 MB
262,875 rows
36 columns

CREATE TABLE overview_fees (
  "slug" VARCHAR,
  "metric" VARCHAR,
  "data_obtained_at" TIMESTAMP,
  "total24h" DOUBLE,
  "total48hto24h" DOUBLE,
  "total7d" DOUBLE,
  "total14dto7d" DOUBLE,
  "total60dto30d" DOUBLE,
  "total30d" DOUBLE,
  "total1y" DOUBLE,
  "totalalltime" DOUBLE,
  "average1y" DOUBLE,
  "monthlyaverage1y" DOUBLE,
  "change_7dover7d" DOUBLE,
  "change_30dover30d" DOUBLE,
  "breakdown24h" VARCHAR,
  "breakdown30d" VARCHAR,
  "total7daysago" DOUBLE,
  "total30daysago" DOUBLE,
  "defillamaid" VARCHAR,
  "name" VARCHAR,
  "displayname" VARCHAR,
  "module" VARCHAR,
  "category" VARCHAR,
  "logo" VARCHAR,
  "chains" VARCHAR,
  "protocoltype" VARCHAR,
  "methodologyurl" VARCHAR,
  "methodology" VARCHAR,
  "id" VARCHAR,
  "change_1d" DOUBLE,
  "change_7d" DOUBLE,
  "change_1m" DOUBLE,
  "parentprotocol" VARCHAR,
  "linkedprotocols" VARCHAR,
  "doublecounted" VARCHAR
);

Fees And Revenue Overview By Chain

@defillama.fees.overview_fees_by_chain

61.68 MB
539,147 rows
35 columns

CREATE TABLE overview_fees_by_chain (
  "slug" VARCHAR,
  "chain" VARCHAR,
  "metric" VARCHAR,
  "data_obtained_at" TIMESTAMP,
  "total24h" DOUBLE,
  "total48hto24h" DOUBLE,
  "total7d" DOUBLE,
  "total14dto7d" DOUBLE,
  "total60dto30d" DOUBLE,
  "total30d" DOUBLE,
  "total1y" DOUBLE,
  "totalalltime" DOUBLE,
  "average1y" DOUBLE,
  "monthlyaverage1y" DOUBLE,
  "change_1d" DOUBLE,
  "change_7d" DOUBLE,
  "change_1m" DOUBLE,
  "change_7dover7d" DOUBLE,
  "change_30dover30d" DOUBLE,
  "total7daysago" DOUBLE,
  "total30daysago" DOUBLE,
  "defillamaid" VARCHAR,
  "name" VARCHAR,
  "displayname" VARCHAR,
  "module" VARCHAR,
  "category" VARCHAR,
  "logo" VARCHAR,
  "protocoltype" VARCHAR,
  "methodologyurl" VARCHAR,
  "methodology" VARCHAR,
  "id" VARCHAR,
  "parentprotocol" VARCHAR,
  "linkedprotocols" VARCHAR,
  "doublecounted" VARCHAR,
  "latestfetchisok" VARCHAR
);