date(block_timestamp) as date,

avg(swap_to_amount) / avg(swap_from_amount) as solprice

from solana.fact_swaps

where swap_from_mint = 'So11111111111111111111111111111111111111112'

and swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

and swap_to_amount > 0

and swap_from_amount > 0

and block_timestamp >= '2022-01-01'

group by 1

order by 1 asc

), MAIN as (

select

DISTINCT mint as mint,

0.02*sum(SALES_AMOUNT * solprice) as FEES_IN_USD

from solana.core.fact_nft_sales a

join sol_price b

on date(a.block_timestamp) = b.date

where block_timestamp >= '2022-01-01'

and MARKETPLACE='opensea'

group by 1

)

CONTRACT_NAME,

sum(FEES_IN_USD) as volume

from main a join solana.core.dim_nft_metadata b on a.mint=b.mint

where FEES_IN_USD is not null

group by 1

order by 2 desc

limit 10