3,256 answered market questions

WITH
    per_second AS
    (
        SELECT
            toDateTime(sip_timestamp) AS second_bucket,
            count()                   AS messages
        FROM global_markets.cache_stocks_quotes
        WHERE ticker = 'NVDA'
          AND sip_timestamp >= '2026-09-15 13:30:00'
          AND sip_timestamp <  '2026-09-15 15:30:00'
        GROUP BY second_bucket
    ),
    totals AS
    (
        SELECT
            count()       AS second_count,
            sum(messages) AS message_count
        FROM per_second
    )
SELECT
    multiIf(messages = 1,    '1 update',
            messages <= 5,   '2 to 5',
            messages <= 20,  '6 to 20',
            messages <= 100, '21 to 100',
            'over 100')                                                  AS updates_in_the_second,
    round(100.0 * count() / (SELECT second_count FROM totals), 1)         AS share_of_seconds_pct,
    round(100.0 * sum(messages) / (SELECT message_count FROM totals), 1) AS share_of_messages_pct
FROM per_second
GROUP BY updates_in_the_second
ORDER BY min(messages)