SELECT
DATE_TRUNC('second', BLOCK_TIMESTAMP) AS "Date",
PRICE,
PRICE_USD
--COUNT(BLOCK_TIMESTAMP) AS "Number of sold Rekt Chickens"
FROM
base.nft.ez_nft_sales
WHERE
NFT_ADDRESS = lower('0xc16706AE5eED1805990d92241aDd1662724E50F2')
AND
BLOCK_TIMESTAMP >= '2024-03-01'
--GROUP BY 1
ORDER BY 1 ASC