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

2,170 answered market questions

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

The Most Common SEC Filings, Explained by Data
Total EDGAR filings and the Form 4 share, by quarter (last 12 full quarters)table · 2026-08-22 · 12×6 The EDGAR filing index at a glance: trailing 12 monthsscalar · 2026-08-22 · 1×71.2 The most common SEC form types: share of all EDGAR filings, trailing 12 monthsranking · 2026-08-22 · 12×2Preview: 12 ranked values, largest first. Where the well-known SEC forms rank: filings and overall rank, trailing 12 monthsranking · 2026-08-22 · 8×4Preview: 8 ranked values, largest first. Apple's EDGAR footprint: filings by form type, trailing 12 monthstable · 2026-08-22 · 6×6 The most-amended SEC forms: /A filings, trailing 12 monthsranking · 2026-08-22 · 8×4Preview: 8 ranked values, largest first.
How to Read a Form 4 Insider Trading Filing
Calendar days from transaction date to Form 4 filing dateranking · 2026-08-08 · 6×3Preview: 6 ranked values, largest first. Form 4 filings containing a sale: with an exercise on the same document, or withoutseries · 2026-08-08 · 12×4Preview: a 12-point series, ending higher. Share of Form 4 lines booked as indirect ownership, by transaction coderanking · 2026-08-08 · 6×3Preview: 6 ranked values, largest first. Share of reported Form 4 lines by transaction code, Aug 2025 to Jul 2026ranking · 2026-08-08 · 7×3Preview: 7 ranked values, smallest first. Original Form 4 documents and Form 4/A amendments, by filing monthseries · 2026-08-08 · 12×4Preview: a 12-point series, ending higher.
SEC EDGAR Index Gap: the Missing Month-Ends
Every weekday month-end since 2020: filings indexed on the month's last calendar daytable · 2026-07-26 · 55×2 Every weekday month-end since 2020 with fewer than 1,000 filings: count, companies touched, and the neighbouring days' averagetable · 2026-07-26 · 6×6 Filing counts on the last weekday of each 2026 month, with prior-year weekday month-ends as controlsranking · 2026-07-26 · 8×3Preview: 8 ranked values, largest first. Status receipt: the March and April boundary days, their arrival times, and their counts as of this runscalar · 2026-07-26 · 1×655 When each day's rows actually landed in the warehouse, June 26 to the front edgeranking · 2026-07-26 · 10×3Preview: 10 ranked values, largest first. Form types on the gap day (June 30, 2026) against the trading day before itranking · 2026-07-26 · 14×3Preview: 14 ranked values, smallest first. Is June 30, 2026 missing anywhere else? The same day across five date-keyed datasetsranking · 2026-07-26 · 5×3Preview: 5 ranked values, largest first.
Total EDGAR filings and the Form 4 share, by quarter (last 12 full quarters)

Total EDGAR filings and the Form 4 share, by quarter (last 12 full quarters)

most recentas of table 12×6read in context →
Total EDGAR filings and the Form 4 share, by quarter (last 12 full quarters) — 12 rows by 6 columns, computed from US exchange, SIP and OPRA data.
quarterall_filings_kform4_filings_kall_filings_displayform4_filings_displayform4_pct_of_filings
2023-Q3245.468.4245,39168,36327.9
2023-Q4247.972.3247,86872,25829.2
2024-Q1355.6120.6355,632120,56333.9
2024-Q2310.599.9310,47099,94232.2
2024-Q3263.467.5263,42567,47725.6
2024-Q4276.672.8276,60772,82526.3
2025-Q1328.3114.5328,296114,49734.9
2025-Q2309.991.8309,90991,75629.6
2025-Q3270.464.5270,44264,45423.8
2025-Q4263.666.3263,59366,26125.1
2026-Q1350.3111.9350,306111,87231.9
2026-Q2336.5100.8336,460100,76929.9
the exact SQL behind every number 
SELECT formatDateTime(toStartOfQuarter(filing_date), '%Y-Q') || toString(toQuarter(filing_date)) AS quarter,
       round(count() / 1000.0, 1) AS all_filings_k,
       round(countIf(form_type = '4') / 1000.0, 1) AS form4_filings_k,
       reverse(arrayStringConcat(extractAll(reverse(toString(count())), '[0-9]{1,3}'), ',')) AS all_filings_display,
       reverse(arrayStringConcat(extractAll(reverse(toString(countIf(form_type = '4'))), '[0-9]{1,3}'), ',')) AS form4_filings_display,
       round(100.0 * countIf(form_type = '4') / count(), 1) AS form4_pct_of_filings
FROM global_markets.stocks_sec_edgar_index
WHERE filing_date >= toStartOfQuarter(today() - INTERVAL 36 MONTH)
  AND filing_date < toStartOfQuarter(today())
GROUP BY quarter, toStartOfQuarter(filing_date)
ORDER BY toStartOfQuarter(filing_date)
More from this analysisThe Most Common SEC Filings, Explained by Data
Apple's EDGAR footprint: filings by form type, trailing 12 months table 6×6 → The most common SEC form types: share of all EDGAR filings, trailing 12 months ranking 12×2 → Where the well-known SEC forms rank: filings and overall rank, trailing 12 months ranking 8×4 → The most-amended SEC forms: /A filings, trailing 12 months ranking 8×4 → See all 2,170 queries →
$