SELECT
date_trunc('d', hour ) as date1,
avg(price) as avg_price_usd
FROM ethereum.core.fact_hourly_token_prices
where date1 between '2022-01-01' and '2022-02-01'
---
SELECT DISTINCT SYMBOL from ethereum.core.fact_hourly_token_prices where symbol like '%eth'