ifnull(sum (balance/pow (10,decimal)),0) as OSMO_bal_old

from osmosis.core.fact_daily_balances

where currency = 'uosmo'

and date = '2022-01-01' group by 1 order by 2 desc limit 100),

p2 as (select address as top_holders_now,

ifnull(sum (balance/pow (10,decimal)),0) as OSMO_bal_current

from osmosis.core.fact_daily_balances

where currency = 'uosmo'

and date = current_date - 1

group by 1 order by 2 desc limit 100)

select top_holders_now as top_holders, OSMO_bal_current, OSMO_bal_old

from p1,p2 where top_holders_now = top_holders_old