date(t.block_timestamp) as date,

'All active' as user_type,

count(distinct b.value) as n_users

from solana.core.fact_transactions t

, lateral flatten(

input => signers

) b

where

t.block_timestamp::date >= current_date - 31

and t.block_timestamp::date < current_date

group by date

first_tx_date as date,

'New' as user_type,

count(distinct signer) as n_users

-- ,first_program_id

from solana.core.ez_signers

where first_tx_date >= current_date - 31

and first_tx_date < current_date

group by date

;