STRASMORE/EXPLORE 2,648 QUERIES

declarations

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 acn-dividend-history.

as of table 14×6read in context →
declarations — 14 rows by 6 columns, computed from US exchange, SIP and OPRA data.
ex_date_isoex_labeldeclared_onrecord_onpaid_onamount_usd
2026-07-09Jul 9, 2026Jun 17, 2026Jul 9, 2026Aug 14, 20261.63
2026-04-09Apr 9, 2026Mar 19, 2026Apr 9, 2026May 15, 20261.63
2026-01-13Jan 13, 2026Dec 18, 2025Jan 13, 2026Feb 13, 20261.63
2025-10-10Oct 10, 2025Sep 25, 2025Oct 10, 2025Nov 14, 20251.63
2025-07-10Jul 10, 2025Jun 13, 2025Jul 10, 2025Aug 15, 20251.48
2025-04-10Apr 10, 2025Mar 20, 2025Apr 10, 2025May 15, 20251.48
2025-01-16Jan 16, 2025Nov 19, 2024Jan 16, 2025Feb 14, 20251.48
2024-10-10Oct 10, 2024Sep 26, 2024Oct 10, 2024Nov 15, 20241.48
2024-07-11Jul 11, 2024Jun 20, 2024Jul 11, 2024Aug 15, 20241.29
2024-04-10Apr 10, 2024Mar 21, 2024Apr 11, 2024May 15, 20241.29
2024-01-17Jan 17, 2024Nov 15, 2023Jan 18, 2024Feb 15, 20241.29
2023-10-11Oct 11, 2023Sep 28, 2023Oct 12, 2023Nov 15, 20231.29
2023-07-12Jul 12, 2023May 15, 2023Jul 13, 2023Aug 15, 20231.12
2023-04-12Apr 12, 2023Mar 23, 2023Apr 13, 2023May 15, 20231.12
Rows × columns
14 × 6
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 declarations, derived from the stored result.
ColumnTypeRangeNotes
ex_date_iso date 2023-04-12 to 2026-07-09
ex_label text 14 distinct values (Apr 10, 2024, Apr 10, 2025, Apr 12, 2023…)
declared_on text 14 distinct values (Dec 18, 2025, Jun 13, 2025, Jun 17, 2026…)
record_on text 14 distinct values (Apr 10, 2025, Apr 11, 2024, Apr 13, 2023…)
paid_on text 14 distinct values (Aug 14, 2026, Aug 15, 2023, Aug 15, 2024…)
amount_usd number 1.12 to 1.63 US dollars

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(ex_date)                     AS ex_date_iso,
    formatDateTime(ex_date, '%b %e, %Y')  AS ex_label,
    if(declared > toDate('2000-01-01'),
       formatDateTime(declared, '%b %e, %Y'), 'not reported')  AS declared_on,
    if(recorded > toDate('2000-01-01'),
       formatDateTime(recorded, '%b %e, %Y'), 'not reported')   AS record_on,
    if(paid > toDate('2000-01-01'),
       formatDateTime(paid, '%b %e, %Y'), 'not reported')       AS paid_on,
    round(amount, 2)                      AS amount_usd
FROM
(
    SELECT
        ex_dividend_date                                     AS ex_date,
        ifNull(any(declaration_date), toDate('1970-01-01'))   AS declared,
        ifNull(any(record_date), toDate('1970-01-01'))        AS recorded,
        ifNull(any(pay_date), toDate('1970-01-01'))           AS paid,
        toFloat64(any(cash_amount))                          AS amount
    FROM global_markets.stocks_dividends
    WHERE ticker = 'ACN'
      AND cash_amount > 0
      AND ex_dividend_date <= today()
    GROUP BY ex_dividend_date
    ORDER BY ex_dividend_date DESC
    LIMIT 14
)
ORDER BY ex_date DESC
⌘/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
More from this analysisacn-dividend-history
rate_changes table 12×5 → annual_dps ranking 17×3 → The 2s10s spread, every print of the half table 124×2 → The 2s10s spread, every print of the half table 124×2 → Every half-year since 1976: the 2y and 10y change, the twist between them, and the half's lowest 2s10s print table 100×7 → SPY at one-minute resolution, 2:00–3:30 pm ET on May 6, 2010 table 90×4 → See all 2,648 queries →