Schedule 13D family filings per month, last two years
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-08-22, from Schedule 13D vs 13G: Rules and Deadlines.
| month | month_label | filings_13d |
|---|---|---|
| 2024-08-01 | Aug 2024 | 911 |
| 2024-09-01 | Sep 2024 | 854 |
| 2024-10-01 | Oct 2024 | 941 |
| 2024-11-01 | Nov 2024 | 1028 |
| 2024-12-01 | Dec 2024 | 607 |
| 2025-01-01 | Jan 2025 | 2 |
| 2025-02-01 | Feb 2025 | 3 |
| 2025-03-01 | Mar 2025 | 2 |
| 2025-04-01 | Apr 2025 | 2 |
| 2025-05-01 | May 2025 | 1 |
| 2025-07-01 | Jul 2025 | 1 |
| 2026-02-01 | Feb 2026 | 1 |
| 2026-03-01 | Mar 2026 | 1 |
| 2026-05-01 | May 2026 | 7 |
| 2026-06-01 | Jun 2026 | 11 |
| 2026-07-01 | Jul 2026 | 4 |
- Rows × columns
- 16 × 3
- Period covered
- to
- 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 |
date | 2024-08-01 to 2026-07-01 | |
month_label |
text | 16 distinct values (Apr 2025, Aug 2024, Dec 2024…) | |
filings_13d |
number | 1 to 1,028 |
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.
the exact SQL behind every number
SELECT
toString(toStartOfMonth(filing_date)) AS month,
formatDateTime(toStartOfMonth(filing_date), '%b %Y') AS month_label,
count() AS filings_13d
FROM global_markets.stocks_sec_edgar_index
WHERE filing_date >= toStartOfMonth(today() - 730)
AND filing_date < toStartOfMonth(today())
AND form_type LIKE 'SC 13D%'
GROUP BY toStartOfMonth(filing_date)
ORDER BY month
Run your own version of this
The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.
More from this analysisSchedule 13D vs 13G: Rules and Deadlines
Companies that drew an initial 13D after 13G coverage
table 12×5
→
Most-filed 13D names of the last 18 months
ranking 4×4
→
Weekly average daily volume: Reddit's first year of trading, March 2024 to March 2025
series 53×2
→
TSLA's next 20 sessions: every close indexed to the February 8, 2021 close
series 21×3
→
Diluted shares outstanding by calendar quarter, three long-running programmes
series 20×4
→
Form 8-K disclosures mentioning a lockup, by month
series 17×4
→
See all 2,170 queries →