DATE_TRUNC('day', hour) AS recorded_day,

AVG(price) AS avg_Boden_Price

FROM solana.price.ez_prices_hourly

WHERE TOKEN_ADDRESS = '3psH1Mj1f7yUfaD5gh6Zj7epE8hhrMkMETgv5TshQA4o'

AND DATE(hour) = '2024-07-20'

GROUP BY recorded_day;