TO_CHAR(BLOCK_TIMESTAMP, 'YYYY-MM-DD') AS "Date",

COUNT(TX_HASH) AS "Daily Number of Sales",

SUM("Daily Number of Sales") OVER (ORDER BY "Date") AS "Total Number of Sales",

ROUND(SUM(PRICE_USD)) AS "Daily Sales Volume (USD)",

SUM("Daily Sales Volume (USD)") OVER (ORDER BY "Date") AS "Total Sales Volume (USD)"

base.nft.ez_nft_sales

WHERE

BLOCK_TIMESTAMP >= '2023-08-09' AND BLOCK_TIMESTAMP <= '2023-09-10'

GROUP BY 1

ORDER BY 1 DESC