SELECT

date_trunc('day', BLOCK_TIMESTAMP) as day ,

count(distinct TX_HASH) as tx_eth

from ethereum.core.fact_transactions

where 1=1

and day >= '2022-08-01'

GROUP by 1

-- order by 1

) ,

sol as (

SELECT

date_trunc('day', BLOCK_TIMESTAMP) as day ,

count(distinct TX_id) as tx_sol

from solana.core.fact_transactions

where 1=1

and day >= '2022-08-01'

GROUP by 1

-- order by 1

)

select e.day ,e.tx_eth , s.tx_sol

from eth e

full outer join sol s

on e.day = s.day

order by 1