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 PURCHASER as Buyer,

'Opensea' as "marketplace",

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,2

)

Buyer,

"marketplace",

sum(FEES_IN_USD) as volume

from main

where FEES_IN_USD is not null

group by 1,2

order by 3 desc

limit 10