flipside

    Grouping holders ($USD)
    Afonso_DiazGrouping holders ($USD)
    Updated 2025-03-24
    WITH pricet AS (
    SELECT
    price AS token_price_usd
    FROM
    avalanche.price.ez_prices_hourly
    WHERE
    token_address = '0xb8d7710f7d8349a506b75dd184f05777c82dad0c'
    ORDER BY
    hour DESC
    LIMIT 1
    ),
    deposits AS (
    SELECT
    to_address AS receiver,
    SUM(amount) AS volume
    FROM
    avalanche.core.ez_token_transfers
    WHERE
    contract_address = '0xb8d7710f7d8349a506b75dd184f05777c82dad0c'
    GROUP BY
    1
    ),
    withdraws AS (
    SELECT
    from_address AS sender,
    SUM(amount) AS volume
    FROM
    avalanche.core.ez_token_transfers
    WHERE
    contract_address = '0xb8d7710f7d8349a506b75dd184f05777c82dad0c'
    GROUP BY
    1
    ),
    main AS (
    SELECT
    receiver AS holder,
    Last run: 19 days ago
    BALANCE_USD_RANGE
    HOLDER_COUNT
    TOTAL_BALANCE_USD
    1
    		Less than $1001541470331.875920125
    2
    		$100 - $499537119580.998476854
    3
    		$500 - $999145105491.530914416
    4
    		$1,000 - $4,999118260257.603648619
    5
    		$10,000 - $49,99923457369.755190417
    6
    		$5,000 - $9,99921144891.121834132
    7
    		$50,000 - $99,9992110402.608684188
    8
    		$100,000 and above2779782.927227676
    8
    322B
    1s