Updated 2023-02-23
    SELECT
    SUM(open) / 24 AS avg_daily,
    DATE_TRUNC('day', recorded_hour)
    FROM
    flow.core.fact_hourly_prices
    WHERE
    token = 'Flow'
    GROUP BY
    DATE_TRUNC('day', recorded_hour)