open_vs_reference
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-09-25, from ex-dividend-date-premarket-and-open-orders.
| ex_date | vs_prior_close_pct | vs_adjusted_close_pct |
|---|---|---|
| 2023-06-15 | -0.41 | 0.35 |
| 2023-09-14 | -0.34 | 0.45 |
| 2023-11-30 | -0.46 | 0.33 |
| 2024-03-14 | -0.88 | -0.09 |
| 2024-06-14 | -0.97 | -0.2 |
| 2024-09-13 | -0.55 | 0.13 |
| 2024-11-29 | -0.64 | 0.12 |
| 2025-03-14 | -1.59 | -0.87 |
| 2025-06-13 | -0.65 | 0.06 |
| 2025-09-15 | -0.49 | 0.27 |
| 2025-12-01 | -0.71 | -0.01 |
| 2026-03-13 | -0.18 | 0.51 |
| 2026-06-15 | -1.86 | -1.23 |
| 2026-09-15 | -0.92 | -0.33 |
- Rows × columns
- 14 × 3
- 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 | 2023-06-15 to 2026-09-15 | |
vs_prior_close_pct |
number | -1.86 to -0.18 | percent |
vs_adjusted_close_pct |
number | -1.23 to 0.51 | 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.
WITH
px AS
(
SELECT
date,
max(open) AS open_px,
max(close) AS close_px
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'KO'
AND date >= today() - 1300
GROUP BY date
),
daily AS
(
SELECT
date,
open_px,
any(close_px) OVER (ORDER BY date ASC ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) AS prior_close
FROM px
),
divs AS
(
SELECT
ex_dividend_date AS ex_date,
max(cash_amount) AS dividend_usd
FROM global_markets.stocks_dividends
WHERE ticker = 'KO'
AND cash_amount > 0
AND ex_dividend_date >= today() - 1200
AND ex_dividend_date < today()
GROUP BY ex_dividend_date
)
SELECT
toString(v.ex_date) AS ex_date,
round(100 * (toFloat64(d.open_px) - toFloat64(d.prior_close)) / toFloat64(d.prior_close), 2) AS vs_prior_close_pct,
round(100 * (toFloat64(d.open_px) - (toFloat64(d.prior_close) - toFloat64(v.dividend_usd)))
/ (toFloat64(d.prior_close) - toFloat64(v.dividend_usd)), 2) AS vs_adjusted_close_pct
FROM divs AS v
INNER JOIN daily AS d ON d.date = v.ex_date
ORDER BY ex_date ASC
Work with this data in your AI assistant
Opens ready to query, with this page's data. Free, no account.