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

Direct Stock Purchase Plans: How They Fill
The monthly price band a pooled plan purchase lands inside (KO)series · 2026-10-16 · 13×6Preview: a 13-point series, ending lower. One ordinary session in KO, in 30 minute ET bucketsseries · 2026-10-16 · 32×3Preview: a 16-point series, ending lower. KO ex-dividend dates and cash per share, trailing three yearsseries · 2026-10-16 · 12×3Preview: a 12-point series, ending higher. Where a September 2026 batch could have landed, eight widely held namesranking · 2026-10-16 · 8×3Preview: 8 ranked values, largest first.
The monthly price band a pooled plan purchase lands inside (KO)

The monthly price band a pooled plan purchase lands inside (KO)

most recentas of series 13×6read in context →
The monthly price band a pooled plan purchase lands inside (KO) — 13 rows by 6 columns, computed from US exchange, SIP and OPRA data.
monthmonth_labelavg_closelow_pricehigh_priceband_pct
2025-09-01Sep 202567.0465.3569.466.13
2025-10-01Oct 202568.0865.8471.618.48
2025-11-01Nov 20257167.6673.237.85
2025-12-01Dec 202570.368.7972.95.85
2026-01-01Jan 202671.1267.2774.910.72
2026-02-01Feb 202678.9474.4829.63
2026-03-01Mar 202676.7974.0781.49.55
2026-04-01Apr 202676.574.5580.327.54
2026-05-01May 202680.0277.7382.666.17
2026-06-01Jun 202680.4676.8184.048.99
2026-07-01Jul 202683.8880.8390.9212.03
2026-08-01Aug 202688.4985.1692.498.28
2026-09-01Sep 202687.9686.0790.364.88
the exact SQL behind every number 
SELECT
    toString(toStartOfMonth(date))                AS month,
    formatDateTime(toStartOfMonth(date), '%b %Y') AS month_label,
    round(avg(toFloat64(close)), 2)               AS avg_close,
    round(min(toFloat64(low)), 2)                 AS low_price,
    round(max(toFloat64(high)), 2)                AS high_price,
    round(100 * (max(toFloat64(high)) - min(toFloat64(low))) / avg(toFloat64(close)), 2) AS band_pct
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'KO'
  AND date >= toStartOfMonth(today() - 400)
  AND date <  toStartOfMonth(today())
GROUP BY toStartOfMonth(date)
ORDER BY toStartOfMonth(date)
More from this analysisDirect Stock Purchase Plans: How They Fill
One ordinary session in KO, in 30 minute ET buckets series 32×3 → KO ex-dividend dates and cash per share, trailing three years series 12×3 → Where a September 2026 batch could have landed, eight widely held names ranking 8×3 → Two index ETFs through one session, September 15, 2026 (percent change from the day's first print) series 32×3 → See all 3,293 queries →
$