spy_2025
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-10-16, from us-dividend-tax-for-korean-investors.
| ex_date | ex_label | gross_usd | net_usd | pay_label |
|---|---|---|---|---|
| 2025-03-21 | 2025년 3월 | 1.6955 | 1.4412 | 2025년 4월 30일 |
| 2025-06-20 | 2025년 6월 | 1.7611 | 1.4969 | 2025년 7월 31일 |
| 2025-09-19 | 2025년 9월 | 1.8311 | 1.5564 | 2025년 10월 31일 |
| 2025-12-19 | 2025년 12월 | 1.9934 | 1.6944 | 2026년 1월 30일 |
- Rows × columns
- 4 × 5
- Period covered
- to
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
ex_date |
date | 2025-03-21 to 2025-12-19 | |
ex_label |
text | 4 distinct values (2025년 12월, 2025년 3월, 2025년 6월…) | |
gross_usd |
number | 1.6955 to 1.9934 | US dollars |
net_usd |
number | 1.4412 to 1.6944 | US dollars |
pay_label |
text | 4 distinct values |
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,
concat(toString(toYear(ex_dividend_date)), '년 ',
toString(toMonth(ex_dividend_date)), '월') AS ex_label,
round(toFloat64(max(cash_amount)), 4) AS gross_usd,
round(toFloat64(max(cash_amount)) * 0.85, 4) AS net_usd,
concat(toString(toYear(max(pay_date))), '년 ',
toString(toMonth(max(pay_date))), '월 ',
toString(toDayOfMonth(max(pay_date))), '일') AS pay_label
FROM global_markets.stocks_dividends
WHERE ticker = 'SPY'
AND ex_dividend_date >= '2025-01-01'
AND ex_dividend_date < '2026-01-01'
GROUP BY ex_dividend_date
ORDER BY ex_dividend_date
AI 어시스턴트에서 이 데이터로 작업하기
이 페이지의 데이터로 바로 쿼리할 수 있게 열립니다. 무료, 계정 불필요.