bachiPooly NFTs
    Updated 2022-06-22
    select
    date(block_timestamp) as day,
    count(distinct NFT_TO_ADDRESS) as unique_users,
    count(distinct tokenid) as total_nft_count,
    case when nft_address = lower(
    '0x90B3832e2F2aDe2FE382a911805B6933C056D6ed'
    ) then 'Pooly - Supporter (POOLY1)' when nft_address = lower(
    '0x3545192b340F50d77403DC0A64cf2b32F03d00A9'
    ) then 'Pooly - Lawyer (POOLY2)' when nft_address = lower(
    '0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523'
    ) then 'Pooly - Judge (POOLY3)' end as nft_collection,
    round(total_nft_count / unique_users, 2) as avg_nft_held
    from
    ethereum.core.ez_nft_mints
    where
    NFT_ADDRESS in (
    lower(
    '0x3545192b340F50d77403DC0A64cf2b32F03d00A9'
    ),
    lower(
    '0x90B3832e2F2aDe2FE382a911805B6933C056D6ed'
    ),
    lower(
    '0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523'
    )
    )
    group by
    nft_collection,
    day
    order by
    day desc

    Run a query to Download Data