SELECT
date_trunc('month', block_timestamp) AS month,
COUNT(DISTINCT BUYER_ADDRESS) AS BUYERS_COUNT,
COUNT(DISTINCT SELLER_ADDRESS) AS SELLERS_COUNT,
COUNT(DISTINCT TOKENID) AS NFTs,
SUM(PRICE) AS ETH_VOLUME,
SUM(PRICE_USD) AS USD_VOLUME
FROM
POLYGON.nft.ez_nft_sales
WHERE
EVENT_TYPE = 'sale'
AND PROJECT_NAME = 'y00ts'
AND PRICE IS NOT NULL
AND PRICE_USD IS NOT NULL
GROUP BY
month
ORDER BY
month DESC;