with df_start as (
select
distinct ADDRESS as holder,
balance/pow(10,decimal) as balance_start_of_the_year
from osmosis.core.fact_daily_balances
where BALANCE_TYPE = 'liquid' and currency = 'uosmo' and date = '2022-01-01'
),
--group by holder
--order by balance DESC
--limit 100),
df_now as (
select
distinct ADDRESS as holder,
balance/pow(10,decimal) as balance_now
from osmosis.core.fact_daily_balances
where BALANCE_TYPE = 'liquid' and currency = 'uosmo' and date = CURRENT_DATE - 1),
--group by holder
--order by balance DESC
--limit 100
df_1 as (
select
holder,
balance_start_of_the_year
from df_start
order by balance_start_of_the_year DESC limit 100
),
df_2 as (
select
holder,
balance_now
from df_now
order by balance_now DESC limit 100
)