Exchange-listed symbols with a recent SEC periodic report, June 2026

WITH
    traded AS
    (
        SELECT DISTINCT ticker
        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')
    ),
    filers AS
    (
        SELECT DISTINCT ticker
        FROM global_markets.stocks_sec_edgar_index
        WHERE filing_date >= '2025-06-01'
          AND filing_date <  '2026-07-01'
          AND form_type IN ('10-K', '10-Q', '20-F', '40-F')
          AND ticker != ''
    )
SELECT
    count()                                                       AS symbols_traded,
    countIf(ifNull(f.ticker, '') != '')                           AS symbols_with_filing,
    round(100 * countIf(ifNull(f.ticker, '') != '') / count(), 1) AS pct_with_recent_filing
FROM traded AS t
LEFT JOIN filers AS f ON f.ticker = t.ticker