COUNT(tx_hash) AS "Total Swaps",

COUNT(DISTINCT swapper) AS "Total Traders",

SUM(coalesce(amount_in_usd, 0) + coalesce(amount_out_usd, 0)) AS "Total Volume (USD)",

AVG(coalesce(amount_in_usd, 0) + coalesce(amount_out_usd, 0)) AS "Average Swap Size (USD)",

MAX(coalesce(amount_in_usd, 0) + coalesce(amount_out_usd, 0)) AS "Largest Swap (USD)"

FROM aptos.defi.ez_dex_swaps

WHERE token_in = '0xe4ccb6d39136469f376242c31b34d10515c8eaaa38092f804db8e08a8f53c5b2::assets_v1::EchoCoin002'

OR token_out = '0xe4ccb6d39136469f376242c31b34d10515c8eaaa38092f804db8e08a8f53c5b2::assets_v1::EchoCoin002';