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

COUNT(DISTINCT BUYER) AS BUYERS,

COUNT(DISTINCT TX_ID) AS TXN

--COUNT(DISTINCT SELLER) AS SELLERS

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