Yousefi_1994Total distinct wallet that holds Lil Nouns
    Updated 2022-06-21
    with lilnoun_last_sales as(
    select
    nft_address,
    tokenid,
    max(block_timestamp) as last_time_sales
    from ethereum.core.ez_nft_transfers where nft_address='0x4b10701bfd7bfedc47d50562b76b436fbb5bdb3b'
    group by nft_address, tokenid
    )
    select
    count(distinct nft_to_address) as number_of_holder
    from lilnoun_last_sales last_sales
    join ethereum.core.ez_nft_transfers transfer
    on last_sales.last_time_sales = transfer.block_timestamp
    and last_sales.nft_address= transfer.nft_address
    and last_sales.tokenid = transfer.tokenid
    where transfer.event_type = 'other'
    Run a query to Download Data