defi__joshCurrent number of $TITCOIN holders
    Updated 2025-04-02
    WITH latest_balances AS (
    SELECT
    owner,
    balance,
    ROW_NUMBER() OVER (PARTITION BY owner ORDER BY block_timestamp DESC) as rn
    FROM solana.core.fact_token_balances
    WHERE mint = 'FtUEW73K6vEYHfbkfpdBZfWpxgQar2HipGdbutEhpump'
    )

    SELECT COUNT(DISTINCT owner) as total_holders
    FROM latest_balances
    WHERE rn = 1
    AND balance > 0;
    Last run: 2 days ago
    TOTAL_HOLDERS
    1
    20194
    1
    9B
    126s