Overview

In this dashboard we wanna see what is the behavior of TOKE holders on Toke dex pools

Goals

• Show largest Toke dex pools by volume
• Show behavior of TOKE holders on these pools

Need to know

• TOKE contract : 0x2e9d63788249371f1DFC918a52f8d799F4a38C94

Analyze

• First i used dim_dex_liquidity_pools table and filtered token0,token1 columns by Toke contract to find out pool name and pool address and platform then joined erc20_balances to get USD volume of each pool and order by largest
• Then used fact_event_logs table and filtered CONTRACT_ADDRESS column to get number of transactions group by each event name

Conclusion

As you saw largest dex pools are TOKE-WETH SLP belongs to Sushiswap and TOKE-WETH UNI belongs to Uniswap v2,also around 78 percent of Toke holders used these pools for swapping