where swap_from_mint = 'So11111111111111111111111111111111111111112'

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

and swap_to_amount > 0

and swap_from_amount > 0

and block_timestamp >= '2022-01-01' group by 1 order by 1 asc)

select date_trunc('week',BLOCK_TIMESTAMP) as week,'Ethereum_opensea' as chain,

count (DISTINCT BUYER_ADDRESS) as num_Buyer,count (TX_HASH) as num_sales,sum(PLATFORM_FEE_usd) as FEES_IN_USD

from ethereum.core.ez_nft_sales where block_timestamp >= '2022-01-01' and PLATFORM_NAME='opensea' group by 1

select date_trunc('week',BLOCK_TIMESTAMP) as week,'Solana_magic eden v2' as chain,

count(DISTINCT PURCHASER) as num_Buyer,count (TX_ID) as num_sales,0.02*sum(SALES_AMOUNT * solana_price) as FEES_IN_USD

from solana.core.fact_nft_sales a join sol_tab b

on date(a.block_timestamp) = b.date where block_timestamp >= '2022-01-01' and MARKETPLACE='magic eden v2' group by 1