STRASMORE/EXPLORE 3,293 QUERIES

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

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 Direct Stock Purchase Plans: How They Fill.

as 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
Rows × columns
13 × 6
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 The monthly price band a pooled plan purchase lands inside (KO), derived from the stored result.
ColumnTypeRangeNotes
month date 2025-09-01 to 2026-09-01
month_label text 13 distinct values (Apr 2026, Aug 2026, Dec 2025…)
avg_close number 67.04 to 88.49 US dollars
low_price number 65.35 to 86.07 US dollars
high_price number 69.46 to 92.49 US dollars
band_pct number 4.88 to 12.03 percent

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(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)
⌘/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
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 → How wide each session ran from high to low, as a percent of the close series 31×3 → KO: ex-dividend close against the pay date close, 2021 to 2026 series 22×5 → See all 3,293 queries →