Welcome to this data analytics dashboard, In this dashboard, we will focus on analyzing the trading activity of one specific pool that includes USDC, a stablecoin that is pegged to the US dollar.

This dashboard provides analysis of the daily volume of transactions for both USDC swaps and token swaps in the chosen pool. We will showcase the daily volume of transactions where USDC was swapped for the other token, as well as the daily volume of transactions where the token was swapped for USDC.

Furthermore, we will provide an aggregate daily total swap volume of the chosen pool and the daily number of transactions that used this pool.

Below you can see all Uniswap v3 pools ordered by balance

In this dashboard I used ethereum.uniswapv3.ez_pool_stats table to find all the Uniswap v3 pools. This table contains basic information about all Uniswap v3 pools, so I was able to sort the pools by their balance (TVL) as sum of token0_balance_usd + token1_balance_usd which you can see above.

To get all the neccessary information about transactions, their volume and users in this pool, I used ethereum.core.ez_dex_swaps table. When querying from this table, I used block_timestamp to get the day, ORIGIN_FROM_ADDRESS as users and amount_in_usd to get the transactions volume in usd.

In this dashboard:

• Transactions 💱
• Volume 💰
• Users 🧑
• Correlations 📊📈
• Conclusion

Note: You can adjust the number of days for which you want to display the charts at the top, don't forget to click Apply Parameters

🐦 twitter.com/mondov_dev