select block_timestamp::date as day,

avg (swap_to_amount/swap_from_amount) as SOLprice

from solana.fact_swaps

where swap_from_mint = 'So11111111111111111111111111111111111111112' --SOL

and swap_to_mint in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v','Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB') --USDC,USDT

and swap_to_amount > 0

and swap_from_amount > 0

and succeeded = 'TRUE'

group by 1),

maintable as (

select 'X2Y2' as platform,

buyer_address as Buyer,

count (distinct tx_hash) as Sales_Count,

sum (price_usd) as Total_Volume,

count (distinct project_name) as Projets_Count

from ethereum.core.ez_nft_sales

where platform_name = 'x2y2'

and block_timestamp >= CURRENT_DATE - 60

group by 1,2

union ALL

select 'Solanart' as platform,

purchaser as Buyer,

count (distinct tx_id) as Sales_Count,

sum (sales_amount*solprice) as Total_Volume,

count (distinct project_name) as Projets_Count

from solana.core.fact_nft_sales t1 join SOLPricet t2 on t1.block_timestamp::date = t2.day

full outer join solana.core.dim_nft_metadata t3 on t1.mint = t3.mint

where marketplace = 'solanart'

and block_timestamp >= CURRENT_DATE - 60

and succeeded = 'TRUE'

group by 1,2)