STRASMORE/EXPLORE 2,358 QUERIES

lockup_pipeline

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-09-18, from upcoming-ipo-lockup-expirations.

as of series 13×3read in context →
lockup_pipeline — 13 rows by 3 columns, computed from US exchange, SIP and OPRA data.
monthmonth_labelipo_count
2025-09Sep 20257
2025-10Oct 202530
2025-11Nov 202513
2025-12Dec 202517
2026-01Jan 202613
2026-02Feb 202618
2026-03Mar 20267
2026-04Apr 202618
2026-05May 202621
2026-06Jun 202623
2026-07Jul 202615
2026-08Aug 202611
2026-09Sep 20261
Rows × columns
13 × 3
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for lockup_pipeline, derived from the stored result.
ColumnTypeRangeNotes
month text 13 distinct values (2025-09, 2025-10, 2025-11…)
month_label text 13 distinct values (Apr 2026, Aug 2026, Dec 2025…)
ipo_count number 1 to 30 count

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

the exact SQL behind every number 
SELECT
    formatDateTime(listing_month, '%Y-%m')                  AS month,
    formatDateTime(listing_month, '%b %Y')                  AS month_label,
    count()                                                 AS ipo_count
FROM
(
    SELECT
        ticker,
        toStartOfMonth(argMax(toDate(listing_date), _ingest_time)) AS listing_month
    FROM global_markets.stocks_ipos
    WHERE ticker != ''
      AND ticker NOT IN ('SPCX')
      AND toDate(listing_date) BETWEEN today() - 365 AND today()
      AND ipo_status NOT IN ('pending', 'postponed', 'withdrawn', 'rumor', 'direct_listing_process')
      AND positionCaseInsensitive(issuer_name, 'acquisition') = 0
      AND final_issue_price > 0
    GROUP BY ticker
)
GROUP BY listing_month
ORDER BY listing_month

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisupcoming-ipo-lockup-expirations
lockup_calendar table 57×8 → price_vs_offer table 51×5 → prospectus_receipts table 50×4 → early_release_watch table 25×6 → One SPY $600 LEAPS call's price over two years (expired Jan 16 2026) series 470×2 → monthly series 241×4 → See all 2,358 queries →