flipside

    How many Pooly NFTs does the average collector hold?
    kiacryptoHow many Pooly NFTs does the average collector hold?
    Updated 2022-06-22
    with holders as (
    select nft_to_address as address, '+1' as hold_count
    from ethereum.core.ez_nft_transfers
    where nft_address in ('0x90b3832e2f2ade2fe382a911805b6933c056d6ed', '0x3545192b340f50d77403dc0a64cf2b32f03d00a9', '0x5663e3e096f1743e77b8f71b5de0cf9dfd058523')
    union all

    select nft_from_address as address, '-1' as hold_count
    from ethereum.core.ez_nft_transfers
    where nft_address in ('0x90b3832e2f2ade2fe382a911805b6933c056d6ed', '0x3545192b340f50d77403dc0a64cf2b32f03d00a9', '0x5663e3e096f1743e77b8f71b5de0cf9dfd058523')
    ),
    hold_count as (
    select address, sum(hold_count) as NFTs_count
    from holders
    group by 1 having NFTs_count > 0
    )

    select avg(NFTs_count)
    from hold_count
    Run a query to Download Data