kakamoraWho owns crypto punks?
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
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
⌄
⌄
⌄
/*
SELECT
*
FROM ethereum.core.dim_labels
WHERE ADDRESS_NAME ILIKE 'CRYPTO%'
AND LABEL_TYPE = 'nft'
AND LABEL like '%punk'
LIMIT 100
*/
/*
select
distinct nft_address, tokenid
from ethereum.core.ez_nft_sales
where project_name='cryptopunks'
*/
-- 0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb
/*
ethereum.core.ez_nft_sales
where event_type = 'sale'
and project_name='cryptopunks'
*/
SELECT
last_activity_block_timestamp::date as date,
user_address as wallet,
case wallet
when '0xb7f7f6c52f2e2fdb1963eab30438024864c313f6' then 'WrappedCryptoPunks-Escrow'
when '0x577ebc5de943e35cdf9ecb5bbe1f7d7cb6c7c647' then 'MR703'
when '0x269616d549d7e8eaa82dfb17028d0b212d11232a' then 'PUNKVault-NFTX'
when '0x810fdbc7e5cfe998127a1f2aa26f34e64e0364f4' then null
when '0x0232d1083e970f0c78f56202b9a666b526fa379f' then 'punksOTC2'
when '0xbb67d2ab6251a6bd5276759cb431088c5487a3b2' then null
when '0x67954ac510255b6b3724073022196b67bdf260b6' then null
when '0xcc2a855946a3c20683858fe6ee15acf8b836f0b3' then null
when '0x94de7e2c73529ebf3206aa3459e699fbcdfcd49b' then 'tonyherrera'
when '0x60e23da7a0b229902da892ddd6a839382eab04ca' then 'azpunks.eth'
when '0x062c5432107e3b9ad924512209a7468b5c200fcd' then 'Cool-Punks'
Run a query to Download Data