flipside

    $GHST Total Holders
    feyikemi$GHST Total Holders
    Updated 2024-05-24
    WITH Tab1 AS (
    SELECT
    TO_ADDRESS AS Wallet
    , AMOUNT_USD AS Amount
    FROM polygon.core.ez_token_transfers
    WHERE 1=1
    AND CONTRACT_ADDRESS = LOWER('0x385eeac5cb85a38a9a07a70c73e0a3271cfb54a7')

    UNION ALL

    SELECT
    FROM_ADDRESS AS Wallet
    , AMOUNT_USD*(-1) AS Amount
    FROM polygon.core.ez_token_transfers
    WHERE 1=1
    AND CONTRACT_ADDRESS = LOWER('0x385eeac5cb85a38a9a07a70c73e0a3271cfb54a7')
    )
    ,

    Tab2 AS (
    SELECT
    Wallet
    , SUM(Amount) as Balance
    FROM Tab1
    GROUP BY 1
    HAVING Balance > 0
    )

    SELECT
    Count(DISTINCT Wallet) AS Total_Holders
    FROM Tab2
    QueryRunArchived: QueryRun has been archived