Diluted shares outstanding by calendar quarter, three long-running programmes

Name: Diluted shares outstanding by calendar quarter, three long-running programmes
Creator: Strasmore
Published: 2026-08-22
License: https://www.strasmore.com/terms/

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-08-22, from How Companies Execute Buybacks: Rule 10b-18.

as of 2026-08-22 series 20×4read in context →

Diluted shares outstanding by calendar quarter, three long-running programmes — 20 rows by 4 columns, computed 2026-08-22 from US exchange, SIP and OPRA data.
quarter_date	aapl_shares_b	msft_shares_b	ko_shares_b
2021-01-01	16.93	7.6	4.33
2021-04-01	16.78	7.61	4.34
2021-07-01	16.86	7.57	4.34
2021-10-01	16.52	7.56	4.34
2022-01-01	16.4	7.53	4.36
2022-04-01	16.26	7.54	4.35
2022-07-01	16.33	7.48	4.35
2022-10-01	15.96	7.47	4.35
2023-01-01	15.85	7.46	4.34
2023-04-01	15.78	7.47	4.34
2023-07-01	15.81	7.46	4.34
2023-10-01	15.58	7.47	4.34
2024-01-01	15.46	7.47	4.32
2024-04-01	15.35	7.47	4.32
2024-07-01	15.41	7.47	4.32
2024-10-01	15.15	7.47	4.32
2025-01-01	15.06	7.46	4.31
2025-04-01	14.95	7.46	4.32
2025-07-01	15	7.47	4.31
2025-10-01	14.81	7.46	4.31

Rows × columns: 20 × 4
Period covered: 2021-01-01 to 2025-10-01
Computed: 2026-08-22
Completeness: No missing values
Source: US exchange, SIP and OPRA market data
Licence: Strasmore terms · free, no signup
Formats: JSON · CSV · the SQL below

What each column holds

Column definitions for Diluted shares outstanding by calendar quarter, three long-running programmes, derived from the stored result.
Column	Type	Range	Notes
`quarter_date`	date	2021-01-01 to 2025-10-01
`aapl_shares_b`	number	14.81 to 16.93	count
`msft_shares_b`	number	7.46 to 7.61	count
`ko_shares_b`	number	4.31 to 4.36	count

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on 2026-08-22, and the query below is what returned them.

the exact SQL behind every number

SELECT
    toString(toStartOfQuarter(period_end - 15))                                        AS quarter_date,
    round(toFloat64(maxIf(diluted_shares_outstanding, has(tickers, 'AAPL'))) / 1e9, 2) AS aapl_shares_b,
    round(toFloat64(maxIf(diluted_shares_outstanding, has(tickers, 'MSFT'))) / 1e9, 2) AS msft_shares_b,
    round(toFloat64(maxIf(diluted_shares_outstanding, has(tickers, 'KO')))   / 1e9, 2) AS ko_shares_b
FROM global_markets.stocks_income_statements
WHERE timeframe = 'quarterly'
  AND hasAny(tickers, ['AAPL', 'MSFT', 'KO'])
  AND period_end >= '2021-01-01'
  AND diluted_shares_outstanding > 0
GROUP BY quarter_date
HAVING aapl_shares_b > 0 AND msft_shares_b > 0 AND ko_shares_b > 0
ORDER BY quarter_date

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisHow Companies Execute Buybacks: Rule 10b-18

Share of continuous-session volume, by half hour of the trading day series 13×3 → Three-year change in diluted share count, ten household names ranking 10×4 → A day's repurchase ceiling under the 25% volume condition ranking 6×3 → Near-the-money implied volatility into a cash close (ATVI, 2023) series 83×4 → A target stock pinning to its cash deal price (ATVI, 2023) series 83×4 → ASST: daily closes around its 1-for-20 reverse split (execution date 2026-02-06) series 69×3 → See all 2,170 queries →