flipside

    ACS-token-holders
    AnalyticSagesACS-token-holders
    Updated 2023-12-09
    WITH txns AS (
    SELECT
    tx_to AS user,
    SUM(amount) AS volume_out
    FROM
    solana.core.fact_transfers
    WHERE
    mint = '5MAYDfq5yxtudAhtfyuMBuHZjgAbaS9tbEyEQYAhDS5y'
    GROUP BY 1

    UNION ALL

    SELECT
    tx_from AS user,
    - SUM(amount) AS volume_in
    FROM
    solana.core.fact_transfers
    WHERE
    mint = '5MAYDfq5yxtudAhtfyuMBuHZjgAbaS9tbEyEQYAhDS5y'
    GROUP BY 1
    )

    SELECT
    COUNT(user) as "Total Holders"
    FROM
    txns
    WHERE
    volume_out > 0;
    Run a query to Download Data