SELECT BLOCK_TIMESTAMP::DATE AS DATE,
COUNT (DISTINCT BUYER_ADDRESS) AS BUYERS_COUNT,
COUNT (DISTINCT SELLER_ADDRESS) AS SELLERS_COUNT,
SUM (PRICE) AS ETHPRICE,
SUM (PRICE_USD) AS USDPRICE
FROM ethereum.core.ez_nft_sales WHERE EVENT_TYPE ILIKE 'sale' AND PROJECT_NAME ILIKE 'cryptopunks' GROUP BY DATE