shadilTotal number of Cryptopunk holders
Updated 2022-08-29
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select count(DISTINCT buyer_address) AS total_holders
from ethereum.core.ez_nft_sales join (select block_timestamp,
TOKENID as token_id,
row_number() over (partition by token_id order by block_timestamp desc) as r_number
from ethereum.core.ez_nft_sales
where nft_address like '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb'
qualify r_number = 1) as table1
on table1.block_timestamp = ethereum.core.ez_nft_sales.block_timestamp
and token_id = tokenid
where buyer_address != '0x0000000000000000000000000000000000000000'
and token_id IS NOT NULL
Run a query to Download Data