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