PapasotCopy of ALGO Transaction Payment Size
    Updated 2023-01-03
    with Algo_quantity as

    (select
    --date_trunc('day',block_timestamp) as block_day,
    block_timestamp,
    amount as Algo
    --count(tx_group_id) as number
    from algorand.payment_transaction
    where block_timestamp >= '2022-01-01' AND
    asset_id = 0 AND
    amount is not null
    )


    select
    date_trunc('day',block_timestamp) as block_day,
    count(Algo) as frequency,
    case
    when Algo between 0 and 10 then '0-10'
    when Algo between 10 and 100 then '10-100'
    when Algo between 100 and 1000 then '100-1000'
    when Algo between 1000 and 10000 then '1000-10000'
    else '10000'
    end as Buckets
    from Algo_quantity
    group by Buckets, block_day
    order by block_day ASC
    Run a query to Download Data