select

block_timestamp,

coalesce(amount, 0) as amount

from algorand.payment_transaction

where block_timestamp::date >= '2022-01-01'

),

transaction_count as (

select

date_trunc('day', block_timestamp) as time,

case

when 10 > amount then '1. 0 - 10 Algo'

when 100 > amount >= 10 then '2. 10 - 100 Algo'

when 1000 > amount >= 100 then '3. 100 - 1000 Algo'

when 10000 > amount >= 1000 then '4. 1000 - 10000 Algo'

when amount >= 10000 then '5. 10000+ Algo'

end as category,

count(*) as number_of_transactions,

sum(amount) as volume

from transactions

group by time, category

select * from transaction_count

order by time, number_of_transactions