SELECT block_timestamp::DATE AS date
, SUM(price) AS volume
, COUNT(*) AS sales
, COUNT(DISTINCT buyer_address) AS buyers
FROM optimism.core.ez_nft_sales
WHERE block_timestamp BETWEEN '2022-10-01' AND '2022-10-31'
AND currency_address = 'ETH'
GROUP BY 1