PapasotCosmic Champs holders new addresses since July 5th
    Updated 2023-01-02
    with Cosmic as (

    select
    address
    from algorand.account_asset
    where
    amount > 0 and
    asset_id in (select asset_id
    from algorand.asset
    where CREATOR_ADDRESS='CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM'
    and ASSET_DELETED='FALSE'
    and ASSET_NAME not in ('SINGULARITY ERA COMMEMORATIVE','Cosmic Champs Whitelist TOKEN') )
    )
    select
    count(address) as new_wallets
    from algorand.account
    inner join Cosmic using (address)
    where created_at > 22025289 -- July 5th


    Run a query to Download Data