Blockchain Analytics with Dune
summary
Shows how Dune connects directly to Ethereum, Polygon, Optimism, BSC and Solana tables and runs SQL against on‑chain data to produce dashboards. Demonstrates sample queries such as daily transaction count query (last 30 days), distinct active wallet count via token transfer tables, and NFT sales volume for CryptoPunks, then assembles visuals (line, bar, heatmap, pie) into a gas‑tracker dashboard spanning July 2019–Jan 2024 that highlights gas and transaction spikes Aug 2020–Jun 2022 and Apr 2020–Jul 2022. Explains using window functions, CTEs and recursive queries and contrasts Dune’s direct access with PowerBI/Tableau.
AI-written summary · about
chapters (10)
- 0:00Blockchain analytics intro
- 2:24What blockchain analytics involves
- 3:48Dune Analytics tool
- 8:49Build custom dashboards
- 13:09Key metrics for analytics
- 14:36Case study dashboard
- 19:34Dune advantages
- 20:38Advanced Dune tips
- 21:44Dune's future
- 23:08Closing & Q&A
related talks
18mAnalytics at Scale V02
37mPanel: The Hidden Value behind Cryptoanalytics
41mExploring four hidden superpowers of Datomic
06mDelighting users with RESTful APIs and DuckDB
32m"BI and Reporting for Datomic"
39mEmbedded Analytics through Data API
42mDriving Data Democratization
24mData Pipelines to Dashboards