shadilALGO Transaction Payment Size
    Updated 2022-03-28
    SELECT
    date(block_timestamp) as date,
    case
    when amount > 0 and amount <= 10 then '0-10'
    when amount > 10 and amount <= 100 then '0-100'
    when amount > 100 and amount <= 1000 then '0-1000'
    when amount > 1000 and amount <= 10000 then '0-10000'
    when amount > 10000 then '>10000'
    end as algo_amount,
    COUNT(DISTINCT tx_id) as counter
    from algorand.payment_transaction
    where amount is NOT NULL
    AND date(block_timestamp) BETWEEN '2022-01-01' and CURRENT_DATE - 1

    GROUP BY date, algo_amount
    ORDER BY date
    Run a query to Download Data