DATE(hour) as "Date",

AVG(price) as "Average FTT price, USD"

FROM ethereum.core.fact_hourly_token_prices

WHERE "Date" BETWEEN '2022-01-01' AND '2022-12-31'

and token_address = '0x50d1c9771902476076ecfc8b2a83ad6b9355a4c9'

group by "Date"