How To Analyze Any Ethereum Protocol or Product In Five Minutes
Day 12 (12 Days of Dune): Clustering all USDC Uniswap v2 pairs based on liquidity stability
Day 11 (12 Days of Dune): The volatility of liquidity (k) and prices, compared.
Day 10 (12 Days of Dune): Calculating price impact and total liquidity for USDC/WETH in Uniswap v2
Basic Wizard Guide to Dune SQL and Ethereum Data Analytics
Day 9 (12 Days of Dune): Calculating the percent of USDC reserves in USDC/WETH pair versus all other pairs
Day 8 (12 Days of Dune): Diversity of liquidity sources in USDC/WETH?
Day 7 (12 Days of Dune): Analyzing liquidity added and removed from USDC/WETH in Uniswap v2
Day 6 (12 Days of Dune): Clustering all USDC pairs in Uniswap by Usage
Day 5 (12 Days of Dune): Identifying sources of swaps as contracts or EOAs
Day 4 (12 Days of Dune): Identifying MEV bot/arbitrage transactions in Uniswap v2
Day 3 (12 Days of Dune): Finding pair reliance in Uniswap Swap Routing
Day 2 (12 Days of Dune): Finding total volume and swap frequency for Uniswap v2 (USDC/WETH)
Day 1 (12 Days of Dune): Finding all pairs for ERC20 tokens in Uniswap v2
Become a (better) web3 data wizard before the New Year!
(7) Composability Series: Web3 Scores, Stacks, and Algorithms
Web3 Data Guide: Sudoswap
(6) Composability Series: Web3 Community Monetization and Membership
Learning to Work With Ethereum Storage and State Data
[2022 Annual Guide] Web3 Data Thinking, Tools, and Teams