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

count(DISTINCT tx_signer) AS user,

'Near' AS chain_name

FROM near_first

WHERE first_time::date >= '2024-01-01'

UNION

SELECT

count(DISTINCT sender) AS user,

'Aptos' AS chain_name

FROM aptos_first

WHERE first_time::date >= '2024-01-01'

ORDER BY 2 DESC