PapasotRand Gallery buyers histogram
    Updated 2023-01-03
    with NFT_buyers as (

    select
    sender as NFT_buyers,
    count(tx_group_id) as NFTs
    from algorand.payment_transaction
    where
    receiver = 'RANDGVRRYGVKI3WSDG6OGTZQ7MHDLIN5RYKJBABL46K5RQVHUFV3NY5DUE'
    and
    TX_GROUP_ID is not null
    and
    block_timestamp > '2021-06-01'

    group by sender
    order by NFTs desc)

    select
    count(NFT_buyers),
    case
    when NFTs between 0 and 1 then '1 NFT'
    when NFTs between 1 and 10 then '1-10 NFTs'
    when NFTs between 10 and 100 then '10-100 NFTs'
    else '100+ NFTs'
    end as Buckets
    from NFT_buyers
    group by Buckets
    Order by Buckets
    Run a query to Download Data