with genesis_NFTs_holders as (
select
account_asset.address as wallet
from algorand.account_asset
join algorand.asset
on account_asset.asset_id = asset.asset_id
where account_asset.amount > 0
and asset.creator_address = 'CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM'
and total_supply = 1
and asset.asset_deleted = false
group by wallet
)
select
block_timestamp::date as days,
address,
count(distinct address) as "Number of Wallet created"
from algorand.account
join algorand.block on block_id = created_at
where address in (select wallet from genesis_NFTs_holders)
group by days, address
order by days