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.
Figma Lockup Expiration: FIG on the Tape
Close versus the last pre-release close, five sessions either sideranking · 2026-10-04 · 11×4Preview: 11 ranked values, smallest first. Relative volume around three Figma lockup releases (session 0 = first sellable session)ranking · 2026-10-04 · 11×4Preview: 11 ranked values, smallest first. Every Figma lockup release date: release-day turnover and the sessions afterranking · 2026-10-04 · 5×4Preview: 5 ranked values, largest first. Near-the-money Figma implied volatility around the August 7, 2026 releaseseries · 2026-10-04 · 45×4Preview: a 16-point series, roughly flat. Figma's IPO offering against the shares that changed hands after two releasesranking · 2026-10-04 · 3×2Preview: 3 ranked values, smallest first. Sessions printed per calendar year under this ticker, both listingsranking · 2026-10-04 · 16×4Preview: 16 ranked values, largest first.
Early Lockup Release: Triggers and Waivers
IPO registration and prospectus filings since 2022ranking · 2026-10-04 · 7×3Preview: 7 ranked values, largest first. Form 8-K disclosures mentioning a lockup, by monthseries · 2026-10-04 · 18×4Preview: a 16-point series, ending higher. How much of a company an IPO actually sellsranking · 2026-10-04 · 6×2Preview: 6 ranked values, smallest first. Days from listing to a company's first lockup 8-Kranking · 2026-10-04 · 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
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
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 3,256 queries →
$