from solana.fact_swaps

group by 1 order by 1),

eth as (

select date_trunc('week',block_timestamp) as week , count(distinct origin_from_address) n_unique_address, count(tx_hash) as n_txn2, n_txn2/n_unique_address as avg_txn_by_address

from ethereum_core.ez_dex_swaps

where block_timestamp>='2021-11-21'

group by 1 order by 1

)

select sol.week, sol.n_txn1 as n_txn_solana, sol.avg_txn_by_swapper as sol_avg_txn_per_user, eth.n_txn2 as n_txn_ethereum, eth.avg_txn_by_address as eth_avg_txn_per_user

from sol inner join eth on sol.week=eth.week

limit 100