split(marketplace, '.')[2] as nft_collection,

count(distinct tx_id) as no_of_nft_txns,

COUNT(DISTINCT nft_id) as no_of_sales,

round(sum(price),2) as total_sales_volume,

round(avg(price),2) as average_sales_volume,

COUNT(DISTINCT buyer) as no_of_buyers,

count(distinct seller) as no_of_sellers

FROM flow.core.ez_nft_sales

where tx_succeeded = true

group by marketplace

order by average_sales_volume desc

limit 5