symbol_in || '🔛' || symbol_out AS swap_pair,

SUM(COALESCE(amount_in_usd, 0)) AS total_volume

avalanche.defi.ez_dex_swaps

block_timestamp >= '2024-01-01'

AND block_timestamp <= '2024-12-31'

AND platform = 'uniswap-v3'

GROUP BY

swap_pair

ORDER BY

total_volume DESC

LIMIT 5;