SELECT date_trunc('quarter',x.block_timestamp) as dates,

avg(y.balance)/pow(10,6) as avg_osmo_balance,

CASE WHEN dates between '2023-01-01' AND '2023-03-31' THEN '2023-Q1' ELSE 'other periods' END as Quarter

FROM osmosis.core.fact_governance_votes x

LEFT JOIN osmosis.core.fact_daily_balances y

ON y.address = x.voter AND y.date = date_trunc('day',x.block_timestamp)

WHERE y.currency = 'uosmo'

AND block_timestamp::date < '2023-04-01'

GROUP by dates

ORDER BY dates DESC