The three clocks, dated, for the largest US listings since January 2025

SELECT
    issuer,
    ticker,
    formatDateTime(listed_on, '%b %e, %Y')               AS first_trade,
    formatDateTime(addDays(listed_on, 10), '%b %e, %Y')  AS research_quiet_ends,
    formatDateTime(addDays(listed_on, 25), '%b %e, %Y')  AS prospectus_duty_ends,
    formatDateTime(addDays(listed_on, 180), '%b %e, %Y') AS lockup_180_mark,
    round(toFloat64(offer_size) / 1e6, 0)                AS offer_size_musd
FROM
(
    SELECT
        ticker,
        any(issuer_name)      AS issuer,
        max(listing_date)     AS listed_on,
        max(total_offer_size) AS offer_size
    FROM global_markets.stocks_ipos
    WHERE listing_date >= '2025-01-01'
      AND listing_date <  '2026-08-01'
      AND final_issue_price > 0
      AND total_offer_size > 0
      AND issuer_name != ''
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker
)
ORDER BY offer_size DESC
LIMIT 10