STRASMORE/EXPLORE 2,707 QUERIES

Days to cover at each short interest settlement, AAPL against KO

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-09-27, from Substitute Payments and Your 1099.

as of table 36×3read in context →
Days to cover at each short interest settlement, AAPL against KO — 36 rows by 3 columns, computed from US exchange, SIP and OPRA data.
settlement_onaapl_days_to_coverko_days_to_cover
2025-03-312.31.87
2025-04-151.111.77
2025-04-302.292.36
2025-05-151.812.42
2025-05-301.742.32
2025-06-131.982.74
2025-06-301.891.85
2025-07-151.942.01
2025-07-312.142.21
2025-08-151.72.98
2025-08-292.972.61
2025-09-152.131.95
2025-09-301.742.04
2025-10-152.632.42
2025-10-312.22.06
2025-11-142.442.43
2025-11-282.942.36
2025-12-152.952.02
2025-12-312.712.76
2026-01-152.591.95
2026-01-3021.83
2026-02-132.251.77
2026-02-273.262.48
2026-03-133.263.08
2026-03-312.962.81
2026-04-153.393.15
2026-04-302.933.03
2026-05-152.743.51
2026-05-293.382.91
2026-06-152.763.03
2026-06-301.732.06
2026-07-153.062.95
2026-07-312.422.39
2026-08-142.532.75
2026-08-313.532.67
2026-09-152.852.79
Rows × columns
36 × 3
Period covered
to
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for Days to cover at each short interest settlement, AAPL against KO, derived from the stored result.
ColumnTypeRangeNotes
settlement_on date 2025-03-31 to 2026-09-15
aapl_days_to_cover number 1.11 to 3.53
ko_days_to_cover number 1.77 to 3.51

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

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.

SELECT
    toString(settlement_date)                                   AS settlement_on,
    round(toFloat64(maxIf(days_to_cover, ticker = 'AAPL')), 2)  AS aapl_days_to_cover,
    round(toFloat64(maxIf(days_to_cover, ticker = 'KO')), 2)    AS ko_days_to_cover
FROM global_markets.stocks_short_interest
WHERE ticker IN ('AAPL', 'KO')
  AND settlement_date >= today() - 545
GROUP BY settlement_date
HAVING countIf(ticker = 'AAPL') > 0
   AND countIf(ticker = 'KO') > 0
ORDER BY settlement_date
⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

Claude ChatGPT Gemini Muse Your own agent
More from this analysisSubstitute Payments and Your 1099
One quarterly dividend on 1,000 shares, at a qualified rate versus an ordinary rate table 8×6 → Calendar days from ex-dividend date to payable date, most recent dividend ranking 8×4 → Share of reported volume marked short, trailing four months ranking 8×3 → The most recent regular dividend for eleven household names table 11×5 → The exact quarters behind each buyback yield table 4×5 → Share of reported KO volume marked short, by session series 68×3 → See all 2,707 queries →