PapasotRand Gallery buyers histogram
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
with NFT_buyers as (
select
sender as NFT_buyers,
count(tx_group_id) as NFTs
from algorand.payment_transaction
where
receiver = 'RANDGVRRYGVKI3WSDG6OGTZQ7MHDLIN5RYKJBABL46K5RQVHUFV3NY5DUE'
and
TX_GROUP_ID is not null
and
block_timestamp > '2021-06-01'
group by sender
order by NFTs desc)
select
count(NFT_buyers),
case
when NFTs between 0 and 1 then '1 NFT'
when NFTs between 1 and 10 then '1-10 NFTs'
when NFTs between 10 and 100 then '10-100 NFTs'
else '100+ NFTs'
end as Buckets
from NFT_buyers
group by Buckets
Order by Buckets
Run a query to Download Data