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