Day 3: How to find top routing paths that use a USDC/WETH in Uniswap v2
Make sure to follow the teachers on Twitter (Andrew @andrewhong5297 and Jackie @agaperste)
Subscribe to this newsletter (https://web3datadegens.substack.com/) for written explanations of each query and more future data guides/tips!
⚠️ For all the `Router02_call_swap` tables, we also need to filter for `where call_success` to only consider successful txns that routed thru USDC/WETH. Apologies for the oversight and potential confusion! (This is relevant for minute 3:20 to 4:20 content)
Answer: https://dune.com/queries/1747778 (updated to reflect only successful swap calls)
Resources and links:
Course notion doc: https://www.notion.so/12-Days-of-Dune...
Quickstart dashboard: https://dune.com/duniversity/contract...
Playing with uniswap: https://app.uniswap.org/#/swap
Understanding protocol concepts: https://docs.uniswap.org/contracts/v2...
Open zeppelin ERC20 overview: https://docs.openzeppelin.com/contrac...
Dune links:
https://dune.com/browse/dashboards
https://dune.com/docs/getting-started/
• Automated Market Maker (AMM) | Dune Arcana #5
00:00 - 00:24 Question introduction
00:25 - 01:41 Query logical overview
01:42 - 18:16 Query walkthrough
18:17 - 18:52 Bonus challenge
18:53 - 19:10 Tomorrow's question