shadilTotal number of Cryptopunk holders
    Updated 2022-08-29
    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