paired_token_symbol,

num_swaps,

CASE

WHEN total_swap_volume_usd >= 1000000000 THEN CONCAT('$', ROUND(total_swap_volume_usd / 1000000000, 2), 'B')

WHEN total_swap_volume_usd >= 1000000 THEN CONCAT('$', ROUND(total_swap_volume_usd / 1000000, 2), 'M')

WHEN total_swap_volume_usd >= 1000 THEN CONCAT('$', ROUND(total_swap_volume_usd / 1000, 2), 'K')

ELSE CONCAT('$', ROUND(total_swap_volume_usd, 2))

END AS formatted_swap_volume

FROM (

SELECT

CASE

WHEN token_in = LOWER('0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E') THEN symbol_out

WHEN token_out = LOWER('0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E') THEN symbol_in

END AS paired_token_symbol,

COUNT(*) AS num_swaps,

SUM(amount_in_usd) AS total_swap_volume_usd

FROM

avalanche.defi.ez_dex_swaps

WHERE

token_in = LOWER('0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E')

OR token_out = LOWER('0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E')

GROUP BY paired_token_symbol

ORDER BY total_swap_volume_usd DESC;