One US listing traced against a flat line at 1.5x its offer price

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 offer AS
(
    SELECT
        min(listing_date)                 AS listed_on,
        toFloat64(max(final_issue_price)) AS offer_price
    FROM global_markets.stocks_ipos
    WHERE ticker = 'RDDT'
      AND final_issue_price > 0
)
SELECT
    toString(d.date)              AS date,
    round(toFloat64(d.close), 2)  AS close_usd,
    round(o.offer_price * 1.5, 2) AS trigger_1_5x
FROM
(
    SELECT date, close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'RDDT'
      AND date >= '2024-01-01'
      AND date <  '2025-01-01'
) AS d
CROSS JOIN offer AS o
WHERE d.date >= o.listed_on
  AND d.date <  o.listed_on + 120
ORDER BY d.date