kakamoraWho owns crypto punks?
    Updated 2022-08-29
    /*
    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