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

Rule 144 and Selling Restricted Stock
Recent US listings and their six-month Rule 144 marktable · 2026-10-04 · 15×5 Reported insider open-market sales by size, trailing yearranking · 2026-10-04 · 5×2Preview: 5 ranked values, largest first. The two Rule 144 volume tests, in millions of sharestable · 2026-10-04 · 6×5 Weekly share turnover across US companies, four-week averageranking · 2026-10-04 · 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
NHIVUNewHold Investment Corp IVApr 14, 2026Oct 14, 202610
QREDUQuasaredge Acquisition Corp.Apr 15, 2026Oct 15, 202611
ARXSArxis Inc.Apr 16, 2026Oct 16, 202612
MAIRMadison Air Solutions Corp.Apr 16, 2026Oct 16, 202612
ALMRAlamar Biosciences Inc.Apr 17, 2026Oct 17, 202613
AVEXAEVEX Corp.Apr 17, 2026Oct 17, 202613
JATTJatt II Acquisition Corp.Apr 17, 2026Oct 17, 202613
KLRAKailera Therapeutics Inc.Apr 17, 2026Oct 17, 202613
EMIEncore Medical Inc.Apr 22, 2026Oct 22, 202618
NHPNational Healthcare Properties Inc.Apr 22, 2026Oct 22, 202618
YSWYYesway IncApr 22, 2026Oct 22, 202618
ELMTElmet Group Co. TheApr 23, 2026Oct 23, 202619
LABTLakewood-Amedex Biotherapeutics Inc.Apr 23, 2026Oct 23, 202619
XEX-Energy Inc.Apr 24, 2026Oct 24, 202620
CXIIUChurchill Capital Corp XIIApr 28, 2026Oct 28, 202624
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
$