The Blockchain Doesn’t Know What TVL Is

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