SELECT
--TO_CHAR(BLOCK_TIMESTAMP, 'YYYY-MM-DD') AS "Date",
PROJECT_NAME,
SUM(PRICE) AS daily_ETH_volume
--SUM(PRICE_USD) AS daily_USD_volume
FROM
base.nft.ez_nft_sales
--WHERE PROJECT_NAME = 'Rekt Chickens'
--WHERE "Date" = '2023-08-25'
GROUP BY 1
ORDER BY 2 DESC
LIMIT 15