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

3,293 answered market questions

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

Full options quote history: clean NBBO bid/ask snapshots for any US option contract at the interval you choose, by SQL API, $79 a month. See the options quotes plan
SPY ETF Price in Korean Won: KRW per Share
SPY closing price in US dollars, month by monthseries · 2026-11-07 · 14×3Preview: a 14-point series, ending higher. When the US session lands on the Korean clock: June against January 2026ranking · 2026-11-07 · 16×3Preview: 16 ranked values, largest first. One share of SPY in Korean won, across input exchange ratesranking · 2026-11-07 · 7×2Preview: 7 ranked values, smallest first. What a broker's FX spread adds to the won cost of one shareranking · 2026-11-07 · 5×3Preview: 5 ranked values, smallest first. A won budget against whole shares and fractional sharesranking · 2026-11-07 · 5×4Preview: 5 ranked values, smallest first.
KRX After-Hours Trading: Korea's Sessions
AAPL quoted spread by clock time, 15 September 2026series · 2026-11-07 · 24×3Preview: a 16-point series, ending lower. Share of monthly volume by New York clock time, AAPL and KOseries · 2026-11-07 · 32×3Preview: a 16-point series, roughly flat. Share of the day's volume printed minute by minute into the US close, and the closing cross itselfseries · 2026-11-07 · 11×2Preview: a 11-point series, ending higher.
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.
SPY closing price in US dollars, month by month

SPY closing price in US dollars, month by month

most recentas of series 14×3read in context →
SPY closing price in US dollars, month by month — 14 rows by 3 columns, computed from US exchange, SIP and OPRA data.
monthspy_close_usdas_of_label
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-01755.72Oct 30, 2026
2026-11-01735.29Nov 6, 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
$