unlock_ladder_volume

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 bars AS
(
    SELECT
        date,
        volume,
        close,
        avg(volume) OVER (ORDER BY date ROWS BETWEEN 20 PRECEDING AND 1 PRECEDING) AS avg_volume_20,
        row_number() OVER (ORDER BY date)                                          AS seq
    FROM
    (
        SELECT
            date,
            argMax(toFloat64(volume), _ingest_time) AS volume,
            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
    FROM bars
),
offsets AS
(
    SELECT arrayJoin(range(11)) - 5 AS session_offset
)
SELECT
    o.session_offset AS session_offset,
    round(anyIf(b.volume / b.avg_volume_20, toInt32(b.seq) = toInt32(a.employee_release) + o.session_offset), 2) AS sep_2025_ratio,
    round(anyIf(b.volume / b.avg_volume_20, toInt32(b.seq) = toInt32(a.ipo_lockup_end)   + o.session_offset), 2) AS nov_2025_ratio,
    round(anyIf(b.volume / b.avg_volume_20, toInt32(b.seq) = toInt32(a.final_tranche)    + o.session_offset), 2) AS aug_2026_ratio
FROM offsets AS o
CROSS JOIN bars AS b
CROSS JOIN anchors AS a
GROUP BY session_offset
ORDER BY session_offset