flipside

    $WUF HOLDERS COUNT(TOTAL)
    alfredfx10$WUF HOLDERS COUNT(TOTAL)
    Updated 2024-08-05
    WITH BALANCE AS(SELECT TX_TO AS Receiver, SUM(AMOUNT) AS Token
    FROM solana.core.fact_transfers
    WHERE MINT='73xsLcBnLnc9bh81cqVKqj8uEyiarXng5ZwJuTbnVebG'
    GROUP BY 1

    UNION ALL

    SELECT TX_FROM AS Receiver, SUM(-AMOUNT) AS Token
    FROM solana.core.fact_transfers
    WHERE MINT='73xsLcBnLnc9bh81cqVKqj8uEyiarXng5ZwJuTbnVebG'
    GROUP BY 1),

    MAIN_BALANCE AS(SELECT Receiver, SUM(Token) AS "Holder's Balance"
    FROM BALANCE
    GROUP BY 1
    )

    SELECT COUNT(DISTINCT Receiver) AS "Holder's Count"
    FROM MAIN_BALANCE
    WHERE "Holder's Balance" >0.01
    QueryRunArchived: QueryRun has been archived