date_trunc('day', min_date) as date,

count(distinct wallet) as users,

sum(count(distinct wallet)) over (order by date_trunc('day', min_date) asc) as cum_wallets

from (

select

value[0] as wallet,

min(c.BLOCK_TIMESTAMP) as min_date

from near.core.fact_actions_events_function_call c join near.core.fact_transactions t using (tx_hash)

, lateral FLATTEN (input => args:accounts)

where METHOD_NAME='create_accounts'

and RECEIVER_ID='tg'

and c.BLOCK_TIMESTAMP::date > '2024-01-30'

and TX_SUCCEEDED='TRUE'

group by 1

group by 1

order by 1 desc