binhachonALGO Transaction Payment Size
    Updated 2022-03-27
    with transactions as (
    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


    Run a query to Download Data