SELECT

min(block_timestamp) AS first_time,

tx_signer

FROM near.core.fact_transactions

GROUP BY 2

),

aptos_first AS(

SELECT

min(block_timestamp) AS first_time,

sender

FROM aptos.core.fact_transactions

GROUP BY 2

SELECT

date_trunc('month',first_time::date) AS month,

count(DISTINCT tx_signer) AS user,

'Near' AS chain

FROM near_first

GROUP BY 1

UNION

SELECT

date_trunc('month',first_time::date) AS month,

count(DISTINCT sender) AS user,

'Aptos' AS chain

FROM aptos_first

GROUP BY 1