select avg(PRICE) as price , RECORDED_AT::date as time from osmosis.core.dim_prices
where SYMBOL='OSMO' and RECORDED_AT::date > current_date - interval '7 days'
-- where SYMBOL='OSMO' and RECORDED_AT::date > current_date - interval '7 days'
group by 2