Trend of Pools

    What kind of pools do user usually withdraw or deposit into for the last 90 days? is there any pattern/trend we can see from it?

    Method

    • I used ez_dex_swaps table of ethereum_core
    • by filtering PLATFORM in ('sushiswap') I found related data to sushiswap.
    • my date range is between ('2022-02-16' , '2022-05-16')

    by looking at top 10 pools, we can say users like to use pools that have a stable coin on one side of that pool.

    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    In the given bar chart you can see 10 top pools by most Amount_in.

    USDC and USDT are stable coin pools. most deposits and withdraws are happened on these pools.

    In the next 2 charts, we can compare the number of users and the number of their transactions in different pools.

    by looking at the next chart, we can say on all days except the 20th of April, people usually used WETH-USDC and WETH-USDT pools, but in the 20th of April they suddenly used USDC-DSD pool.

    And finally, we found out that USDC-WETH pool is the most popular pool and people have more interact with this pool(regarding to number of users and number of transactions)