select 'NEAR' as chain,
date(block_timestamp) as date,
count(distinct tx_hash) as swap_count
from near.core.ez_dex_swaps
where date between '2022-11-07' and '2022-11-14'
group by 2
UNION
SELECT 'SOLANA' as chain,
date(block_timestamp) as date,
count(distinct tx_id) as swap_count
from solana.core.fact_swaps
where date between '2022-11-07' and '2022-11-14'
group by 2