select
'Ethereum' as chain,
date(block_timestamp) as date,
count(distinct tx_hash) as sales,
count(distinct buyer_address) as buyers
from
ethereum.core.ez_nft_sales
where
date between '2022-01-01' and current_date()-1
group by 2
UNION
select
'Solana' as chain,
date(block_timestamp) as date,
count(distinct tx_id) as sales,
count(distinct purchaser) as buyers
from
solana.core.fact_nft_sales
where
date between '2022-01-01' and current_date()-1
group by 2