date_trunc('day', hour) as day_date,

avg(price)

ethereum.core.fact_hourly_token_prices

WHERE 1=1

AND SYMBOL = 'SNX'

AND day_date >= '2021-10-01'

AND day_date <= '2021-10-07'

-- I wouldn't wanted to get 2021-10-04 and 2021-10-05 (Just an example)

AND day_date NOT IN ('2021-10-04', '2021-10-05')

GROUP BY 1

ORDER BY 1