symbol_IN,

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,

SUM(AMOUNT_IN) / COUNT(DISTINCT Swapper) AS volume_per_trader,

COUNT(DISTINCT tx_hash) / COUNT(DISTINCT Swapper) AS swaps_per_trader

FROM aptos.defi.ez_dex_swaps

WHERE

symbol_IN IN ('USDT', 'APT', 'USDC', 'USDD', 'USDA', 'BUSD', 'FRAX')

GROUP BY symbol_IN;