with swappers as (

swapper,

sum(amount_in_usd) as volume

from aptos.defi.ez_dex_swaps

where platform = 'liquidswap'

and block_timestamp >= dateadd(month, -{{month}}, current_date)

group by swapper

case when volume < 1 then '< $1'

when volume >= 1 and volume < 10 then '$1 - $10'

when volume > 10 and volume <= 100 then '$10 - $100'

when volume > 100 and volume <= 1000 then '$100 - $1,000'

when volume > 1000 and volume <= 10000 then '> $1,000 - $10,000'

else '> $10,000'

end as batch,

count(distinct swapper) as swappers

from swappers

group by batch

order by swappers desc