collection_name as collections,

count(tx_group_id) as num_sale,

count(distinct purchaser) as num_buyers,

count (number_of_nfts) as num_nfts,

sum(total_sales_amount) as volume

from algorand.nft.ez_nft_sales

where block_timestamp::date >= '2022-01-01'

and nft_marketplace = '{{marketplace}}'

and total_sales_amount > 0

and collection_name is not null

group by 1

order by 3 desc

limit 10