PLATFORM,

origin_from_address,

count(DISTINCT(tx_hash)) as total_swaps,

sum(AMOUNT_IN_USD) as volume

from ethereum.core.ez_dex_swaps

where amount_in_usd < 1000000 and block_timestamp::date >= '2022-01-01'

group by 1,2)

select

PLATFORM, count(DISTINCT(origin_from_address)) as total,

case when volume <= 1 then 'Up to 1$'

when volume < 10 then '1-10$'

when volume < 100 then '10-100$'

when volume < 1000 then '100-1K$'

when volume < 10000 then '1K-10K$'

when volume > 100000 then '10K-100K$' end as type

from swaps

group by 1,3