SPLIT_PART(NFT_COLLECTION, '.', 3) AS PROJECT,

COUNT(DISTINCT SELLER) AS SELLERS,

COUNT(DISTINCT TX_ID) AS TXN

FROM

flow.nft.ez_nft_sales

WHERE

block_timestamp::DATE >= '2024-07-01'

AND block_timestamp::DATE < '2024-08-01'

GROUP BY 1

ORDER BY 2 DESC

LIMIT 10