transactions as (

select

x.block_timestamp,

y.contract_name,

y.project_name,

y.created_at_timestamp,

x.tx_id,

x.purchaser,

x.sales_amount

from solana.fact_nft_sales x

join solana.dim_nft_metadata y on x.mint = y.mint --and y.contract_name = 'Catalina Whale Mixer'

--where program_id='MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8' --like '%magic eden%'

),

collections as (

distinct contract_name as collection,

'Solana' as network,

min(block_timestamp) as debut

from transactions

group by 1

order by 1 asc

),

eth as (

SELECT

distinct project_name as collection,

'Ethereum' as network,

min(block_timestamp) as debut

from ethereum_core.ez_nft_sales

group by 1

order by 1 asc

),

sol_sales as (

SELECT

trunc(block_timestamp,'day') as date1,

'Solana' as network1,