select mint

from solana.core.dim_nft_metadata

where project_name = 'Aurory'

),

sol_price as (

select

date_trunc(week,block_timestamp)::date as date_ ,

avg( SWAP_TO_AMOUNT/SWAP_FROM_AMOUNT) as price

from solana.core.fact_swaps

where SWAP_FROM_MINT = 'So11111111111111111111111111111111111111112'-- SOL

and SWAP_TO_MINT = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' --USDC

and SWAP_FROM_AMOUNT >0

group by 1

select

MARKETPLACE ,

count (distinct tx_id) num_sales ,

count (distinct purchaser) num_purchasers ,

count (distinct seller) num_sellers,

sum(sales_amount) sales_volume ,

sum (sales_amount*price) sales_usd_volume

from solana.core.fact_nft_sales join sol_price on date_trunc(week,block_timestamp)::Date = date_

where mint in (select mint from NFTs)

and SUCCEEDED = true

group by 1