SELECT
symbol_in,
SUM(COALESCE(amount_in_usd, 0)) AS total_volume_in
FROM
avalanche.defi.ez_dex_swaps
WHERE
block_timestamp >= '2024-01-01'
AND block_timestamp <= '2024-12-31'
AND platform = 'uniswap-v3'
GROUP BY
symbol_in
ORDER BY
total_volume_in DESC
LIMIT
5;