Original article: "Re-understanding DeFilama-a powerful data tool website"
Author: waynezhang.eth
What was your first query using DeFilama?
The first time I was assigned by the leader to query the potential DeFi task of the Avalanche ecosystem. Now that he has become a Big Aggragator, I will reintroduce its functions, how to use these data, and interesting data to you through this thread.
What you will gain from reading this article:
-Learn more about all the features of DeFillama
-Understand DeFi data & indicators: LTV, Delta neutral strategy, New Listed Projects
-Indicators & Methods for Finding DeFi Alpha
-How to use the corresponding indicators and derived indicators
- Check out DeFilama's novel data
-Data tool website recommendation
1.1DeFi-Overview
-TVL of the entire DeFi ecosystem
-Ranked by TVL protocol
- Can be ranked according to public chains
Lido became the first due to the ETH merger, with 99.2% of TVL coming from ETH
1.2DeFi-chains
- Ranking of public chains by TVL/number of protocols/change/number of stablecoins
- Can be classified according to EVM, Non-EVM, Rollup, Cosmos, Parachain
The changes in TVL 7D/1M are worth observing. There may be new projects released on the chain. DeFi is the ecological infrastructure, and stablecoins are the foundation of DeFi. The development of public chains can be observed from the perspective of DeFi.
1.3DeFi- Airdrops (Airdrops here means no token issuance)
- Sort DeFi protocols by fundraising time
This data is updated a bit slowly. It has a certain ability to find Alpha, but not much. It is recommended to consider it in combination with the total time of project launch.
1.4DeFi-Treasuries
- Sort by the total amount of the treasury, etc., and the proportion of various tokens in the treasury
The rich protocol = the fast development of the protocol? Not necessarily
But the protocol has a large number of its own tokens = small market circulation or DAO may become the largest seller of tokens
What happened between FTX and BIT DAO is worth learning from, and the risks that non-stablecoins bring to the treasury
1.5DeFi-Oracles
- Sorting using TVS (Total Value Secured)
- The protocol status of each oracle service
ChainLink is the undisputed king in this field. However, this data is not equal to the number of oracle services, and the data is highly ambiguous.
1.6DeFi-Forks
- See which protocols are copied the most
The forked ones are basically the leaders. It is recommended to conduct detailed research. At the same time, developers can check this list for new opportunities to try.
1.7DeFi-Top Protocols
- View the leaders in each DeFi segment of each public chain
-Scope includes: Liquid Staking, CDP, DEX, Lending, Yield, Bridge, Services, Algo-Stables
The leaders in the large public chain ecosystem are moving towards multi-chain, and the leaders in small/new ecosystems are also looking for larger markets through multi-chain.
Services lacking in public chains may become new opportunities. For example, who will be the CDP leader of Canto?
1.8DeFi-Comparison
-Supports selection of multiple protocols for TVL comparison based on timeline
Comparison with LSD on the same track might be useful.
This function can be expanded, for example, the comparison parameters can be changed to income, number of users, FDV, etc.
1.9DeFi-Token Usage
-You can query the usage of tokens in DeFi
This data should be on-chain data and is not complete. It will only show projects included in DeFillama.
Interesting data: There are 3.49 billion USTDT in JUSTLEND. What are they using it for?
1.10 DeFi- Category
-Number of DeFi projects in each category, TVL
DeFillama divides it into 31 categories, among which the number of agreements is less than 10, including Privacy, Oracle, Leveraged Farming, Uncollateralized Lending, Exotic Options, and RWA Lending. I think there may be some Alpha in the last four.
1.11DeFi- Recent
- Recently included projects
Note that this "recently" refers to being included rather than being directly launched on the main network, so there is a certain lag
1.12DeFi - Lauguage
-Proportion of different programming languages
- Language comparison by TVL
- The proportion of open source/non-open source protocols in the Solana ecosystem
If you want to know more details, you can check out @ElectricCapital’s data website https://www.developerreport.com/
2.1 Yields - Pools
- Order of liquidity pools ranked by TVL
- 5327 pools from 275 protocols on 59 chains
In addition to BTC, ETH and stablecoins, GLP ranked 11th and GMX ranked 13th are both from GMX
2.2 Yields-Delta Neutral
-Select the collateral token and then automatically select the strategy
-Strategy return is the total return of each strategy component
Currently, this function tracks relatively few pools and can only serve as a reference.
2.3 Long-short Strats
- Given a token, a delta-neutral “long-short” strategy will be displayed across all tracked pools and CEX perpetual swap markets.
-Annualized strategy returns are calculated taking into account CEX funding rates and DeFi yields.
The current CEX partner is OKX, while decentralized platforms include Venus, Ankr, WOOFi, etc.
2.4 Yields-Leveraged Lending
- Find Loop Apy, Supply Apy and LTV of different leveraged lending projects, current lending status and other data
- Includes 158 pools from 291 protocols on 23 chains
Compared with other chains, BNB chain has more projects and higher Loop Apy
2.5 Yields - Borrow
-Rank lending projects based on revenue, LTV, supply and usage, etc.
- Includes 777 liquidity pools from 291 protocols on 23 chains
2.6 Yields -Overview
- Search for median APY and distribution of individual coins
- You can check the APY of a certain currency in that project and that pool
-Visualized APY data comparison
Visualization panel, very suitable for use when making pledge data analysis reports
2.7 Yield - Stablecoins Pool
- Includes 422 pools from 275 protocols on 59 chains
- View the TVL and APY (Base APY, Reward APY, 30d Average APY) of each stablecoin pool
Basically, high APY is subsidized by the Reward Apy of the project token
In addition to Ethereum, some stablecoin pools have begun to appear in L2, which are worth paying attention to.
2.8 Yields-Halal
- Tracks 5,273 pools across 36 protocols on 59 chains
- Simple exchange DEX, yield farming, liquidity staking, bridging LPs
-How to understand Halal? I think it is a simple and safe pool.
Arrakis Finance's DAI-USDC TVL is $280.75M, and no tokens have been issued yet. Currently, the only income is Base Reward, and no tokens have been issued yet.
3.DeFilama Swap-Meta-Aggregator
-By aggregating multiple aggregators, we can provide the best transaction path query and enable direct transactions
- Calculate transaction results and various costs
- Customizable slippage
Some aggregators offer discounts. If you don’t mind the hassle, you can select the transaction route here and then go to the corresponding aggregator to see if you can get a discount.
4.Borrow Aggragator
- Given a token for collateral and a token for lending, this calculator will look at all lending protocols
- Calculate the cost of every borrow, taking into account incentives, supply APR and borrow APR,
- Provides a list of all possible borrowing options, their costs and LTV
5.CEX Transparency
- List of data such as inflow, outflow, net assets, etc. of centralized exchange assets
Currently, OKX has a net inflow ($241.63M) in a month, while Binane has a net outflow in a month, with a current outflow of $2.07B
From the current perspective, not all of the TOP5 net outflows flow into the TOP10 net inflows CEX, and there may be more than 1.5B assets on the chain now.
Please pay attention to the CEX with net inflow in the bear market, it may be worth paying attention to
6.Liquidation
-View the total liquidation amount of each protocol on each chain
- Amount of liquidation amount drops by 20%
- View the liquidation status of the 100 largest positions
The highest liquidation price (ETH/USD) of TOP 10 is $1,088.017, TOP 12 & TOP 15 are around $1290 respectively, and the special TOP 18 is $1547.
7.Volumes - Overview/Chains/Options
-Dexs trading volume daily/weekly/monthly ranking
- Ranking by chain by transaction volume, as well as change, TVL, market share, and cumulative transaction volume
-Options trading volume ranking, change, TVL, market share, cumulative trading volume (data is flawed)
In the current options market, Lyra’s trading volume accounts for more than 56% of the statistical data, making it an absolute leader.
8.Fee & Revenue
- List of projects ranked by income and expenses
The top 50 revenue categories are: Chain/Rollup (selling block space), DEX (handling fees), liquidity staking (reward fees), options/futures/lending transactions, NFT market/lending, CDP, Synthetics, Oracle
An interesting phenomenon is that FDV's tens of billions of dollars of projects only earn a few million dollars, and most of the revenue does not reach the holders.
9.1Raised-Overview
- Financing time sorted by time
- Financing scale, round number, introduction, valuation, lead and participating investors
9.2 Raises - Active investors
- Sort by number of shots taken within 30 days
- Investment project status
10. Stables-Overview
- The peg status, deployment status, and changes of various stablecoins
There are 6 cryptocurrencies with a value of more than 1B. The status of USDT and USDC remains unshaken.
Currently, there are 97 stablecoins listed by DeFilama alone.
The mainstream of the market is still the US dollar stablecoin, but some euro stablecoins have emerged
11.Stable-chains
- Sort by the size of stablecoins on the public chain
-Stablecoin project oligopoly on each chain, stablecoin/TVL ratio, number of bridges
12.Hacks
- Includes the time, cause, scale, and incident report of each hacker attack
In fact, many of them are due to the logic of the protocol, but most projects have actually been audited, and only a few are not audited in time when new functions are launched. I think decentralized insurance may be a potential point, but how to avoid the team's self-blackening is also a challenge
13.ETH Liquid Staking
-Number of pledged projects and LSD status, APR, etc.
Lido is in a decisive leadership position, but unshETH has been established for more than 7 days and has 86.05 ETH deposited
Hord's APR can reach 35.11%, which is shockingly high.
Some interesting little tools provided by DeFilama:
-roundup - A collection of various information and news compiled by DeFilama
-Trending Contracts: Query the contract interaction status in the past period of time (the default is 60 minutes, I tried 1 minute, but it didn’t refresh)
-Token Liquidity: Query the liquidity depth between tokens
In addition to DeFillama, there are some great websites worth recommending:
Dune.xyz: You can build your own or view on-chain charts made by big guys. Coingecko: In addition to coin prices and new coins, there are also coin pairs of decentralized and centralized exchanges, futures trading volume, etc. Gecko Terminal can even track the local dog pool. TwitterCcan: Generally used to see the social media activity and influence of the project. Google: All-purpose! In fact, the sexiest thing is the raw data. When you slowly sort it out and get the organized data or tables, you will feel the strongest sense of accomplishment. The data tool is just a guide to guide your thinking. Blockchain browser: Every blockchain has it. Don’t just think that it is a place where you can only check transactions. You can also check contracts and see which new mint NFTs/tokens are available. Due to space constraints, I can focus on it next time.