dannyamahmSOL Holders Analysis
    Updated 2025-02-19
    WITH Latest_Transactions 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 = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'
    ),
    price AS (
    SELECT
    price
    FROM crosschain.price.ez_prices_hourly
    WHERE token_address = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'
    ORDER BY hour DESC
    LIMIT 1
    )

    SELECT
    usd_value_range,
    COUNT(*) AS holder_count
    FROM (
    SELECT
    owner,
    round(balance, 6) AS amount,
    (amount * p.price) AS amount_usd,
    CASE
    WHEN (amount * p.price) BETWEEN 1 AND 10 THEN '1 - $10'
    WHEN (amount * p.price) BETWEEN 10 AND 100 THEN '$10 - $100'
    WHEN (amount * p.price) BETWEEN 100 AND 1000 THEN '$100 - $1,000'
    WHEN (amount * p.price) BETWEEN 1000 AND 10000 THEN '$1,000 - $10,000'
    WHEN (amount * p.price) BETWEEN 10000 AND 100000 THEN '$10,000 - $100,000'
    ELSE 'Above $100,000'
    END AS usd_value_range
    FROM Latest_Transactions
    CROSS JOIN price p
    WHERE rn = 1
    QueryRunArchived: QueryRun has been archived