12 Days of Dune (Uniswap)

Become a (better) wizard in just 12 days, learning from twelve increasingly-difficult queries which cover Uniswap v2.

Badge icon

12 Days of Dune (Uniswap): Student

Polygon logo

Course structure

  • i

    Welcome!

  • i

    Intro Video

  • i

    Day 1: Finding all pairs for an ERC20 token in Uniswap V2

  • i

    Day 2: Find total volume and frequency of swaps for Uniswap v2 Pair

  • i

    Day 3: Showing top paths that route through USDC/WETH Uniswap v2

  • i

    Day 4: Finding MEV/Bot transactions in all Swaps

  • i

    Day 5: Identifying sources of trading volume (using traces)

  • i

    Day 6: Clustering USDC Pairs by Usage (Section 1 finished)

  • i

    Day 7: Liquidity provider activity analysis for USDC/WETH

  • i

    Day 8: Liquidity Provider diversity (concentration) of sources in PAIr

  • i

    Day 9: Percent Liquidity Token Reserves across all pairs

  • i

    Day 10: Total Liquidity and Price Impact calculations

  • i

    Day 11: Volatility of liquidity (k) and prices, compared

  • i

    Day 12: Clustering all USDC Uniswap v2 Pairs

  • i

    Congrats on making it through the course!

Completion history

  • +16257

Subscribe to our newsletter