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

2.93 MB
399291 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

27.2 MB
126610 rows
35 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,
  "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,
  "change_7dover7d" DOUBLE,
  "change_30dover30d" DOUBLE,
  "parentprotocol" VARCHAR,
  "linkedprotocols" VARCHAR
);

Fees And Revenue Overview By Chain

@defillama.fees.overview_fees_by_chain

28.07 MB
263240 rows
34 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,
  "latestfetchisok" VARCHAR
);