select date,
'osmosis' as network,
case when BALANCE/pow(10,decimal)<1 then 'less than 1 $AXL'
when BALANCE/pow(10,decimal) >1 and BALANCE/pow(10,decimal)<10 then 'Between 1 to 10 $AXL'
when BALANCE/pow(10,decimal) >10 and BALANCE/pow(10,decimal)<100 then 'Between 10 to 100 $AXL'
when BALANCE/pow(10,decimal) >100 and BALANCE/pow(10,decimal)<1000 then 'Between 100 to 1k $AXL'
else 'more than 1K $AXL' end as bal,
count(distinct ADDRESS) as wallet
from osmosis.core.fact_daily_balances
where currency='ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'
group by 1, 2, 3