SQL Dune Analytics Python DeFi
Overview
Built comprehensive Dune Analytics dashboards for on-chain token flow analysis, protocol health monitoring, and DeFi ecosystem metrics across Ethereum and L2 networks.
Key Dashboards
Token Flow Analysis
- Tracked whale wallet movements and accumulation patterns for major tokens
- Visualized DEX trading volume distribution across Uniswap, Curve, and Balancer
- Monitored token unlock schedules and their correlation with price action
Protocol Health Metrics
- Built TVL tracking dashboards across major DeFi protocols
- Analyzed liquidity depth and utilization rates for lending protocols (Aave, Compound)
- Tracked governance participation rates and proposal outcomes
L2 Ecosystem Analytics
- Compared transaction volume and unique address growth across L2 networks
- Monitored bridge inflow/outflow patterns between L1 and L2
- Analyzed gas cost savings and sequencer revenue metrics
Technologies
- Query Engine: Dune Analytics SQL (Dune V2 / DuneSQL)
- Data Processing: Python (pandas, web3.py) for supplementary analysis
- Visualization: Dune native charts, custom Matplotlib exports
- Data Sources: On-chain decoded tables, price feeds, protocol-specific tables
Results
Dashboards used for internal research decision-making, providing actionable insights on token dynamics, protocol adoption trends, and L2 ecosystem growth patterns.