select 'Optimism' , count(*) as transactions,sum(eth_value) as transactions_volume, sum(tx_fee) as transactions_fee , count(distinct from_address) as users, avg(eth_value) as average_transactions_volume, avg(tx_fee) as average_transactions_fee from optimism.core.fact_transactions
UNION
select 'ETH' , count(*) as transactions,sum(eth_value) as transactions_volume, sum(tx_fee) as transactions_fee, count(distinct from_address) as users, avg(eth_value) average_transactions_volume, avg(tx_fee) average_transactions_fee from ethereum.core.fact_transactions