SELECT

date_trunc('week', BLOCK_TIMESTAMP) as week ,

count(distinct TX_HASH) as tx_eth

from ethereum.core.fact_transactions

where 1=1

and week >= '2022-08-01'

GROUP by 1

-- order by 1

) ,

sol as (

SELECT

date_trunc('week', BLOCK_TIMESTAMP) as week ,

count(distinct TX_id) as tx_sol

from solana.core.fact_transactions

where 1=1

and week >= '2022-08-01'

GROUP by 1

-- order by 1

)

select e.week ,e.tx_eth , s.tx_sol

from eth e

full outer join sol s

on e.week = s.week

order by 1