round(sum(s.sales_amount),2) as tot_volume,

round(avg(s.sales_amount),2) as avg_volume,

count(distinct s.tx_id) as no_of_nft_sales,

count(distinct s.purchaser) as no_of_buyers,

count(distinct s.seller) as no_of_sellers

from solana.core.fact_nft_sales s

inner join solana.core.dim_nft_metadata m

on s.mint = m.mint

where s.marketplace = 'hadeswap'

and s.succeeded = True

group by 1

order by tot_volume desc

limit 10