SELECT

block_timestamp,

TX_HASH,

ARGS['new_account_id'] AS WALLET_ADDRESS

FROM

near.core.fact_actions_events_function_call

WHERE

METHOD_NAME = 'create_account'

AND SIGNER_ID IN ('meteor-relayer.near', 'meteor-gastank.near' , 'aa-meteor-relayer-1.near', 'aa-meteor-relayer-2.near')

AND block_timestamp::date >= '2023-11-06'

),

meteor_wallets_good as (

select block_timestamp, RECEIVER_ID as WALLET_ADDRESS from near.core.fact_actions_events

where ACTION_NAME = 'AddKey'

and RECEIPT_SUCCEEDED = TRUE

and TX_HASH in (select TX_HASH from meteor_wallets)

select trunc(block_timestamp,'week') as "Week",

count(WALLET_ADDRESS) as "New wallets",

sum("New wallets") over (order by "Week" asc) as "Total wallets"

from meteor_wallets_good

group by 1

order by 1 desc