Sandeshrand top
Updated 2022-05-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
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