select
'Ethereum' as chain,
date(block_timestamp) as date,
count(distinct tx_hash) as mints,
count(distinct nft_to_address) as minters
from
ethereum.core.ez_nft_mints
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 mints,
count(distinct purchaser) as minters
from
solana.core.fact_nft_mints
where
date between '2022-01-01' and current_date()-1
group by 2