Sessions traded in June 2026, share of exchange-listed symbols

WITH
    per_symbol AS
    (
        SELECT
            ticker,
            count() AS sessions_traded
        FROM global_markets.stocks_daily_aggs
        WHERE date >= '2026-06-01'
          AND date <  '2026-07-01'
          AND ifNull(otc, 0) = 0
          AND ticker NOT IN ('SPCX')
        GROUP BY ticker
    ),
    totals AS
    (
        SELECT count() AS total_listed
        FROM per_symbol
    ),
    bucketed AS
    (
        SELECT
            multiIf(sessions_traded <=  3, '01 to 03 sessions',
                    sessions_traded <=  7, '04 to 07 sessions',
                    sessions_traded <= 12, '08 to 12 sessions',
                    sessions_traded <= 17, '13 to 17 sessions',
                                           '18 or more sessions') AS sessions_bucket,
            count()                                               AS listed_symbols
        FROM per_symbol
        GROUP BY sessions_bucket
    )
SELECT
    b.sessions_bucket                                 AS sessions_bucket,
    round(100 * b.listed_symbols / t.total_listed, 1) AS listed_share_pct
FROM bucketed AS b
CROSS JOIN totals AS t
ORDER BY b.sessions_bucket