Crazy_KidALGO Transaction Payment Size 2
    Updated 2022-03-31
    SELECT CASE WHEN amount <= 10 THEN '0 - 10'
    WHEN amount >10 AND amount <= 100 THEN '10+ - 100'
    WHEN amount >100 AND amount <= 1000 THEN '100+ - 1000'
    WHEN amount >1000 AND amount <= 10000 THEN '1000+ - 10000'
    ELSE '10000+'
    END AS asset_range, COUNT(DISTINCT tx_id) as tx_count
    FROM algorand.payment_transaction
    WHERE asset_id = 0 AND date(block_timestamp) >= '2022-01-01'
    GROUP BY asset_range
    ORDER BY asset_range
    Run a query to Download Data