rhythm

Name: rhythm
Creator: Strasmore
Published: 2026-09-26
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-09-26, from what-is-a-dividend.

as of 2026-09-26 table 3×6read in context →

rhythm — 3 rows by 6 columns, computed 2026-09-26 from US exchange, SIP and OPRA data.
ticker	payments_2y	avg_gap_days	declare_to_ex_days	ex_to_record_days	ex_to_pay_days
AAPL	8	91.4	10.6	0.4	3.4
KO	8	93.6	43	0	16.8
MSFT	8	91	71.2	0	21.9

Rows × columns: 3 × 6
Computed: 2026-09-26
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 rhythm, derived from the stored result.
Column	Type	Range
`ticker`	text	3 distinct values (AAPL, KO, MSFT)
`payments_2y`	number	every row is 8
`avg_gap_days`	number	91 to 93.6
`declare_to_ex_days`	number	10.6 to 71.2
`ex_to_record_days`	number	0 to 0.4
`ex_to_pay_days`	number	3.4 to 21.9

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-09-26, 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
    ticker,
    count()                                                                                  AS payments_2y,
    round(dateDiff('day', min(ex_dividend_date), max(ex_dividend_date)) / (count() - 1), 1) AS avg_gap_days,
    round(avg(dateDiff('day', declared_dt, ex_dividend_date)), 1)                            AS declare_to_ex_days,
    round(avg(dateDiff('day', ex_dividend_date, record_dt)), 1)                              AS ex_to_record_days,
    round(avg(dateDiff('day', ex_dividend_date, pay_dt)), 1)                                 AS ex_to_pay_days
FROM
(
    SELECT
        ticker,
        ex_dividend_date,
        argMax(declaration_date, _ingest_time) AS declared_dt,
        argMax(record_date, _ingest_time)      AS record_dt,
        argMax(pay_date, _ingest_time)         AS pay_dt
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('KO', 'AAPL', 'MSFT')
      AND cash_amount > 0
      AND ex_dividend_date >  today() - 730
      AND ex_dividend_date <= today()
      AND declaration_date >= toDate('2000-01-01')
      AND record_date      >= toDate('2000-01-01')
      AND pay_date         >= toDate('2000-01-01')
    GROUP BY ticker, ex_dividend_date
)
GROUP BY ticker
HAVING count() > 1
ORDER BY ticker

SQL to run

SELECT
    ticker,
    count()                                                                                  AS payments_2y,
    round(dateDiff('day', min(ex_dividend_date), max(ex_dividend_date)) / (count() - 1), 1) AS avg_gap_days,
    round(avg(dateDiff('day', declared_dt, ex_dividend_date)), 1)                            AS declare_to_ex_days,
    round(avg(dateDiff('day', ex_dividend_date, record_dt)), 1)                              AS ex_to_record_days,
    round(avg(dateDiff('day', ex_dividend_date, pay_dt)), 1)                                 AS ex_to_pay_days
FROM
(
    SELECT
        ticker,
        ex_dividend_date,
        argMax(declaration_date, _ingest_time) AS declared_dt,
        argMax(record_date, _ingest_time)      AS record_dt,
        argMax(pay_date, _ingest_time)         AS pay_dt
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('KO', 'AAPL', 'MSFT')
      AND cash_amount > 0
      AND ex_dividend_date >  today() - 730
      AND ex_dividend_date <= today()
      AND declaration_date >= toDate('2000-01-01')
      AND record_date      >= toDate('2000-01-01')
      AND pay_date         >= toDate('2000-01-01')
    GROUP BY ticker, ex_dividend_date
)
GROUP BY ticker
HAVING count() > 1
ORDER BY ticker

⌘/Ctrl + Enter

Olah data ini di asisten AI Anda

Terbuka siap dikueri, dengan data halaman ini. Gratis, tanpa akun.

Claude ChatGPT Gemini Muse Agen Anda sendiri