COUNT(DISTINCT tx_hash) AS number_swaps,

SUM(AMOUNT_IN) AS swap_volume,

AVG(AMOUNT_IN) AS average_swap_volume,

COUNT(DISTINCT Swapper) AS number_of_traders,

swap_volume/ number_of_traders as volume_per_trader,

Number_swaps / number_of_traders as swaps_per_trader

FROM aptos.defi.ez_dex_swaps

WHERE

TOKEN_IN = '0xe1d39a72bd69bc2ebfe008bb925badb23a32883b077218b9e167f74cf703db1a::uptos::UptosCoin' OR TOKEN_OUT = '0xe1d39a72bd69bc2ebfe008bb925badb23a32883b077218b9e167f74cf703db1a::uptos::UptosCoin'