2,707 answered market questions

SELECT
    volume_bucket,
    count()                                                             AS names_in_bucket,
    round(quantileDeterministic(0.5)(ratio_pct, cityHash64(ticker)), 2) AS median_short_volume_ratio_pct,
    round(max(ratio_pct), 2)                                            AS highest_ratio_pct
FROM
(
    SELECT
        ticker,
        multiIf(reported_vol <   100000, '1. under 100k shares',
                reported_vol <  1000000, '2. 100k to 1M',
                reported_vol < 10000000, '3. 1M to 10M',
                                         '4. above 10M')      AS volume_bucket,
        100 * toFloat64(short_vol) / toFloat64(reported_vol)   AS ratio_pct
    FROM
    (
        SELECT
            ticker,
            max(short_volume) AS short_vol,
            max(total_volume) AS reported_vol
        FROM global_markets.stocks_short_volume
        WHERE date = '2026-09-15'
          AND ticker NOT IN ('SPCX')
        GROUP BY ticker
        HAVING reported_vol > 0
    )
)
GROUP BY volume_bucket
ORDER BY volume_bucket