FROM (

SELECT

date_trunc('day', block_timestamp) as op_day,

count(DISTINCT from_address) as op_users,

count(DISTINCT tx_hash) as op_trasaction

FROM optimism.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 = op_day