DATE_TRUNC('day', HOUR) AS Date,

ROUND(AVG(price), 8) AS price

FROM near.price.ez_prices_hourly

WHERE 1 = 1

AND token_address = 'blackdragon.tkn.near'

AND date >= '2024-01-01'

GROUP BY

Date

ORDER BY Date DESC