The Blockchain Doesn’t Know What TVL Is

Release: 2026/06/02 21:00 Reading: 0

Original author：SashaOnChain

Original source：https://www.youtube.com/embed/3gxPID2G4UA

The Blockchain Doesn’t Know What TVL Is | Crypto SQL Advanced #6 Most people look at DeFi TVL like it’s a real number stored somewhere on-chain. It’s not. In this video we rebuild TVL from scratch using raw blockchain data — step by step — exactly like an on-chain analyst would do it. We take Aave V3 as an example and reconstruct liquidity flows using SQL inside Dune Analytics. Chapters: 00:00 - The illusion of TVL 00:17 - Picking Aave V3 as a case study 00:33 - Step 1: Collecting token flows (deposits, withdrawals, borrows, repays) 02:20 - Step 2: Turning flows into real state (window functions) 02:50 - Step 3: Pricing tokens into USD 03:30 - Step 4: Building final TVL metric 04:03 - Why our numbers differ from DeFiLlama 04:20 - Outro Tools used: Dune Analytics #duneanalytics #sql #onchainanalytics #education #blockchain

Previous：Why Elite Traders Are Secretly Moving To Bitget Next：THE BFMTV FORUM - Urban violence: the big fed up

Recent news

MORE>>

Selected Topics

Dogecoin whale activity

Get the latest insights into Dogecoin whale activities with our comprehensive analysis. Discover trends, patterns, and the impact of these whales on the Dogecoin market. Stay informed with our expert analysis and stay ahead in your cryptocurrency journey.
Dogecoin Mining

Dogecoin mining is the process of adding new blocks of transactions to the Dogecoin blockchain. Miners are rewarded with new Dogecoin for their work. This topic provides articles related to Dogecoin mining, including how to mine Dogecoin, the best mining hardware and software, and the profitability of Dogecoin mining.
Spacex Starship Launch

This topic provides articles related to SpaceX Starship launches, including launch dates, mission details, and launch status. Stay up to date on the latest SpaceX Starship launches with this informative and comprehensive resource.
King of Memes: Dogecoin

This topic provides articles related to the most popular memes, including "The King of Memes: Dogecoin." Memecoin has become a dominant player in the crypto space. These digital assets are popular for a variety of reasons. They drive the most innovative aspects of blockchain.

Selected Articles

More>>