select proposer,

min(block_timestamp) as min_date

from flow.core.fact_transactions

group by 1

),

solana_new as (

select signers[0] as users,

min(block_timestamp) as min_date

from solana.core.fact_transactions

group by 1

),

osmosis_new as (

select tx_from,

min(block_timestamp) as min_date

from osmosis.core.fact_transactions

group by 1

select 'Flow' as blockchain,

date_trunc('day',min_date) as date,

count(DISTINCT proposer) as new_users

from flow_new

where min_date >= '2022-12-24'

group by 1,2

UNION ALL

select 'Solana' as blockchain,

date_trunc('day',min_date) as date,

count(DISTINCT users) as new_users

from solana_new

where min_date >= '2022-12-24'

group by 1,2