filing_lag_trend
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-28, from how-often-mutual-funds-change-holdings.
| month | filings | median_days_to_file | p90_days_to_file |
|---|---|---|---|
| 2024-06 | 64 | 129 | 171 |
| 2024-09 | 7442 | 38 | 45 |
| 2024-12 | 8121 | 41 | 45 |
| 2025-03 | 8101 | 38 | 45 |
| 2025-06 | 8144 | 38 | 45 |
| 2025-09 | 8151 | 38 | 45 |
| 2025-12 | 8864 | 40 | 48 |
| 2026-03 | 8890 | 37 | 45 |
| 2026-06 | 8898 | 37 | 45 |
- Rows × columns
- 9 × 4
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
month |
text | 9 distinct values (2024-06, 2024-09, 2024-12…) | |
filings |
number | 64 to 8,898 | |
median_days_to_file |
number | 37 to 129 | |
p90_days_to_file |
number | 45 to 171 |
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
formatDateTime(period_end, '%Y-%m') AS month,
count() AS filings,
round(quantileDeterministic(0.5)(days_to_file, hash_id), 0) AS median_days_to_file,
round(quantileDeterministic(0.9)(days_to_file, hash_id), 0) AS p90_days_to_file
FROM
(
SELECT
cityHash64(accession_number) AS hash_id,
toDateOrNull(toString(any(period))) AS period_end,
dateDiff('day', toDateOrNull(toString(any(period))), any(filing_date)) AS days_to_file
FROM global_markets.stocks_13f_filings
WHERE form_type LIKE '13F-HR%'
AND form_type NOT LIKE '%/A'
AND filing_date >= today() - 730
GROUP BY accession_number
)
WHERE period_end IS NOT NULL
AND days_to_file BETWEEN 0 AND 200
GROUP BY month
HAVING count() >= 50
ORDER BY month
Work with this data in your AI assistant
Opens ready to query, with this page's data. Free, no account.