SELECT
block_timestamp::date as date,'solana' as chain,
count(tx_id) as daily_sales,
sum(daily_sales) over (order by date) as total_sales
from solana.core.fact_nft_sales
where marketplace='opensea' and succeeded='TRUE'
GROUP BY 1,2
union ALL
SELECT
block_timestamp::date as date,'ethereum' as chain,
count(TX_HASH) as daily_sales,
sum(daily_sales) over (order by date) as total_sales
from ethereum.core.ez_nft_sales
where platform_name='opensea' and event_type='sale'
GROUP BY 1,2