with tab1 as (

select address as osmo_start_users,BALANCE/1e6 as start_osmo_balance

from osmosis.core.fact_daily_balances

where currency = 'uosmo'

and BALANCE_TYPE='liquid'

and date = '2022-01-01'

group by 1,2

order by 2 desc

limit 100),

tab2 as (

select address as osmo_currently_users,BALANCE/1e6 as current_osmo_balance

from osmosis.core.fact_daily_balances

where currency = 'uosmo'

and BALANCE_TYPE='liquid'

and date = current_date

group by 1,2

order by 2 desc

limit 100)

select osmo_currently_users,current_osmo_balance,start_osmo_balance

from tab1

left join tab2

on tab1.osmo_start_users=tab2.osmo_currently_users

where osmo_currently_users is not null

order by 2 desc

limit 10