SELECT
block_timestamp::date AS day,
AVG(price) as average_price
FROM
ethereum.core.ez_nft_sales
WHERE
nft_address = '0x4a537f61ef574153664c0dbc8c8f4b900cacbe5d'
AND block_timestamp::date BETWEEN CURRENT_DATE - INTERVAL '1 year' AND CURRENT_DATE
GROUP BY
block_timestamp::date
ORDER BY
day DESC;