hour::date as day,

avg(price) as matic_price,

symbol

from ethereum.core.fact_hourly_token_prices

where token_address = '0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0'

and day >= '2022-06-06'

group by day, symbol