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