Yousefi_1994Cryptopunk top 10 holders balance
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with cryptopunks_last_sales as(
select
tokenid,
max(block_timestamp) as last_time_sales
from ethereum.core.ez_nft_transfers
where nft_address = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb'
and nft_from_address != '0x0000000000000000000000000000000000000000'
and nft_to_address != '0x0000000000000000000000000000000000000000'
group by tokenid
),
top_10_holder as (
select
nft_to_address,
count(distinct last_sales.tokenid) as "Number of Holds"
from cryptopunks_last_sales last_sales
join ethereum.core.ez_nft_transfers transfer
on last_sales.last_time_sales = transfer.block_timestamp
and last_sales.tokenid = transfer.tokenid
where transfer.event_type = 'other'
and nft_address = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb'
and nft_from_address != '0x0000000000000000000000000000000000000000'
and nft_to_address != '0x0000000000000000000000000000000000000000'
--and nft_to_address != '0xb7f7f6c52f2e2fdb1963eab30438024864c313f6'
group by nft_to_address
order by "Number of Holds" desc
limit 10
)
select
date_trunc('month', balance_date) as months,
user_address,
case
when user_address = '0xa858ddc0445d8131dac4d1de01f834ffcba52ef1' then 'Yuga Labs'
when user_address = '0xa25803ab86a327786bb59395fc0164d826b98298' then 'wilcox.eth'
when user_address = '0x69021ae8769586d56791d29615959997c2012b99' then 'sovpunk.eth'
when user_address = '0xa25803ab86a327786bb59395fc0164d826b98298' then 'wilcox.eth'
Run a query to Download Data