select

min(block_timestamp)::date as min_date,

signers[0] as from_address

from solana.core.fact_transactions

group by 2

select

min_date as day,

count(from_address) as new_wallets_count,

sum(new_wallets_count) over (order by day) as cumulative_new_wallets_count

from t

where day >= '2022-06-01'

group by day

order by day