mohammadh1 ) Cryptopunk Sales and Traders(top 10 for nft count)
Updated 2022-08-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with A as (select
NFT_FROM_ADDRESS as seller,
TOKENID
from ethereum.core.ez_nft_transfers
where(PROJECT_NAME = 'cryptopunks' and NFT_ADDRESS = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb' or NFT_ADDRESS='0xb7f7f6c52f2e2fdb1963eab30438024864c313f6' and PROJECT_NAME='wrapped cryptopunks')),
B as (select
NFT_TO_ADDRESS as buyer,
TOKENID
from ethereum.core.ez_nft_transfers
where (PROJECT_NAME = 'cryptopunks' and NFT_ADDRESS = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb' or NFT_ADDRESS='0xb7f7f6c52f2e2fdb1963eab30438024864c313f6' and PROJECT_NAME='wrapped cryptopunks'))
select
buyer as holder,
count(distinct B.TOKENID) - count(distinct A.TOKENID) as nft_count
from A join B on A.seller=B.buyer
where HOLDER !='0x0000000000000000000000000000000000000000'
group by holder
order by nft_count desc
limit 10
Run a query to Download Data