PapasotCopy of Rand Gallery buyers
    Updated 2023-01-03
    select
    sender,
    sum(amount) as Volume,
    count(tx_group_id) as NFT_purchases,
    min(block_timestamp) as first_tx
    from algorand.payment_transaction
    where
    receiver = 'RANDGVRRYGVKI3WSDG6OGTZQ7MHDLIN5RYKJBABL46K5RQVHUFV3NY5DUE'
    and
    TX_GROUP_ID is not null
    and
    amount is not null
    group by 1
    having min(block_timestamp) > CURRENT_DATE - 600
    order by first_tx
    Run a query to Download Data