STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 answered market questions

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

How Options Adjust After Mergers & Spinoffs
One deliverable, two companies: GE and GE HealthCare after the spinseries · 2026-08-09 · 61×5Preview: a 16-point series, ending lower. Near-the-money implied volatility into a cash close (ATVI, 2023)series · 2026-08-09 · 83×4Preview: a 16-point series, ending lower. A target stock pinning to its cash deal price (ATVI, 2023)series · 2026-08-09 · 83×4Preview: a 16-point series, ending lower.
One deliverable, two companies: GE and GE HealthCare after the spin

One deliverable, two companies: GE and GE HealthCare after the spin

most recentas of series 61×5read in context →
One deliverable, two companies: GE and GE HealthCare after the spin — 61 rows by 5 columns, computed from US exchange, SIP and OPRA data.
session_datesession_labelparent_closespinco_closespinco_share_pct
2023-01-04January 4, 202356.0360.4926.3
2023-01-05January 5, 202356.95925.5
2023-01-06January 6, 202357.4158.9525.3
2023-01-09January 9, 20235858.124.8
2023-01-10January 10, 202360.076024.8
2023-01-11January 11, 20236264.9925.7
2023-01-12January 12, 202362.9465.6525.6
2023-01-13January 13, 202364.0165.4425.2
2023-01-17January 17, 202364.2463.3324.5
2023-01-18January 18, 202363.2662.0824.5
2023-01-19January 19, 202361.3463.9425.6
2023-01-20January 20, 20236266.7726.2
2023-01-23January 23, 202363.6669.5226.5
2023-01-24January 24, 202364.4169.626.3
2023-01-25January 25, 202364.4868.7126
2023-01-26January 26, 202364.7669.2226.1
2023-01-27January 27, 202366.4270.0825.8
2023-01-30January 30, 202364.5171.526.8
2023-01-31January 31, 202364.2369.5226.3
2023-02-01February 1, 202365.770.0126
2023-02-02February 2, 202366.9970.6525.8
2023-02-03February 3, 202365.4170.5526.2
2023-02-06February 6, 202365.7271.8626.5
2023-02-07February 7, 202365.5371.6326.5
2023-02-08February 8, 202365.4170.1726.1
2023-02-09February 9, 202364.4868.4125.9
2023-02-10February 10, 202364.8869.2426
2023-02-13February 13, 202365.9969.4325.8
2023-02-14February 14, 202366.6772.6126.4
2023-02-15February 15, 202367.6572.3226.1
2023-02-16February 16, 202367.0870.9125.9
2023-02-17February 17, 202366.2773.1726.7
2023-02-21February 21, 202365.6572.4726.7
2023-02-22February 22, 202366.3971.9426.3
2023-02-23February 23, 202366.1975.927.5
2023-02-24February 24, 202366.6875.0127.1
2023-02-27February 27, 202366.9176.0427.3
2023-02-28February 28, 202367.617627.1
2023-03-01March 1, 202367.1575.327
2023-03-02March 2, 202368.4175.0426.6
2023-03-03March 3, 202368.9476.3726.8
2023-03-06March 6, 202369.4876.6826.7
2023-03-07March 7, 202368.9576.2526.7
2023-03-08March 8, 202369.4276.6326.7
2023-03-09March 9, 202373.0776.3825.6
2023-03-10March 10, 202372.6374.9725.4
2023-03-13March 13, 202371.0176.2426.2
2023-03-14March 14, 202372.7677.1425.9
2023-03-15March 15, 202371.6476.7626.1
2023-03-16March 16, 202373.476.6225.6
2023-03-17March 17, 202372.0675.8425.8
2023-03-20March 20, 202371.7675.225.7
2023-03-21March 21, 202373.5776.5225.6
2023-03-22March 22, 202371.574.7725.7
2023-03-23March 23, 202373.175.7125.5
2023-03-24March 24, 202372.9276.4625.7
2023-03-27March 27, 202374.4776.3825.3
2023-03-28March 28, 202374.3376.925.5
2023-03-29March 29, 202375.0779.2425.8
2023-03-30March 30, 202375.0682.1426.5
2023-03-31March 31, 202376.382.0326.2
the exact SQL behind every number 
SELECT
    toString(date)                                                             AS session_date,
    concat(monthName(toDate(date)), ' ', toString(toDayOfMonth(toDate(date))),
           ', ', toString(toYear(toDate(date))))                              AS session_label,
    round(maxIf(toFloat64(close), ticker = 'GE'), 2)                           AS parent_close,
    round(maxIf(toFloat64(close), ticker = 'GEHC'), 2)                         AS spinco_close,
    round(100 * 33 * maxIf(toFloat64(close), ticker = 'GEHC')
          / (100 * maxIf(toFloat64(close), ticker = 'GE')
             + 33 * maxIf(toFloat64(close), ticker = 'GEHC')), 1)              AS spinco_share_pct
FROM global_markets.stocks_daily_aggs
WHERE ticker IN ('GE', 'GEHC')
  AND date BETWEEN '2023-01-04' AND '2023-03-31'
GROUP BY date
HAVING countIf(ticker = 'GE') > 0 AND countIf(ticker = 'GEHC') > 0
ORDER BY date
More from this analysisHow Options Adjust After Mergers & Spinoffs
Near-the-money implied volatility into a cash close (ATVI, 2023) series 83×4 → A target stock pinning to its cash deal price (ATVI, 2023) series 83×4 → One time cash distributions per calendar year, and their share of all payouts ranking 9×3 → One time distributions by size, measured against the ex date closing price ranking 6×3 → See all 2,170 queries →
$