hour::date as days,

avg(price) as matic_price

from ethereum.core.fact_hourly_token_prices

where token_address = '0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0'

and symbol = 'MATIC'

and hour(hour) = 0

group by days

order by days