BLOCK_TIMESTAMP::DATE AS Daily,

COUNT (DISTINCT BUYER_ADDRESS) AS BUYERS_ADDRESS,

COUNT (DISTINCT SELLER_ADDRESS) AS SELLERS_ADDRESS,

SUM (PRICE_USD) AS USD_amount

FROM ethereum.core.ez_nft_sales

WHERE EVENT_TYPE = 'sale' AND PROJECT_NAME ILIKE 'cryptopunks'

AND price_usd is not NULL

GROUP BY 1

ORDER by 1 DESC