STRASMORE/EXPLORE 3,256 QUERIES

aapl_trace

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-10-09, from us-dividend-tax-for-russian-investors.

as of series 16×4read in context →
aapl_trace — 16 rows by 4 columns, computed from US exchange, SIP and OPRA data.
ex_dividend_dateex_labelgross_per_sharenet_per_share
2022-11-0404.11.20220.230.161
2023-02-1010.02.20230.230.161
2023-05-1212.05.20230.240.168
2023-08-1111.08.20230.240.168
2023-11-1010.11.20230.240.168
2024-02-0909.02.20240.240.168
2024-05-1010.05.20240.250.175
2024-08-1212.08.20240.250.175
2024-11-0808.11.20240.250.175
2025-02-1010.02.20250.250.175
2025-05-1212.05.20250.260.182
2025-08-1111.08.20250.260.182
2025-11-1010.11.20250.260.182
2026-02-0909.02.20260.260.182
2026-05-1111.05.20260.270.189
2026-08-1010.08.20260.270.189
Rows × columns
16 × 4
Period covered
to
Computed
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 aapl_trace, derived from the stored result.
ColumnTypeRangeNotes
ex_dividend_date date 2022-11-04 to 2026-08-10
ex_label text 16 distinct values (04.11.2022, 08.11.2024, 09.02.2024…)
gross_per_share number 0.23 to 0.27
net_per_share number 0.161 to 0.189

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 , and the query below is what returned them.

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

SELECT
    ex_dividend_date,
    formatDateTime(ex_dividend_date, '%d.%m.%Y') AS ex_label,
    round(toFloat64(amt), 4)                     AS gross_per_share,
    round(toFloat64(amt) * 0.70, 4)              AS net_per_share
FROM
(
    SELECT
        ex_dividend_date,
        max(cash_amount) AS amt
    FROM global_markets.stocks_dividends
    WHERE ticker = 'AAPL'
      AND currency = 'USD'
      AND cash_amount > 0
      AND ex_dividend_date >= today() - 1460
      AND ex_dividend_date <  today()
    GROUP BY ex_dividend_date
)
ORDER BY ex_dividend_date
⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

Claude ChatGPT Gemini Muse Your own agent