Blockchain Analytics Course - 1 . Comparing DEXes
Comparison on Polygon
The following information can be inferred from following charts, the following charts are interactive, by clicking on legend you can see individual charts:
- On Polygon, both platforms swap count and user count didn’t change much, they have a similar pattern.
- There are surges that happened on both platforms, like user count on June 27.
- There are days that one platform surges and the other don’t see much change, like swap count on July 27.
- On Aug 12 and 13, both platforms seen significant decrease.
Comparison on Ethereum
The following information can be inferred from following charts, the following charts are interactive, by clicking on legend you can see individual charts:
- Uniswap daily user count and daily swap count has increased.
- Sushiswap daily swap count has been ranging.
- On June 12, there is a surge on both platforms.
- On July 18 and Aug 8, there a surge on Uniswap while there is very small increase on Sushiswap.
Approach
Data Source
In order to acquire blockchain data, we are using Flipside Crypto data source.
Tables
From said data source, following tables are used:
ethereum.core.ez_dex_swaps
→ We can easily use this table to access swaps.
polygon.core.fact_event_logs
→ On Polygon chain there is no easy swap table, so we are using blockchain level events.
Contracts
On Polygon, we need to use the contract addresses extracted from Uniswap and Sushiswap docs,
-
Uniswap Contracts:
- 0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45
- 0xe592427a0aece92de3edee1f18e0157c05861564
-
Sushiswap Contracts:
- 0x1b02da8cb0d097eb8d57a175b88c7d8b47997506
- 0xc5017be80b4446988e8686168396289a9a62668e
Study Period
The study is conducted from 2022-06-01.