when swap_from_amount > 0 and swap_from_amount < 10 then '1. Shrimp 0-10' -- Not account for withdrawals

when swap_from_amount >= 10 and swap_from_amount < 100 then '2. Crab 10-100'

when swap_from_amount >= 100 and swap_from_amount < 500 then '3. Octopus 100-500'

when swap_from_amount >= 500 and swap_from_amount < 1000 then '4. Fish 500-1k'

when swap_from_amount >= 1000 and swap_from_amount < 10000 then '5. Dolphin 1k-10k'

when swap_from_amount >= 10000 and swap_from_amount < 100000 then '6. Shark 10k-100k'

when swap_from_amount >= 100000 and swap_from_amount < 1000000 then '7. Whale 100k-1M'

when swap_from_amount >= 1000000 then '8. Humpback >1M' else null end as tier,

count(distinct swapper) as number_of_users

from algorand.swaps

where swap_program in ('tinyman', 'algofi', 'pactfi')

and block_timestamp::date >= '2022-04-01' and swap_from_asset_id = 0 and swap_from_amount > 0

group by 1, 2