mz0111Untitled Query
    Updated 2022-10-27
    with earlyHolders as (
    select
    address,
    balance/pow (10,decimal) as early_OSMO_Balance
    from osmosis.core.fact_daily_balances
    where currency = 'uosmo'
    and date = '2022-01-01'
    order by 2 DESC
    limit 100
    )
    select
    address,
    balance/pow (10,decimal) as current_OSMO_Balance,
    early_OSMO_Balance
    from osmosis.core.fact_daily_balances join earlyHolders USING(address)
    where currency = 'uosmo'
    and date = CURRENT_DATE - 1
    order by 2 DESC
    limit 100
    Run a query to Download Data