FROM (

SELECT

date_trunc('day', block_timestamp) as bsc_day,

count(DISTINCT from_address) as bsc_users,

count(DISTINCT tx_hash) as bsc_trasaction

FROM bsc.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 = bsc_day