piperHolder Distribution by Balances
    Updated 2024-04-18
    /* $LAB Holders/Balances over time */

    SELECT
    DATE,
    CASE
    WHEN BALANCE/1000000 < 5 THEN '1. Under 5 $LAB'
    WHEN BALANCE/1000000 BETWEEN 5 AND 10 THEN '2. Between 5 - 10 $LAB'
    WHEN BALANCE/1000000 BETWEEN 10 AND 50 THEN '3. Between 10 - 50 $LAB'
    WHEN BALANCE/1000000 BETWEEN 50 AND 100 THEN '4. Between 50 - 100 $LAB'
    WHEN BALANCE/1000000 BETWEEN 100 AND 1000 THEN '5. Between 100 - 1k $LAB'
    WHEN BALANCE/1000000 BETWEEN 1000 AND 5000 THEN '6. Between 1k - 5k $LAB'
    WHEN BALANCE/1000000 > 5000 THEN '7. More then 5k $LAB'
    END AS balances,
    COUNT(DISTINCT ADDRESS) AS holders
    FROM
    osmosis.core.fact_daily_balances
    WHERE
    DATE >= '2024-04-04'
    AND
    CURRENCY = 'factory/osmo17fel472lgzs87ekt9dvk0zqyh5gl80sqp4sk4n/LAB'
    GROUP BY DATE, BALANCES
    ORDER BY DATE ASC, BALANCES
    Auto-refreshes every 12 hours
    QueryRunArchived: QueryRun has been archived