auction_share_by_session

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
    closing_print AS
    (
        SELECT
            toDate(toTimeZone(sip_timestamp, 'America/New_York')) AS session,
            max(size)                                             AS auction_shares
        FROM global_markets.stocks_trades
        WHERE ticker = 'KO'
          AND sip_timestamp >= toDateTime('2026-08-03 00:00:00')
          AND sip_timestamp <  toDateTime('2026-10-01 00:00:00')
          AND toHour(toTimeZone(sip_timestamp, 'America/New_York')) = 16
          AND toMinute(toTimeZone(sip_timestamp, 'America/New_York')) = 0
        GROUP BY session
    ),
    day_volume AS
    (
        SELECT
            date        AS session,
            max(volume) AS day_shares
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'KO'
          AND date >= '2026-08-03'
          AND date <  '2026-10-01'
        GROUP BY session
    )
SELECT
    session,
    round(100 * toFloat64(auction_shares) / toFloat64(day_shares), 2) AS auction_pct,
    round(toFloat64(day_shares) / 1e6, 1)                             AS day_volume_millions
FROM closing_print
INNER JOIN day_volume USING (session)
ORDER BY session