Dataset: DefiLlama Fees And Revenue

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.49 MB
315707 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

23.11 MB
132974 rows
39 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,
  "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,
  "latestfetchisok" BOOLEAN,
  "id" VARCHAR,
  "change_1d" DOUBLE,
  "change_7d" DOUBLE,
  "change_1m" DOUBLE,
  "change_7dover7d" DOUBLE,
  "parentprotocol" VARCHAR,
  "linkedprotocols" VARCHAR,
  "disabled" VARCHAR,
  "year" INTEGER,
  "month" INTEGER,
  "day" INTEGER
);

Fees And Revenue Overview By Chain

@defillama.fees.overview_fees_by_chain

23.81 MB
264339 rows
37 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,
  "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,
  "latestfetchisok" BOOLEAN,
  "id" VARCHAR,
  "parentprotocol" VARCHAR,
  "linkedprotocols" VARCHAR,
  "disabled" VARCHAR,
  "year" INTEGER,
  "month" INTEGER,
  "day" INTEGER
);