STRASMORE/EXPLORE 2,173 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,173 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

Schedule 13D vs 13G: Rules and Deadlines
Schedule 13D family filings per month, last two yearsseries · 2026-08-22 · 16×3Preview: a 16-point series, ending lower. Companies that drew an initial 13D after 13G coveragetable · 2026-08-22 · 12×5 Most-filed 13D names of the last 18 monthsranking · 2026-08-22 · 4×4Preview: 4 ranked values, largest first.
Schedule 13D family filings per month, last two years

Schedule 13D family filings per month, last two years

most recentas of series 16×3read in context →
Schedule 13D family filings per month, last two years — 16 rows by 3 columns, computed from US exchange, SIP and OPRA data.
monthmonth_labelfilings_13d
2024-08-01Aug 2024911
2024-09-01Sep 2024854
2024-10-01Oct 2024941
2024-11-01Nov 20241028
2024-12-01Dec 2024607
2025-01-01Jan 20252
2025-02-01Feb 20253
2025-03-01Mar 20252
2025-04-01Apr 20252
2025-05-01May 20251
2025-07-01Jul 20251
2026-02-01Feb 20261
2026-03-01Mar 20261
2026-05-01May 20267
2026-06-01Jun 202611
2026-07-01Jul 20264
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
$