STRASMORE/EXPLORE 2,830 QUERIES

spy_payouts

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 what-is-spy-etf-for-russian-investors.

as of series 13×5read in context →
spy_payouts — 13 rows by 5 columns, computed from US exchange, SIP and OPRA data.
ex_dateex_labelpay_labelgross_usdnet_usd
2023-09-1515.09.202331.10.20231.581.11
2023-12-1515.12.202331.01.20241.911.33
2024-03-1515.03.202430.04.20241.591.12
2024-06-2121.06.202431.07.20241.761.23
2024-09-2020.09.202431.10.20241.751.22
2024-12-2020.12.202431.01.20251.971.38
2025-03-2121.03.202530.04.20251.71.19
2025-06-2020.06.202531.07.20251.761.23
2025-09-1919.09.202531.10.20251.831.28
2025-12-1919.12.202530.01.20261.991.4
2026-03-2020.03.202630.04.20261.81.26
2026-06-1818.06.202631.07.20261.91.33
2026-09-1818.09.202630.10.20261.891.32
Rows × columns
13 × 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 spy_payouts, derived from the stored result.
ColumnTypeRangeNotes
ex_date date 2023-09-15 to 2026-09-18
ex_label text 13 distinct values (15.03.2024, 15.09.2023, 15.12.2023…)
pay_label text 13 distinct values (30.01.2026, 30.04.2024, 30.04.2025…)
gross_usd number 1.58 to 1.99 US dollars
net_usd number 1.11 to 1.4 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(toDate(ex_dividend_date))                   AS ex_date,
    formatDateTime(toDate(ex_dividend_date), '%d.%m.%Y') AS ex_label,
    formatDateTime(max(toDate(pay_date)), '%d.%m.%Y')    AS pay_label,
    round(max(toFloat64(cash_amount)), 2)                AS gross_usd,
    round(0.7 * max(toFloat64(cash_amount)), 2)          AS net_usd
FROM global_markets.stocks_dividends
WHERE ticker = 'SPY'
  AND ex_dividend_date >= today() - 1130
  AND pay_date > ex_dividend_date
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