block_timestamp,

PARSE_JSON(args):new_account_id::string as user

from near.core.fact_actions_events_function_call

where method_name ILIKE 'create\\_account%' ESCAPE '\\'

and tx_hash NOT IN (select

DISTINCT a.tx_hash

from near.core.fact_receipts a JOIN near.core.fact_actions_events_function_call b ON a.tx_hash = b.tx_hash

where method_name ILIKE 'create\\_account%' ESCAPE '\\'

and REGEXP_SUBSTR(status_value, 'Failure') IS NOT NULL

)

)

select

block_timestamp::date as date,

count(DISTINCT user) as "Daily New Users"

from main

group by 1

order by 1