top_debuts

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

WITH
    offerte AS
    (
        SELECT
            ticker,
            argMax(toDate(listing_date), _ingest_time)         AS data_quotazione,
            argMax(toFloat64(final_issue_price), _ingest_time) AS prezzo_offerta,
            argMax(toFloat64(total_offer_size), _ingest_time)  AS raccolta,
            argMax(issuer_name, _ingest_time)                  AS emittente
        FROM global_markets.stocks_ipos
        WHERE toDate(listing_date) >= '2026-01-01'
          AND toDate(listing_date) <  '2026-07-01'
          AND lower(ifNull(ipo_status, '')) NOT IN ('pending', 'postponed', 'withdrawn', 'rumor', 'direct_listing_process')
          AND final_issue_price >= 4
          AND total_offer_size > 0
          AND lower(ifNull(issuer_name, '')) NOT LIKE '%acquisition%'
          AND lower(ifNull(security_description, '')) NOT LIKE '%unit%'
          AND lower(ifNull(security_description, '')) NOT LIKE '%warrant%'
          AND ticker NOT IN ('SPCX')
        GROUP BY ticker
    ),
    prime_sedute AS
    (
        SELECT
            o.ticker                           AS simbolo,
            o.emittente                        AS societa_emittente,
            o.data_quotazione                  AS quotato_il,
            o.prezzo_offerta                   AS prezzo_coll,
            o.raccolta                         AS raccolta_usd,
            argMin(toFloat64(a.open),  a.date) AS prima_apertura_usd,
            argMin(toFloat64(a.close), a.date) AS prima_chiusura_usd
        FROM global_markets.stocks_daily_aggs AS a
        INNER JOIN offerte AS o ON a.ticker = o.ticker
        WHERE a.ticker IN (SELECT ticker FROM offerte)
          AND a.date >= '2026-01-01'
          AND a.date <  '2026-07-10'
          AND a.date >= o.data_quotazione
          AND a.date <= o.data_quotazione + 5
          AND a.volume > 0
        GROUP BY o.ticker, o.emittente, o.data_quotazione, o.prezzo_offerta, o.raccolta
    )
SELECT
    simbolo                                                AS ticker,
    substring(societa_emittente, 1, 40)                    AS societa,
    formatDateTime(quotato_il, '%d/%m/%Y')                 AS primo_giorno_di_negoziazione,
    concat('$', toString(round(prezzo_coll, 2)))           AS prezzo_di_collocamento,
    concat('$', toString(round(prima_apertura_usd, 2)))    AS prima_apertura,
    concat('$', toString(round(prima_chiusura_usd, 2)))    AS prima_chiusura_ufficiale,
    round(prima_chiusura_usd / prezzo_coll * 100 - 100, 1) AS rendimento_primo_giorno_pct,
    toUInt32(round(raccolta_usd / 1e6))                    AS raccolta_mln_usd
FROM prime_sedute
ORDER BY raccolta_usd DESC
LIMIT 12