with t1 as
(select BALANCE/1e6 as balance1,* from osmosis.core.fact_daily_balances
where
DATE=CURRENT_DATE
and CURRENCY='uosmo'
),
small_holders as
(select ADDRESS from t1
WHERE
balance1<10),
plangtons as
(select ADDRESS from t1
WHERE
balance1 between 10 and 100),
shrimp as
(select ADDRESS from t1
WHERE
balance1 between 100 and 1000),
crab as
(select ADDRESS from t1
WHERE
balance1 between 1000 and 10000),
fish as
(select ADDRESS from t1
WHERE
balance1 between 10000 and 100000),
shark as
(select ADDRESS from t1
WHERE
balance1 between 100000 and 1000000),