STRASMORE/EXPLORE 2,830 QUERIES

distribution_cycle

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-30, from spy-dividend-for-korean-investors.

as of series 15×5read in context →
distribution_cycle — 15 rows by 5 columns, computed from US exchange, SIP and OPRA data.
ex_dateex_date_etex_weekdaypay_date_etcash_per_share
2023-03-17Mar 17, 2023FriApr 28, 20231.5062
2023-06-16Jun 16, 2023FriJul 31, 20231.6384
2023-09-15Sep 15, 2023FriOct 31, 20231.5832
2023-12-15Dec 15, 2023FriJan 31, 20241.9061
2024-03-15Mar 15, 2024FriApr 30, 20241.5949
2024-06-21Jun 21, 2024FriJul 31, 20241.759
2024-09-20Sep 20, 2024FriOct 31, 20241.7455
2024-12-20Dec 20, 2024FriJan 31, 20251.9655
2025-03-21Mar 21, 2025FriApr 30, 20251.6955
2025-06-20Jun 20, 2025FriJul 31, 20251.7611
2025-09-19Sep 19, 2025FriOct 31, 20251.8311
2025-12-19Dec 19, 2025FriJan 30, 20261.9934
2026-03-20Mar 20, 2026FriApr 30, 20261.797
2026-06-18Jun 18, 2026ThuJul 31, 20261.9035
2026-09-18Sep 18, 2026FriOct 30, 20261.8888
Rows × columns
15 × 5
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 distribution_cycle, derived from the stored result.
ColumnTypeRangeNotes
ex_date date 2023-03-17 to 2026-09-18
ex_date_et text 15 distinct values (Dec 15, 2023, Dec 19, 2025, Dec 20, 2024…)
ex_weekday text 2 distinct values (Fri, Thu)
pay_date_et text 15 distinct values (Apr 28, 2023, Apr 30, 2024, Apr 30, 2025…)
cash_per_share number 1.5062 to 1.9934

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 ex_date,
    formatDateTime(ex_dividend_date, '%b %e, %Y') AS ex_date_et,
    formatDateTime(ex_dividend_date, '%a')        AS ex_weekday,
    formatDateTime(max(pay_date), '%b %e, %Y')    AS pay_date_et,
    round(toFloat64(max(cash_amount)), 4)         AS cash_per_share
FROM global_markets.stocks_dividends
WHERE ticker = 'SPY'
  AND ex_dividend_date >= '2023-01-01'
  AND ex_dividend_date <= today()
GROUP BY ex_dividend_date
ORDER BY ex_dividend_date
⌘/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 analysisspy-dividend-for-korean-investors
ttm_yield series 32×3 → payment_lag series 31×4 → session_clock series 18×3 → The 2s10s spread by month, full history series 604×5 → One SPY $600 LEAPS call's price over two years (expired Jan 16 2026) series 470×2 → The 5s30s spread month by month, with both legs series 241×4 → See all 2,830 queries →