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

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.
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 Quiet Period Rules and Timeline
Days from announced deal to first trade, US listings since January 2025ranking · 2026-08-19 · 7×3Preview: 7 ranked values, largest first. The three clocks, dated, for the largest US listings since January 2025table · 2026-08-19 · 10×7
Japanese IPO Lockups: The 1.5x Release Rule
One US listing traced against a flat line at 1.5x its offer priceseries · 2026-08-07 · 82×3Preview: a 16-point series, roughly flat. Share of US listings trading at 1.5x their offer price, by day since listingranking · 2026-08-07 · 19×2Preview: 16 ranked values, smallest first. US listings clearing 1.5x the offer price on the first close, by listing yearranking · 2026-08-07 · 8×4Preview: 8 ranked values, smallest first.
How to Find a Lockup Expiration Date
Weekly average daily volume: Reddit's first year of trading, March 2024 to March 2025series · 2026-08-03 · 53×2Preview: a 16-point series, ending lower. Reddit share volume by window, counted in days from the March 20, 2024 pricing dateranking · 2026-08-03 · 5×3Preview: 5 ranked values, largest first. Day 180 counted from the pricing date: nine US listingsseries · 2026-08-03 · 9×6Preview: a 9-point series, ending higher. Volume in the four weeks around day 180 vs the weeks before it: nine US listingsranking · 2026-08-03 · 9×4Preview: 9 ranked values, largest first.
IPO Lockup Expiration: Meaning & Release Date
UBER options tape into the Nov 6, 2019 lockup expiry: put and call contract volume by sessionseries · 2026-07-26 · 13×5Preview: a 13-point series, roughly flat. Five famous lockup expirations: expiry-day price change and volume multiple vs. the prior sessionseries · 2026-07-26 · 5×7Preview: a 5-point series, roughly flat. FB daily closes and volume, Oct 22 – Nov 13, 2012: the run-in to the giant lockup expiry (as-traded prices)series · 2026-07-26 · 15×5Preview: a 15-point series, roughly flat. FB from the eve of the Nov 14, 2012 unlock through month-end: did the expiry-day pop hold?series · 2026-07-26 · 13×4Preview: a 13-point series, ending higher.
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
More from this analysisRule 144 and Selling Restricted Stock
The two Rule 144 volume tests, in millions of shares table 6×5 → Reported insider open-market sales by size, trailing year ranking 5×2 → Weekly share turnover across US companies, four-week average ranking 5×2 → Weekly average daily volume: Reddit's first year of trading, March 2024 to March 2025 series 53×2 → See all 2,170 queries →
$