with new_account_transactions as (
select
block_timestamp,
inner_instruction:instructions[0]:parsed:info:newAccount::string as account
from solana.events
where block_timestamp::date >= '2022-02-10'
and inner_instruction:instructions[0]:parsed:info:owner::string = 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68'
and inner_instruction:instructions[0]:parsed:type::string = 'createAccount'
and instruction:programId::string = 'mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68'
)
select
block_timestamp::date as blocktime,
count(distinct account) as number_of_new_accounts
from new_account_transactions
group by blocktime