STRASMORE/EXPLORE 3,293 QUERIES
Full options quote history: clean NBBO bid/ask snapshots for any US option contract at the interval you choose, by SQL API, $79 a month. See the options quotes plan

ko_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-11-01, from what-is-income.

as of series 16×4read in context →
ko_trace — 16 rows by 4 columns, computed from US exchange, SIP and OPRA data.
ex_datecash_per_shareusd_on_500_stakeex_date_pretty
2022-11-300.443.52Nov 30, 2022
2023-03-160.463.68Mar 16, 2023
2023-06-150.463.68Jun 15, 2023
2023-09-140.463.68Sep 14, 2023
2023-11-300.463.68Nov 30, 2023
2024-03-140.4853.88Mar 14, 2024
2024-06-140.4853.88Jun 14, 2024
2024-09-130.4853.88Sep 13, 2024
2024-11-290.4853.88Nov 29, 2024
2025-03-140.514.08Mar 14, 2025
2025-06-130.514.08Jun 13, 2025
2025-09-150.514.08Sep 15, 2025
2025-12-010.514.08Dec 1, 2025
2026-03-130.534.24Mar 13, 2026
2026-06-150.534.24Jun 15, 2026
2026-09-150.534.24Sep 15, 2026
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 ko_trace, derived from the stored result.
ColumnTypeRangeNotes
ex_date date 2022-11-30 to 2026-09-15
cash_per_share number 0.44 to 0.53
usd_on_500_stake number 3.52 to 4.24 US dollars
ex_date_pretty text 16 distinct values (Dec 1, 2025, Jun 13, 2025, Jun 14, 2024…)

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
    toString(d.ex_dividend_date)                        AS ex_date,
    round(d.cash_per_share, 4)                          AS cash_per_share,
    round(d.cash_per_share * p.shares, 2)               AS usd_on_500_stake,
    formatDateTime(d.ex_dividend_date, '%b %e, %Y')     AS ex_date_pretty
FROM
(
    SELECT
        ex_dividend_date,
        toFloat64(max(cash_amount)) AS cash_per_share
    FROM global_markets.stocks_dividends
    WHERE ticker = 'KO'
      AND ex_dividend_date >= today() - 1500
      AND ex_dividend_date <  today()
    GROUP BY ex_dividend_date
) AS d
CROSS JOIN
(
    SELECT floor(500 / argMin(toFloat64(close), date)) AS shares
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'KO'
      AND date >= today() - 1500
      AND date <  today() - 1460
) AS p
ORDER BY d.ex_dividend_date
⌘/Ctrl + Enter

Use dis data for your AI assistant

E go open ready to query, with dis page data. Free, no account.