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

Early Lockup Release: Triggers and Waivers
IPO registration and prospectus filings since 2022ranking · 2026-08-22 · 7×3Preview: 7 ranked values, largest first. Form 8-K disclosures mentioning a lockup, by monthseries · 2026-08-22 · 17×4Preview: a 16-point series, ending higher. How much of a company an IPO actually sellsranking · 2026-08-22 · 6×2Preview: 6 ranked values, smallest first. Days from listing to a company's first lockup 8-Kranking · 2026-08-22 · 3×2Preview: 3 ranked values, smallest first.
IPO registration and prospectus filings since 2022

IPO registration and prospectus filings since 2022

most recentas of ranking 7×3read in context →
IPO registration and prospectus filings since 2022 — 7 rows by 3 columns, computed from US exchange, SIP and OPRA data.
form_typefilingscompanies
424B3365484400
S-1/A78772246
S-142192444
F-1/A3549755
424B421701535
F-11381856
424B1163142
the exact SQL behind every number
SELECT
    form_type,
    countDistinct(accession_number) AS filings,
    countDistinct(cik)              AS companies
FROM global_markets.stocks_sec_edgar_index
WHERE filing_date >= '2022-01-01'
  AND form_type IN ('S-1', 'S-1/A', 'F-1', 'F-1/A', '424B4', '424B1', '424B3')
GROUP BY form_type
ORDER BY filings DESC
$