flipside

    Osmo holders in first 90 days of 2022
    rackhaelOsmo holders in first 90 days of 2022
    Updated 2022-10-28
    SELECT address as holders,
    avg(balance/pow(10, decimal)) as balance_osmo
    FROM osmosis.core.fact_daily_balances
    WHERE currency = 'uosmo'
    and date BETWEEN ('2022-01-01') AND ('2022-03-30')
    GROUP BY 1
    ORDER BY balance_osmo DESC
    LIMIT 100
    Run a query to Download Data