STRASMORE/EXPLORE 2,173 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,173 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

IPO Market 2026: The First Half in Numbers
US-dollar listings by month, H1 2026: count and dollars raisedseries · 2026-07-26 · 6×3Preview: a 6-point series, ending higher. H1 2026 listings by security type: count, dollars, and the typical deal in each buckettable · 2026-07-26 · 3×5 H1 2026 listings: totals, the typical deal, and the concentration receiptsscalar · 2026-07-26 · 1×11184 H1 2026 listings by primary exchange: count, dollars, and the unit-offering shareranking · 2026-07-26 · 4×4Preview: 4 ranked values, largest first. The eight largest US listings of H1 2026 by offer sizeranking · 2026-07-26 · 8×3Preview: 8 ranked values, largest first. First-half listings by year, 2019-2026: like-for-like January-June counts and dollarsranking · 2026-07-26 · 8×3Preview: 8 ranked values, smallest first. H1 2026 listings vs their offer price: last regular-hours close of July 6-10, by typetable · 2026-07-26 · 3×7
US-dollar listings by month, H1 2026: count and dollars raised

US-dollar listings by month, H1 2026: count and dollars raised

most recentas of series 6×3read in context →
US-dollar listings by month, H1 2026: count and dollars raised — 6 rows by 3 columns, computed from US exchange, SIP and OPRA data.
monthlistingsraised_bn_usd
2026-01-01358.3
2026-02-014510.6
2026-03-01153.8
2026-04-01197.8
2026-05-013716.2
2026-06-013386.8
the exact SQL behind every number
SELECT toStartOfMonth(listing_date) AS month,
       count() AS listings,
       round(sum(total_offer_size) / 1e9, 1) AS raised_bn_usd
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'
GROUP BY month
ORDER BY month
$