SYMBOL_IN AS meme_coin,

SUM(DISTINCT amount_in_usd) AS total_volume_usd,

count (DISTINCT tx_hash) as transactions_traded,

count (DISTINCT origin_from_address) as Number_Of_Traders,

AVG(DISTINCT amount_in_usd) as Average_volume

FROM

avalanche.defi.ez_dex_swaps

WHERE

block_timestamp >= '2024-01-01'

and

SYMBOL_IN IN ('COQ', 'KIMBO', 'WOLF', 'GEC', 'NOCHILL')

GROUP BY

SYMBOL_IN

ORDER BY

total_volume_usd DESC