STRASMORE/EXPLORE 3,256 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,256 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

SPY ETF Price in Korean Won: KRW per Share
SPY closing price in US dollars, month by monthseries · 2026-10-04 · 15×3Preview: a 15-point series, ending higher. When the US session lands on the Korean clock: June against January 2026ranking · 2026-10-04 · 16×3Preview: 16 ranked values, largest first. One share of SPY in Korean won, across input exchange ratesranking · 2026-10-04 · 7×2Preview: 7 ranked values, smallest first. What a broker's FX spread adds to the won cost of one shareranking · 2026-10-04 · 5×3Preview: 5 ranked values, smallest first. A won budget against whole shares and fractional sharesranking · 2026-10-04 · 5×4Preview: 5 ranked values, smallest first.
SPY Dividends for Korean Investors
SPY trailing four-quarter distribution yield, measured at each ex-dateseries · 2026-09-30 · 32×3Preview: a 16-point series, ending lower. One US session in 30-minute slices, with the New York and Seoul clocks side by sideseries · 2026-09-30 · 18×3Preview: a 16-point series, ending higher. Days from ex-date to payment, every SPY distribution since 2019series · 2026-09-30 · 31×4Preview: a 16-point series, roughly flat. Every SPY distribution since 2023: ex-date, pay date, cash per shareseries · 2026-09-30 · 15×5Preview: a 15-point series, ending higher.
Covered Call ETFs: the Real Tradeoff
Three years of total return, split into price change and distributions: July 2023 to June 2026table · 2026-08-01 · 8×7 Total return by calendar year: a Nasdaq index fund vs a Nasdaq covered call fundranking · 2026-08-01 · 4×3Preview: 4 ranked values, smallest first. Price path indexed to 100: two index funds and their covered call counterparts, month endsseries · 2026-08-01 · 36×5Preview: a 16-point series, roughly flat.
SPY closing price in US dollars, month by month

SPY closing price in US dollars, month by month

most recentas of series 15×3read in context →
SPY closing price in US dollars, month by month — 15 rows by 3 columns, computed from US exchange, SIP and OPRA data.
monthspy_close_usdas_of_label
2025-08-01645.05Aug 29, 2025
2025-09-01666.18Sep 30, 2025
2025-10-01682.06Oct 31, 2025
2025-11-01683.39Nov 28, 2025
2025-12-01681.92Dec 31, 2025
2026-01-01691.97Jan 30, 2026
2026-02-01685.99Feb 27, 2026
2026-03-01650.34Mar 31, 2026
2026-04-01718.66Apr 30, 2026
2026-05-01756.48May 29, 2026
2026-06-01746.77Jun 30, 2026
2026-07-01747.03Jul 31, 2026
2026-08-01767.05Aug 31, 2026
2026-09-01762.63Sep 30, 2026
2026-10-01769.64Oct 2, 2026
the exact SQL behind every number
SELECT
    toString(toStartOfMonth(date))           AS month,
    round(toFloat64(argMax(close, date)), 2) AS spy_close_usd,
    formatDateTime(max(date), '%b %e, %Y')   AS as_of_label
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'SPY'
  AND date >= toStartOfMonth(today() - 400)
GROUP BY month
ORDER BY month
$