CONCAT(symbol_out, '-', symbol_in) AS token_pair,

SUM(amount_in_usd) AS amountUsd

FROM avalanche.defi.ez_dex_swaps

WHERE token_out = '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e'

AND amount_in_usd != 0

AND block_timestamp >= '2024-01-01'

AND block_timestamp <= '2024-12-31'

GROUP BY token_pair

ORDER BY amountUsd DESC;

limit 10;