STRASMORE/EXPLORE 3,293 QUERIES

ko_annual_history

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-24, from ko-dividend-for-ukrainian-investors.

as of ranking 10×4read in context →
ko_annual_history — 10 rows by 4 columns, computed from US exchange, SIP and OPRA data.
yearpaymentsusd_per_yeargrowth_pct
201641.46.1
201741.485.7
201841.565.4
201941.62.6
202041.642.5
202141.682.4
202241.764.8
202341.844.5
202441.945.4
202542.045.2
Rows × columns
10 × 4
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_annual_history, derived from the stored result.
ColumnTypeRangeNotes
year number 2,016 to 2,025
payments number every row is 4
usd_per_year number 1.4 to 2.04 US dollars
growth_pct number 2.4 to 6.1 percent

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
    year,
    payments,
    usd_per_year,
    round((usd_per_year / prev_year_usd - 1) * 100, 1) AS growth_pct
FROM
(
    SELECT
        year,
        payments,
        usd_per_year,
        lagInFrame(usd_per_year, 1) OVER (ORDER BY year) AS prev_year_usd
    FROM
    (
        SELECT
            toYear(ex_dividend_date)   AS year,
            count()                    AS payments,
            round(sum(usd), 2)         AS usd_per_year
        FROM
        (
            SELECT
                ex_dividend_date,
                max(toFloat64(cash_amount)) AS usd
            FROM global_markets.stocks_dividends
            WHERE ticker = 'KO'
              AND toYear(ex_dividend_date) BETWEEN toYear(today()) - 11 AND toYear(today()) - 1
            GROUP BY ex_dividend_date
        )
        GROUP BY year
    )
)
WHERE year >= toYear(today()) - 10
  AND prev_year_usd > 0
ORDER BY year
⌘/Ctrl + Enter

Work with this data in your AI assistant

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