select signers[0] as user_address,

min(block_timestamp) as min_date

from solana.core.fact_transactions

group by user_address

select trunc(min_date, 'day')::date as day,

count (distinct (user_address)) as new_users_count

from t

where day >= '2022-12-01'

group by day

order by day