DefiLlama Fees And Revenue by DefiLlama | Crypto and Blockchain

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.77 MB
356189 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

4.32 MB
20290 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,
  "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,
  "latestfetchisok" BOOLEAN,
  "id" VARCHAR,
  "change_1d" DOUBLE,
  "change_7d" DOUBLE,
  "change_1m" DOUBLE,
  "change_7dover7d" DOUBLE,
  "change_30dover30d" DOUBLE,
  "parentprotocol" VARCHAR,
  "linkedprotocols" VARCHAR,
  "disabled" VARCHAR
);

Fees And Revenue Overview By Chain

@defillama.fees.overview_fees_by_chain

4.45 MB
41870 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,
  "total30d" DOUBLE,
  "total1y" DOUBLE,
  "totalalltime" DOUBLE,
  "average1y" DOUBLE,
  "change_1d" DOUBLE,
  "change_7d" DOUBLE,
  "change_7dover7d" DOUBLE,
  "total7daysago" DOUBLE,
  "defillamaid" VARCHAR,
  "name" VARCHAR,
  "displayname" VARCHAR,
  "module" VARCHAR,
  "category" VARCHAR,
  "logo" VARCHAR,
  "protocoltype" VARCHAR,
  "methodologyurl" VARCHAR,
  "methodology" VARCHAR,
  "latestfetchisok" BOOLEAN,
  "id" VARCHAR,
  "total60dto30d" DOUBLE,
  "change_1m" DOUBLE,
  "change_30dover30d" DOUBLE,
  "total30daysago" DOUBLE,
  "parentprotocol" VARCHAR,
  "linkedprotocols" VARCHAR,
  "disabled" VARCHAR
);