from osmosis.core.dim_prices

where SYMBOL='OSMO' and RECORDED_AT::date > current_date - interval '30 days'

group by 2