2,469 answered market questions

WITH debut AS
(
    SELECT min(toDate(toTimeZone(window_start, 'America/New_York'))) AS d0
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPCX'
      AND window_start >= '2026-06-01'
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) >= 570
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) < 960
)
SELECT
    concat(toString(n), '-day')                              AS convention,
    n                                                        AS calendar_days,
    formatDateTime((SELECT d0 FROM debut) + n, '%b %e, %Y')  AS lands_on,
    formatDateTime((SELECT d0 FROM debut) + n, '%a')         AS weekday,
    dateDiff('day', today(), (SELECT d0 FROM debut) + n)     AS days_from_today
FROM
(
    SELECT arrayJoin([90, 120, 180, 270]) AS n
)
ORDER BY n