abaTop 10 cryptopunk holders
Updated 2022-08-31
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
›
⌄
with nfts as (
SELECT TOKENID as nft_number
,max(block_timestamp) as block_timestamp
FROM ethereum.core.ez_nft_transfers
WHERE NFT_ADDRESS='0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb' --cryptopunks
and PROJECT_NAME = 'cryptopunks'
group by 1
),
holders as (
select block_timestamp
,NFT_TO_ADDRESS holder
,TOKENID nft_number
from ethereum.core.ez_nft_transfers
where NFT_TO_ADDRESS != '0x0000000000000000000000000000000000000000'
)
select h.holder
, count(distinct h.nft_number) number_of_nft
from nfts n JOIN holders h on n.nft_number = h.nft_number AND n.block_timestamp = h.block_timestamp
group by 1
order by 2 desc
limit 10
Run a query to Download Data