FROM (

SELECT

date_trunc('day', block_timestamp) as ar_day,

count(DISTINCT from_address) as ar_users,

count(DISTINCT tx_hash) as ar_trasaction

FROM arbitrum.core.fact_transactions

GROUP BY 1

) as a

JOIN (

SELECT

date_trunc('day', block_timestamp) as eth_day,

count(DISTINCT from_address) as eth_users,

count(DISTINCT tx_hash) as eth_trasaction

FROM ethereum.core.fact_transactions

GROUP BY 1

ON eth_day = ar_day