TVL & fees per protocol

Description

This dataset provides daily information on various DeFi protocols, encompassing data from 35 protocols across 5 categories. The DataFrame includes fields such as chain, date, totalLiquidityUSD, fees, category, and project. The primary key for this dataset is a combination of chain, date, and project. The categories covered in this dataset are as follows:

• Liquid Staking: lido, rocket-pool, binance-staked-eth, mantle-staked-eth, frax-ether.

• Dexes: uniswap-v3, curve-dex, uniswap-v2, pancakeswap-amm, balancer-v2, pancakeswap-amm-v3, sushiswap and thorchain

• Yield: convex-finance, stakestone, aura, pendle, coinwind, penpie

• Lending: aave-v3, aave-v2, spark, compound-v3, compound-v2, morpho-aave, morpho-aavev3, benqi-lending, radiant-v2

• Yield Aggregator: yearn-finance, beefy, origin-ether, flamincome, sommelier

Collection method

The information was obtained from Defillama API. Subsequently, a manual preprocessing was performed to filter out the protocols based on their TVL and the availability of sufficient historical data, not only from TVL, but also from other fields that can be found in other datasets provided by Giza (TVL for each token by protocol, Top pools APY per protocol and Tokens OHCL price).

Schema

• chain: The blockchain network where the protocol is deployed. In some cases, this feature not only specifies the blockchain network but also includes certain suffixes like "staking" or "borrowed" for some protocols. These suffixes provide deeper insights into the specific nature of the protocol's operations on that blockchain.

• date: The date of the data snapshot, recorded daily.

• totalLiquidityUSD: Total value locked in USD.

• fees: Fees generated by the protocol.

• category: The category of the protocol (e.g., Liquid Staking, Dexes).

• project: The specific DeFi project or protocol name.

The primary key consists of a combination of chain, date, and project, ensuring each row provides a unique snapshot of a project's daily performance.

Potential Use Cases

• Market Analysis: Assessing the market share and growth of different DeFi categories and projects.

• Trend Identification: Spotting trends in liquidity and fee generation across various blockchains.

• Data Integration: Merging with other detailed datasets for each primary key to gain deeper insights into individual protocols.

• Investment Decision Making: Assisting investors and analysts in making informed decisions based on liquidity trends and project performance.

Use example

from giza_datasets import DatasetsLoader

# Usage example:
loader = DatasetsLoader()
df = loader.load('tvl-fee-per-protocol')

df.head()

chain	date	totalLiquidityUSD	fees	category	project
"ethereum"	2020-12-20	2.6976e6	0	"Liquid Staking"	"lido"
"ethereum"	2020-12-21	1.2120e7	0	"Liquid Staking"	"lido"
"ethereum"	2020-12-21	1.1057e8	0	"Liquid Staking"	"lido"
"ethereum"	2020-12-21	1.2109e8	0	"Liquid Staking"	"lido"
"ethereum"	2020-12-21	2.2668e8	0	"Liquid Staking"	"lido"