STRASMORE/EXPLORE 3,293 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,293 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

How to Read a 10-Q: Quarterly Filing Guide
Apple weighted average basic and diluted share count, in millionsseries · 2026-10-16 · 11×4Preview: a 11-point series, ending lower. Apple quarterly revenue and net income, by period endseries · 2026-10-16 · 11×4Preview: a 11-point series, ending higher. Apple gross and operating margin by quarterseries · 2026-10-16 · 11×3Preview: a 11-point series, ending higher. Quarterly versus annual reports filed since January 2023ranking · 2026-10-16 · 6×3Preview: 6 ranked values, largest first.
Apple weighted average basic and diluted share count, in millions

Apple weighted average basic and diluted share count, in millions

most recentas of series 11×4read in context →
Apple weighted average basic and diluted share count, in millions — 11 rows by 4 columns, computed from US exchange, SIP and OPRA data.
quarter_end_datebasic_shares_millionsdiluted_shares_millionsquarter_label
2023-07-011569815775Jul 2023
2023-09-301574415813Sep 2023
2023-12-301551015577Dec 2023
2024-03-301540615465Mar 2024
2024-06-291528815348Jun 2024
2024-09-281534415408Sep 2024
2024-12-281508215151Dec 2024
2025-03-291499415056Mar 2025
2025-06-281490314948Jun 2025
2025-09-271494815005Sep 2025
2025-12-271474814810Dec 2025
the exact SQL behind every number
SELECT
    toString(period_end)                AS quarter_end_date,
    round(toFloat64(argMax(basic_shares_outstanding, (filing_date, period_end))) / 1e6, 0)   AS basic_shares_millions,
    round(toFloat64(argMax(diluted_shares_outstanding, (filing_date, period_end))) / 1e6, 0) AS diluted_shares_millions,
    formatDateTime(period_end, '%b %Y')  AS quarter_label
FROM global_markets.stocks_income_statements
WHERE has(tickers, 'AAPL')
  AND timeframe = 'quarterly'
  AND period_end >= '2023-07-01'
GROUP BY period_end
ORDER BY period_end
$