origin_from_address AS "user_address",

SUM(amount_in_usd) AS "total_swap_volume",

CASE

WHEN SUM(amount_in_usd) BETWEEN 1 AND 100 THEN '1 - 100'

WHEN SUM(amount_in_usd) BETWEEN 101 AND 500 THEN '101 - 500'

WHEN SUM(amount_in_usd) BETWEEN 501 AND 1000 THEN '501 - 1000'

WHEN SUM(amount_in_usd) BETWEEN 1001 AND 5000 THEN '1001 - 5000'

WHEN SUM(amount_in_usd) BETWEEN 5001 AND 10000 THEN '5001 - 10000'

WHEN SUM(amount_in_usd) > 10000 THEN '10001+'

ELSE '0'

END AS "volume_category",

COUNT(DISTINCT tx_hash) AS "total_swaps"

avalanche.defi.ez_dex_swaps

block_timestamp >= '2024-01-01'

AND block_timestamp <= '2024-12-31'

GROUP BY

origin_from_address

ORDER BY

"total_swap_volume" DESC;