select
PROJECT_NAME as collection
,count(distinct TOKENID) as nft_trade
,sum(PRICE_USD) as volume
,count(distinct BUYER_ADDRESS) as buyers
,count(distinct SELLER_ADDRESS) as sellers
--,count(distinct TX_HASH) as sell_count
from bsc.nft.ez_nft_sales
where BLOCK_TIMESTAMP::date>=Current_date-7
group by 1
order by 2 desc
limit 10