rezarwzThe top 100 wallets compared to how they were at the beginning of the year (Liquid balance)
    Updated 2022-10-26
    with start_of_the_year as(
    SELECT
    address,
    BALANCE/pow(10,decimal) as balance_start_of_year,
    RANK() OVER(ORDER BY BALANCE desc) as rank_start_of_year
    FROM osmosis.core.fact_daily_balances
    where CURRENCY='uosmo' and BALANCE_TYPE='liquid' and date='2022-01-01'),
    right_now as(
    SELECT
    address,
    BALANCE/pow(10,decimal) as balance_right_now,
    RANK() OVER(ORDER BY BALANCE desc) as rank_right_now
    FROM osmosis.core.fact_daily_balances
    where CURRENCY='uosmo' and BALANCE_TYPE='liquid' and date=CURRENT_DATE)
    SELECT r.address,rank_right_now,balance_right_now,rank_start_of_year,balance_start_of_year
    FROM right_now r full join start_of_the_year s on r.address=s.address
    WHERE rank_right_now<=100
    order by rank_right_now asc