3,256 answered market questions

SELECT
    b.print_size                                 AS print_size,
    b.print_count                                AS print_count,
    round(100 * b.tier_shares / t.day_shares, 2) AS share_of_volume_pct
FROM
(
    SELECT
        multiIf(size <   100, 'under 100 shares',
                size <  1000, '100 to 999 shares',
                size < 10000, '1,000 to 9,999 shares',
                              '10,000 shares and up') AS print_size,
        multiIf(size < 100, 1, size < 1000, 2, size < 10000, 3, 4) AS tier_rank,
        count()                                       AS print_count,
        toFloat64(sum(size))                          AS tier_shares
    FROM global_markets.stocks_trades
    WHERE ticker = 'AAPL'
      AND sip_timestamp >= toDateTime('2026-06-17 08:00:00', 'UTC')
      AND sip_timestamp <  toDateTime('2026-06-18 02:00:00', 'UTC')
    GROUP BY print_size, tier_rank
) AS b
CROSS JOIN
(
    SELECT toFloat64(sum(size)) AS day_shares
    FROM global_markets.stocks_trades
    WHERE ticker = 'AAPL'
      AND sip_timestamp >= toDateTime('2026-06-17 08:00:00', 'UTC')
      AND sip_timestamp <  toDateTime('2026-06-18 02:00:00', 'UTC')
) AS t
ORDER BY b.tier_rank