HOUR::date as date,

avg(PRICE) as Price

from ethereum.core.fact_hourly_token_prices

where SYMBOL = 'CHAD'

AND TOKEN_ADDRESS = '0x6b89b97169a797d94f057f4a0b01e2ca303155e4'

group BY 1