niloosmo part 2
    Updated 2022-10-27
    WITH
    TOP100 AS (select

    ADDRESS,

    SUM (BALANCE/pow(10,DECIMAL)) AS BALANCE
    FROM osmosis.core.fact_daily_balances
    WHERE CURRENCY = 'uosmo'
    AND DATE = '2022-10-26'
    GROUP BY 1 ORDER BY BALANCE DESC LIMIT 100)

    select

    DATE,
    BALANCE_TYPE,
    SUM (BALANCE/pow(10,DECIMAL)) AS BALANCE
    FROM osmosis.core.fact_daily_balances
    WHERE CURRENCY = 'uosmo'
    AND ADDRESS IN (SELECT ADDRESS FROM TOP100)
    AND DATE BETWEEN '2022-01-01' and '2022-10-26'
    GROUP BY 1,2


    Run a query to Download Data