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

Rule 144 and Selling Restricted Stock
Recent US listings and their six-month Rule 144 marktable · 2026-08-22 · 15×5 Reported insider open-market sales by size, trailing yearranking · 2026-08-22 · 5×2Preview: 5 ranked values, largest first. The two Rule 144 volume tests, in millions of sharestable · 2026-08-22 · 6×5 Weekly share turnover across US companies, four-week averageranking · 2026-08-22 · 5×2Preview: 5 ranked values, smallest first.
Recent US listings and their six-month Rule 144 mark

Recent US listings and their six-month Rule 144 mark

most recentas of table 15×5read in context →
Recent US listings and their six-month Rule 144 mark — 15 rows by 5 columns, computed from US exchange, SIP and OPRA data.
tickerissuerlisted_oneligible_fromdays_remaining
CTAAUClearThink 1 Acquisition CorpFeb 23, 2026Aug 23, 20261
MZYXUMOZAYYX Acquisition CorpFeb 25, 2026Aug 25, 20263
FVAVFortress Value Acquisition Corp. VFeb 26, 2026Aug 26, 20264
TRADUAPEX Tech Acquisition Inc.Feb 26, 2026Aug 26, 20264
TRGSUTRG Latin America Acquisitions Corp.Feb 26, 2026Aug 26, 20264
BCACUBrookline Capital Acquisition Corp IIFeb 27, 2026Aug 27, 20265
GENBGenerate Biomedicines IncFeb 27, 2026Aug 27, 20265
IDACUIron Dome Acquisition I Corp.Feb 27, 2026Aug 27, 20265
ILLUUIllumination Acquisition Corp IFeb 27, 2026Aug 27, 20265
CASTFreecast IncMar 3, 2026Sep 3, 202612
GLEDUGalaxyEdge Acquisition CorpMar 4, 2026Sep 4, 202613
IPFXUInflection Point Acquisition Corp. VIMar 4, 2026Sep 4, 202613
KCACUKensington Capital Acquisition Corp VIMar 4, 2026Sep 4, 202613
SUMAUSUMA Acquisition CorpMar 4, 2026Sep 4, 202613
MMEDMiniMed Group IncMar 5, 2026Sep 5, 202614
the exact SQL behind every number
SELECT
    ticker,
    any(issuer_name)                                                      AS issuer,
    formatDateTime(min(listing_date), '%b %e, %Y')                        AS listed_on,
    formatDateTime(addMonths(min(listing_date), 6), '%b %e, %Y')          AS eligible_from,
    dateDiff('day', today(), addMonths(min(listing_date), 6))             AS days_remaining
FROM global_markets.stocks_ipos
WHERE listing_date > addMonths(today(), -6)
  AND listing_date <= today()
  AND ticker != ''
  AND ticker NOT IN ('SPCX')
GROUP BY ticker
ORDER BY days_remaining ASC, ticker ASC
LIMIT 15
$