CASE

WHEN swap_from_amount_usd BETWEEN 10 AND 99 THEN '10-99'

WHEN swap_from_amount_usd BETWEEN 100 AND 499 THEN '100-499'

WHEN swap_from_amount_usd BETWEEN 500 AND 999 THEN '500-999'

WHEN swap_from_amount_usd BETWEEN 1000 AND 5000 THEN '1000-5000'

ELSE '5000+'

END AS volume_range,

SUM(swap_from_amount_usd) AS volume_swapped,

COUNT(DISTINCT swapper) AS swappers

FROM solana.defi.ez_dex_swaps

WHERE block_timestamp BETWEEN '{{start_date2}}' AND '{{end_date2}}'

AND swap_from_symbol = '{{token2}}'

AND swap_from_amount_usd >= 10

GROUP BY volume_range

ORDER BY volume_range;