Dune Arcana is a live learning session that explores web3 news and trends using on-chain data.
This week, in honor of the ongoing `dex.trades` migration, we will cover the basics of AMM (automated market makers) and offer a starting point on what data analysis we can do with AMM's on-chain data.
Note: migration of `dex.trades` refers to the migration of `dex.trades` from Dune v1's Abstaction to Dune v2's Spellbook.
00:00 Intro
1:24 Exchanges
2:02 DEX vs CEX
3:44 AMM (Automated Market Making) vs Order Book
7:23 Price Discovery vs Price Oracle
10:01 CPMM (Constant Product Market Making)
11:23 CSMM (Constant Sum Market Making)
12:20 StableSwap
13:03 Concentrated Liquidity
16:07 Transition to On-Chain Analytics
17:59 Defining terminologies: Liquidity/TVL, Fees for LPs, Volume
23:24 Detailed SQL query walk-through: finding liquidity (TVL) and LP fees for top pairs (pools) [top pairs defined by the total USD volume in the entirety of history] on Uniswap v2 on Ethereum chain
40:32 AMA with Austin Adams, Research at Uniswap
_________________________________________________________________________________________________
Link to presentation: https://docs.google.com/presentation/...
Link to the dashboard: https://dune.com/duniversity/dune-arc...
Link to Miro board: https://miro.com/app/board/uXjVPKDb0u...
Austin Adams' Twitter: / austinadams10
Link to Spellbook doc: https://dune.com/docs/spellbook/
Link to dex.trades migration DeWork bounty board: https://app.dework.xyz/dune/dextrades...
Dune Discord: / discord