STRASMORE/EXPLORE 2,707 QUERIES

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

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-08-09, from How Options Adjust After Mergers & Spinoffs.

as 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
Rows × columns
61 × 5
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 One deliverable, two companies: GE and GE HealthCare after the spin, derived from the stored result.
ColumnTypeRangeNotes
session_date date 2023-01-04 to 2023-03-31
session_label text 61 distinct values
parent_close number 56.03 to 76.3 US dollars
spinco_close number 58.1 to 82.14 US dollars
spinco_share_pct number 24.5 to 27.5 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(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
⌘/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 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 → Time value left in KO calls as they move deeper in the money ranking 5×4 → How big each kind of cash distribution is, as a share of the stock price ranking 5×4 → See all 2,707 queries →