,case

when BALANCE>=1 and BALANCE/1e6<10 then '1 ~ 10 OSMO'

when BALANCE>=10 and BALANCE/1e6<100 then '10 ~ 100 OSMO'

when BALANCE>=100 and BALANCE/1e6<1000 then '100 ~ 1000 OSMO'

when BALANCE>=1000 and BALANCE/1e6<10000 then '1000 ~ 10000 OSMO'

when BALANCE>=10000 and BALANCE/1e6<100000 then '10000 ~ 100000 OSMO'

when BALANCE/1e6>=100000 then 'UP TO 100000 OSMO' end as dis_volume

from osmosis.core.fact_daily_balances

where currency = 'uosmo'

and DATE=current_date

group by 2