On-Chain Analytics: Reading the Tape
How to query blockchains for real signal — wallet labeling, flow analysis, whale-watching, and protocol-level metrics that actually predict outcomes.
4 lessons · 2 hr 45 min · advanced
- 1The Block Explorer as a MicroscopeEtherscan beyond "did the tx confirm". Tracing flows, internal transactions, decoding event logs, ENS, and sister explorers.30 min
- 2Dune & Nansen: Query-First AnalyticsDune SQL queries and dashboards, Nansen Smart Money labels and Wallet Profiler, Arkham entity graphs, DefiLlama TVL and revenue, Token Terminal financial-statement view.40 min
- 3Whales, Smart Money, and Cohort AnalysisFollowing capital flows. The pitfalls of follow-trading. Cohort retention, diamond hands vs flippers, and real-world cases (Wintermute, 3AC, Bybit Lazarus).35 min
- 4Protocol Health Metrics That MatterBeyond TVL: net deposits, fees, revenue (P/S, P/E), retention curves, true vs sybil DAU, fake TVL via recursion and points farming, and real benchmarks for Aave, Uniswap, Hyperliquid, GMX.30 min
Educational only — not financial advice.