Small AAPL print sizes: five sessions in January 2026 against five in July 2026

SELECT
    scaffold.shares                        AS shares,
    toUInt64(ifNull(t.jan_prints, 0))      AS prints_early_january,
    toUInt64(ifNull(t.jul_prints, 0))      AS prints_early_july
FROM
(
    SELECT toUInt32(arrayJoin(range(0, 26))) AS shares
) AS scaffold
LEFT JOIN
(
    SELECT
        toUInt32(floor(toFloat64(size)))                 AS shares,
        countIf(sip_timestamp <  '2026-02-01 00:00:00')  AS jan_prints,
        countIf(sip_timestamp >= '2026-07-01 00:00:00')  AS jul_prints
    FROM global_markets.stocks_trades
    WHERE ticker = 'AAPL'
      AND ((sip_timestamp >= '2026-01-05 00:00:00' AND sip_timestamp < '2026-01-10 00:00:00')
        OR (sip_timestamp >= '2026-07-06 00:00:00' AND sip_timestamp < '2026-07-11 00:00:00'))
      AND toFloat64(size) < 26
    GROUP BY shares
) AS t ON t.shares = scaffold.shares
ORDER BY shares