STRASMORE/EXPLORE 2,173 QUERIES

H1 2026 listings: totals, the typical deal, and the concentration receipts

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-07-26, from IPO Market 2026: The First Half in Numbers.

as of scalar 1×11read in context →
listings
184
raised b
133.5
june raised b
86.8
june share pct
65
biggest deal b
75
biggest deal share pct
56.2
billion dollar deals
11
average deal m
738
median deal m
200
with offer price
178
trading sessions
123
Rows × columns
1 × 11
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 H1 2026 listings: totals, the typical deal, and the concentration receipts, derived from the stored result.
ColumnTypeRangeNotes
listings number every row is 184
raised_b number every row is 133.5
june_raised_b number every row is 86.8
june_share_pct number every row is 65 percent
biggest_deal_b number every row is 75
biggest_deal_share_pct number every row is 56.2 percent
billion_dollar_deals number every row is 11
average_deal_m number every row is 738
median_deal_m number every row is 200
with_offer_price number every row is 178 US dollars
trading_sessions number every row is 123

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 count() AS listings,
       round(sum(total_offer_size) / 1e9, 1) AS raised_b,
       round(sumIf(total_offer_size, listing_date >= '2026-06-01') / 1e9, 1) AS june_raised_b,
       round(100 * toFloat64(sumIf(total_offer_size, listing_date >= '2026-06-01')) / toFloat64(sum(total_offer_size)), 1) AS june_share_pct,
       round(max(total_offer_size) / 1e9, 1) AS biggest_deal_b,
       round(100 * toFloat64(max(total_offer_size)) / toFloat64(sum(total_offer_size)), 1) AS biggest_deal_share_pct,
       countIf(total_offer_size >= 1000000000) AS billion_dollar_deals,
       round(avg(total_offer_size) / 1e6, 0) AS average_deal_m,
       round(quantileExact(0.5)(toFloat64(total_offer_size)) / 1e6, 0) AS median_deal_m,
       countIf(final_issue_price > 0) AS with_offer_price,
       (SELECT uniqExact(toDate(toTimeZone(window_start, 'America/New_York')))
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'SPY'
          AND window_start >= toDateTime('2026-01-01 00:00:00')
          AND window_start < toDateTime('2026-07-01 00:00:00')) AS trading_sessions
FROM global_markets.stocks_ipos
WHERE ipo_status = 'history'
  AND currency_code = 'USD'
  AND listing_date >= '2026-01-01'
  AND listing_date <= '2026-06-30'

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 analysisIPO Market 2026: The First Half in Numbers
The eight largest US listings of H1 2026 by offer size ranking 8×3 → First-half listings by year, 2019-2026: like-for-like January-June counts and dollars ranking 8×3 → US-dollar listings by month, H1 2026: count and dollars raised series 6×3 → H1 2026 listings by primary exchange: count, dollars, and the unit-offering share ranking 4×4 → H1 2026 listings by security type: count, dollars, and the typical deal in each bucket table 3×5 → H1 2026 listings vs their offer price: last regular-hours close of July 6-10, by type table 3×7 → See all 2,173 queries →