Sandeshrand top
    Updated 2022-05-05
    with nft_trans as (
    select * from algorand.payment_transaction
    where RECEIVER='RANDGVRRYGVKI3WSDG6OGTZQ7MHDLIN5RYKJBABL46K5RQVHUFV3NY5DUE'
    ),
    all_nft_txn as (
    select tx_group_id, max(amount) as sale_amount
    from algorand.payment_transaction
    where tx_group_id in (
    select distinct tx_group_id from nft_trans
    )
    and RECEIVER !='RANDGVRRYGVKI3WSDG6OGTZQ7MHDLIN5RYKJBABL46K5RQVHUFV3NY5DUE'
    group by tx_group_id
    )
    select count(distinct tx_group_id) as number_of_sales,
    sum(sale_amount) as total_volume_in_algos from all_nft_txn
    where sale_amount >0



    Run a query to Download Data