PapasotRand Gallery top 10 NFTs buyers last 30 days
    Updated 2023-01-03
    select
    sender as NFT_buyers,
    count(distinct tx_group_id) as NFTs,
    sum(amount) as fee_paid
    from algorand.payment_transaction
    where
    receiver = 'RANDGVRRYGVKI3WSDG6OGTZQ7MHDLIN5RYKJBABL46K5RQVHUFV3NY5DUE'
    and
    TX_GROUP_ID is not null
    and
    block_timestamp > CURRENT_DATE - 31
    and
    amount is not null

    group by sender
    order by NFTs desc
    limit 10
    Run a query to Download Data