3,256 answered market questions

WITH bars AS
(
    SELECT
        date,
        close,
        row_number() OVER (ORDER BY date) AS seq
    FROM
    (
        SELECT
            date,
            argMax(toFloat64(close), _ingest_time) AS close
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'FIG'
          AND date >= '2025-07-31'
        GROUP BY date
    )
),
anchors AS
(
    SELECT
        anyIf(seq, date = '2025-09-05')   AS employee_release,
        anyIf(seq, date = '2025-11-07')   AS ipo_lockup_end,
        anyIf(seq, date = '2026-08-07')   AS final_tranche,
        anyIf(close, date = '2025-09-04') AS employee_base,
        anyIf(close, date = '2025-11-06') AS ipo_base,
        anyIf(close, date = '2026-08-06') AS final_base
    FROM bars
),
offsets AS
(
    SELECT arrayJoin(range(11)) - 5 AS session_offset
)
SELECT
    o.session_offset AS session_offset,
    round(100 * (anyIf(b.close, toInt32(b.seq) = toInt32(a.employee_release) + o.session_offset) / any(a.employee_base) - 1), 2) AS sep_2025_pct,
    round(100 * (anyIf(b.close, toInt32(b.seq) = toInt32(a.ipo_lockup_end)   + o.session_offset) / any(a.ipo_base)      - 1), 2) AS nov_2025_pct,
    round(100 * (anyIf(b.close, toInt32(b.seq) = toInt32(a.final_tranche)    + o.session_offset) / any(a.final_base)    - 1), 2) AS aug_2026_pct
FROM offsets AS o
CROSS JOIN bars AS b
CROSS JOIN anchors AS a
GROUP BY session_offset
ORDER BY session_offset