gigiokobapure-cyan
    Updated 2025-02-09
    WITH received_data AS (
    SELECT
    to_address AS recipient,
    SUM(amount) AS total_received
    FROM avalanche.core.ez_token_transfers
    WHERE contract_address = '0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b'
    GROUP BY 1
    ),
    sent_data AS (
    SELECT
    from_address AS sender,
    SUM(amount) AS total_sent
    FROM avalanche.core.ez_token_transfers
    WHERE contract_address = '0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b'
    GROUP BY 1
    ),
    holder_balances AS (
    SELECT
    COALESCE(received_data.recipient, sent_data.sender) AS wallet_address,
    SUM(COALESCE(total_received, 0) - COALESCE(total_sent, 0)) AS balance
    FROM received_data
    FULL OUTER JOIN sent_data
    ON received_data.recipient = sent_data.sender
    GROUP BY 1
    )
    SELECT
    CASE
    WHEN balance < 100 THEN 'Small Holders (< 100)'
    WHEN balance BETWEEN 100 AND 1000 THEN 'Retail Holders (100 - 1000)'
    WHEN balance > 1000 THEN 'Large Holders (> 1000)'
    END AS holder_category,
    COUNT(wallet_address) AS holder_count,
    SUM(balance) AS total_balance
    FROM holder_balances
    WHERE balance > 0
    GROUP BY holder_category
    Last run: 14 days ago
    HOLDER_CATEGORY
    HOLDER_COUNT
    TOTAL_BALANCE
    1
    Large Holders (> 1000)7114787.33711878
    2
    Retail Holders (100 - 1000)256520.408323218
    3
    Small Holders (< 100)76884969.003329053
    3
    142B
    6s