STRASMORE/EXPLORE 3,293 QUERIES

Days between a quarter end and the 13F-HR that reports it

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-10-16, from How to Check if a Fund Still Owns a Stock.

as of series 22×5read in context →
Days between a quarter end and the 13F-HR that reports it — 22 rows by 5 columns, computed from US exchange, SIP and OPRA data.
datequarter_labelfilings_countmedian_lag_daysfiled_by_deadline_pct
2021-03-31Mar 202159874274.3
2021-06-30Jun 202160014174.8
2021-09-30Sep 202159934170.1
2021-12-31Dec 202168384190.7
2022-03-31Mar 202268214172.5
2022-06-30Jun 202268104073.3
2022-09-30Sep 202267974094.8
2022-12-31Dec 202270454193.8
2023-03-31Mar 202369644095.3
2023-06-30Jun 202370123994.9
2023-09-30Sep 202370403994.9
2023-12-31Dec 202374234093.6
2024-03-31Mar 202474233995.5
2024-06-30Jun 202474433994.9
2024-09-30Sep 202474883895.4
2024-12-31Dec 202481954194.4
2025-03-31Mar 202581653895.9
2025-06-30Jun 202582033895.5
2025-09-30Sep 202582083895.2
2025-12-31Dec 202589284176.5
2026-03-31Mar 202688963796.3
2026-06-30Jun 202689103797.6
Rows × columns
22 × 5
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 between a quarter end and the 13F-HR that reports it, derived from the stored result.
ColumnTypeRangeNotes
date date 2021-03-31 to 2026-06-30
quarter_label text 22 distinct values (Dec 2021, Dec 2022, Dec 2023…)
filings_count number 5,987 to 8,928 count
median_lag_days number 37 to 42
filed_by_deadline_pct number 70.1 to 97.6 percent

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
    period_end                           AS date,
    formatDateTime(period_end, '%b %Y')  AS quarter_label,
    count()                              AS filings_count,
    toUInt16(round(quantileDeterministic(0.5)(toFloat64(lag_days), cityHash64(accession_number)), 0)) AS median_lag_days,
    round(100 * countIf(lag_days <= 45) / count(), 1) AS filed_by_deadline_pct
FROM
(
    SELECT
        accession_number,
        toDate(period)                                             AS period_end,
        dateDiff('day', toDate(period), max(toDate(filing_date)))  AS lag_days
    FROM global_markets.stocks_13f_filings
    WHERE form_type = '13F-HR'
      AND toDate(period) >= '2021-01-01'
      AND toDate(period) <= today() - 46
    GROUP BY accession_number, period_end
    HAVING lag_days >= 0 AND lag_days <= 400
)
GROUP BY period_end
HAVING filings_count >= 100
ORDER BY period_end
⌘/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 analysisHow to Check if a Fund Still Owns a Stock
How old the newest available 13F snapshot is, day by day series 91×2 → One filer's reported Apple position, quarter by quarter series 22×4 → What kind of position every 13F line actually reports ranking 5×3 → AAPL: quarter-end snapshot price vs the price on the 13F deadline series 8×7 → The four 13F deadlines for the 2026 quarters series 4×7 → Share of reported volume marked short, Q1 2026 disclosure window ranking 5×3 → See all 3,293 queries →