flipside

    holder 5
    yasminholder 5
    Updated 2025-04-29
    WITH RAW AS (SELECT
    address,
    SUM(volume) AS balance
    FROM (SELECT
    to_address AS address,
    SUM(amount) AS volume
    FROM avalanche.core.ez_token_transfers
    WHERE contract_address = LOWER('0xf99516bc189af00ff8effd5a1f2295b67d70a90e')
    GROUP BY to_address
    UNION ALL
    SELECT
    from_address AS address,
    -SUM(amount) AS volume
    FROM avalanche.core.ez_token_transfers
    WHERE contract_address = LOWER('0xf99516bc189af00ff8effd5a1f2295b67d70a90e')
    GROUP BY from_address) RAW
    GROUP BY address
    HAVING SUM(volume) > 0
    ),
    GROUPED_HOLDERS AS (
    SELECT
    address,
    CASE WHEN balance < 1000 THEN '🐟 Fish'
    WHEN balance BETWEEN 1000 AND 10000 THEN '🐬 Dolphin'
    WHEN balance BETWEEN 10000 AND 100000 THEN '🦈 Shark'
    ELSE '🐋 Whale'
    END AS group_type,
    balance FROM RAW
    ),
    GROUP_STATS AS (
    SELECT
    group_type,
    COUNT(*) AS user_count,
    SUM(balance) AS total_balance
    FROM GROUPED_HOLDERS
    GROUP BY group_type
    QueryRunArchived: QueryRun has been archived