WITH dex_swap AS (

SELECT

SUM(amount_in_usd) AS amount, sender,

COUNt(DISTINCT tx_hash) as transact_count

FROM

blast.defi.ez_dex_swaps

WHERE

(

token_in = '0x4300000000000000000000000000000000000003'

OR token_out = '0x4300000000000000000000000000000000000003'

)

AND amount_in_usd != 0

GROUP BY sender

SELECT

CASE

WHEN amount < 500 THEN '< $500'

WHEN amount BETWEEN 500 AND 2000 THEN '$500 - $2000'

WHEN amount BETWEEN 2000 AND 5000 THEN '$2000 - $5000'

WHEN amount BETWEEN 5000 AND 10000 THEN '$5000 - $10000'

ELSE '> $10000'

END AS volume_range,

COUNT(DISTINCT sender) AS user_count

FROM

dex_swap

GROUP BY

volume_range

ORDER BY

volume_range;