select

mindate :: date as day,

count (distinct tx_signer) as New_Users

from

(

select

tx_signer,

min (block_timestamp) as mindate

from

near.core.fact_transactions

group by

1

)

group by

1

),

flow1 as (

select

mindate :: date as day,

count (distinct proposer) as New_Users

from

(

select

proposer,

min(block_timestamp) as mindate

from

flow.core.fact_transactions

group by

1

)

group by

1

)

select

'NEAR' as chain,