abaTop 10 cryptopunk holders
    Updated 2022-08-31

    with nfts as (
    SELECT TOKENID as nft_number
    ,max(block_timestamp) as block_timestamp
    FROM ethereum.core.ez_nft_transfers
    WHERE NFT_ADDRESS='0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb' --cryptopunks
    and PROJECT_NAME = 'cryptopunks'
    group by 1
    ),
    holders as (
    select block_timestamp
    ,NFT_TO_ADDRESS holder
    ,TOKENID nft_number
    from ethereum.core.ez_nft_transfers
    where NFT_TO_ADDRESS != '0x0000000000000000000000000000000000000000'
    )
    select h.holder
    , count(distinct h.nft_number) number_of_nft
    from nfts n JOIN holders h on n.nft_number = h.nft_number AND n.block_timestamp = h.block_timestamp
    group by 1
    order by 2 desc
    limit 10



    Run a query to Download Data