DATE_TRUNC('day', HOUR) AS Date,

AVG(price) AS price

FROM bsc.price.ez_prices_hourly

WHERE token_address = '0x4d3dc895a9edb234dfa3e303a196c009dc918f84' -- $ZBU Contract Address

GROUP BY

Date

ORDER BY

Date DESC;