ipo_float_math

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 ipo AS
(
    SELECT argMax(toFloat64(max_shares_offered), last_updated) AS shares_offered
    FROM global_markets.stocks_ipos
    WHERE ticker = 'FIG'
      AND listing_date >= '2025-07-01'
      AND listing_date <  '2025-08-31'
),
bars AS
(
    SELECT
        date,
        volume,
        row_number() OVER (ORDER BY date) AS seq
    FROM
    (
        SELECT
            date,
            argMax(toFloat64(volume), _ingest_time) AS volume
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'FIG'
          AND date >= '2025-07-31'
        GROUP BY date
    )
),
anchors AS
(
    SELECT
        anyIf(seq, date = '2025-11-07') AS ipo_lockup_end,
        anyIf(seq, date = '2026-08-07') AS final_tranche
    FROM bars
),
traded AS
(
    SELECT
        sumIf(b.volume, toInt32(b.seq) BETWEEN toInt32(a.ipo_lockup_end) AND toInt32(a.ipo_lockup_end) + 4) AS nov_five_sessions,
        sumIf(b.volume, toInt32(b.seq) BETWEEN toInt32(a.final_tranche)  AND toInt32(a.final_tranche)  + 4) AS aug_five_sessions
    FROM bars AS b
    CROSS JOIN anchors AS a
)
SELECT
    tupleElement(bucket, 1)                 AS label,
    round(tupleElement(bucket, 2) / 1e6, 1) AS shares_millions
FROM
(
    SELECT arrayJoin([
        ('Offered in the IPO',                          shares_offered),
        ('Traded, five sessions from Nov 7 2025',        nov_five_sessions),
        ('Traded, five sessions from Aug 7 2026',        aug_five_sessions)
    ]) AS bucket
    FROM ipo
    CROSS JOIN traded
)