AAPL days to cover and its rank inside the three-year window

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

WITH history AS
(
    SELECT
        settlement_date               AS d,
        max(toFloat64(days_to_cover)) AS dtc
    FROM global_markets.stocks_short_interest
    WHERE ticker = 'AAPL'
      AND settlement_date >= '2023-07-01'
      AND settlement_date <  '2026-07-01'
      AND days_to_cover > 0
    GROUP BY settlement_date
)
SELECT
    toString(a.d)                                     AS settlement_date,
    formatDateTime(a.d, '%b %e, %Y')                  AS as_of_label,
    round(a.dtc, 2)                                   AS days_to_cover_ratio,
    round(100 * countIf(b.dtc <= a.dtc) / count(), 0) AS window_percentile_pct
FROM history AS a
CROSS JOIN history AS b
GROUP BY a.d, a.dtc
ORDER BY a.d