The two Rule 144 volume tests, in millions of shares

SELECT
    v.ticker                                                       AS ticker,
    round(s.shares_out / 100 / 1e6, 2)                             AS cap_shares_m,
    round(v.weekly_volume / 1e6, 2)                                AS cap_weekly_m,
    round(greatest(s.shares_out / 100, v.weekly_volume) / 1e6, 2)  AS quarterly_cap_m,
    if(v.weekly_volume >= s.shares_out / 100,
       'four-week volume',
       'one percent of shares')                                    AS larger_test
FROM
(
    SELECT
        ticker,
        toFloat64(sum(volume)) / 4 AS weekly_volume
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('AAPL', 'MSFT', 'KO', 'ADP', 'AXP', 'BLK')
      AND date >= today() - 32
      AND date <  today() - 4
    GROUP BY ticker
) AS v
INNER JOIN
(
    SELECT
        arrayJoin(tickers)                                                     AS ticker,
        toFloat64(argMax(basic_shares_outstanding, (filing_date, period_end))) AS shares_out
    FROM global_markets.stocks_income_statements
    WHERE hasAny(tickers, ['AAPL', 'MSFT', 'KO', 'ADP', 'AXP', 'BLK'])
    GROUP BY ticker
) AS s ON s.ticker = v.ticker
WHERE s.shares_out > 0
ORDER BY cap_weekly_m DESC