piperHolders / Mints
    Updated 2024-10-26
    -- forked from Holder Distribution by Balances @ https://flipsidecrypto.xyz/edit/queries/9db335ec-a641-40b0-90fc-7043037f8a3a

    /* $LAB Holders/Balances over time */

    SELECT
    DATE,
    SUM(BALANCE)/1000000/10 AS total_balance,
    COUNT(DISTINCT ADDRESS) AS holders
    FROM
    osmosis.core.fact_daily_balances
    WHERE
    DATE >= '2024-04-04'
    AND
    CURRENCY = 'factory/osmo17fel472lgzs87ekt9dvk0zqyh5gl80sqp4sk4n/LAB'
    AND
    BALANCE/1000000 >= 10
    AND
    BALANCE/1000000 <= 1000
    GROUP BY DATE
    ORDER BY DATE DESC
    QueryRunArchived: QueryRun has been archived