STRASMORE/EXPLORE 3,256 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,256 answered market questions

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

How to Read a 10-K Annual Report Filing
Which 10-K sections get captured, and how long they runranking · 2026-10-09 · 3×4Preview: 3 ranked values, largest first. The biggest risk-factor categories, by number of companies disclosingranking · 2026-10-09 · 7×2Preview: 7 ranked values, largest first. The 10-K family on EDGAR: annual filings, amendments and late noticesranking · 2026-10-09 · 4×2Preview: 4 ranked values, largest first. When annual filings land: 10-K filings by calendar month, three yearsseries · 2026-10-09 · 12×4Preview: a 12-point series, roughly flat. One company's 10-K text, fiscal year by fiscal year (AAPL)ranking · 2026-10-09 · 3×3Preview: 3 ranked values, largest first.
The Most Common SEC Filings, Explained by Data
Total EDGAR filings and the Form 4 share, by quarter (last 12 full quarters)table · 2026-10-04 · 12×6 The EDGAR filing index at a glance: trailing 12 monthsscalar · 2026-10-04 · 1×71.2 The most common SEC form types: share of all EDGAR filings, trailing 12 monthsranking · 2026-10-04 · 12×2Preview: 12 ranked values, largest first. Where the well-known SEC forms rank: filings and overall rank, trailing 12 monthsranking · 2026-10-04 · 8×4Preview: 8 ranked values, largest first. Apple's EDGAR footprint: filings by form type, trailing 12 monthstable · 2026-10-04 · 6×6 The most-amended SEC forms: /A filings, trailing 12 monthsranking · 2026-10-04 · 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.
Which 10-K sections get captured, and how long they run

Which 10-K sections get captured, and how long they run

most recentas of ranking 3×4read in context →
Which 10-K sections get captured, and how long they run — 3 rows by 4 columns, computed from US exchange, SIP and OPRA data.
sectionfiling_countcompany_countavg_thousand_characters
business4970162546.5
risk_factors4957162169.9
mda19419455.1
the exact SQL behind every number
SELECT
    section                                  AS section,
    uniqExact(cik, period_end)               AS filing_count,
    uniqExact(cik)                           AS company_count,
    round(avg(length(text)) / 1000.0, 1)     AS avg_thousand_characters
FROM global_markets.stocks_10k_sections
WHERE period_end >= '2020-01-01'
  AND section != ''
  AND length(text) > 0
GROUP BY section
ORDER BY filing_count DESC
LIMIT 12
$