STRASMORE/EXPLORE 3,293 QUERIES

o_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 monthly-dividend-stocks-for-indian-investors.

as of series 12×4read in context →
o_trace — 12 rows by 4 columns, computed from US exchange, SIP and OPRA data.
datemonth_labeldividend_usdpaid_on
2025-11-28Nov 20250.26952025-12-15
2025-12-31Dec 20250.272026-01-15
2026-01-30Jan 20260.272026-02-13
2026-02-27Feb 20260.272026-03-13
2026-03-31Mar 20260.27052026-04-15
2026-04-30Apr 20260.27052026-05-15
2026-05-29May 20260.27052026-06-15
2026-06-30Jun 20260.2712026-07-15
2026-07-31Jul 20260.2712026-08-14
2026-08-31Aug 20260.2712026-09-15
2026-09-30Sep 20260.27152026-10-15
2026-10-30Oct 20260.27152026-11-13
Rows × columns
12 × 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 o_trace, derived from the stored result.
ColumnTypeRangeNotes
date date 2025-11-28 to 2026-10-30
month_label text 12 distinct values (Apr 2026, Aug 2026, Dec 2025…)
dividend_usd number 0.2695 to 0.2715 US dollars
paid_on date 2025-12-15 to 2026-11-13

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_dividend_date)                  AS date,
    formatDateTime(ex_dividend_date, '%b %Y')   AS month_label,
    round(toFloat64(any(cash_amount)), 4)       AS dividend_usd,
    toString(any(pay_date))                     AS paid_on
FROM global_markets.stocks_dividends
WHERE ticker = 'O'
  AND ex_dividend_date >= today() - 365
  AND ex_dividend_date <  today()
GROUP BY ex_dividend_date
ORDER BY ex_dividend_date
⌘/Ctrl + Enter

इस डेटा के साथ अपने AI असिस्टेंट में काम करें

इस पेज के डेटा के साथ, क्वेरी के लिए तैयार खुलता है। मुफ़्त, बिना अकाउंट।