STRASMORE/EXPLORE 2,170 QUERIES

A target stock pinning to its cash deal price (ATVI, 2023)

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 83×4read in context →
A target stock pinning to its cash deal price (ATVI, 2023) — 83 rows by 4 columns, computed from US exchange, SIP and OPRA data.
session_datesession_labelclose_pxday_range_pct
2023-06-15June 15, 202381.451.23
2023-06-16June 16, 202381.971.56
2023-06-20June 20, 202381.890.54
2023-06-21June 21, 202380.941.25
2023-06-22June 22, 202382.32.45
2023-06-23June 23, 202381.90.95
2023-06-26June 26, 202383.41.91
2023-06-27June 27, 202384.131.66
2023-06-28June 28, 202383.61.38
2023-06-29June 29, 202383.083.15
2023-06-30June 30, 202384.31.45
2023-07-03July 3, 202383.341.22
2023-07-05July 5, 202382.871.59
2023-07-06July 6, 202382.71.12
2023-07-07July 7, 202382.431.32
2023-07-10July 10, 202382.70.74
2023-07-11July 11, 202390.9911.39
2023-07-12July 12, 2023901.84
2023-07-13July 13, 202389.541.41
2023-07-14July 14, 202390.071.95
2023-07-17July 17, 202393.211.66
2023-07-18July 18, 202392.740.86
2023-07-19July 19, 202392.21.05
2023-07-20July 20, 202392.290.51
2023-07-21July 21, 202391.910.55
2023-07-24July 24, 202392.550.81
2023-07-25July 25, 202392.730.43
2023-07-26July 26, 202392.670.48
2023-07-27July 27, 202392.140.71
2023-07-28July 28, 202392.530.38
2023-07-31July 31, 202392.760.38
2023-08-01August 1, 202391.890.47
2023-08-02August 2, 202391.630.42
2023-08-03August 3, 202391.680.55
2023-08-04August 4, 202391.580.31
2023-08-07August 7, 202391.570.36
2023-08-08August 8, 202391.590.29
2023-08-09August 9, 202391.440.63
2023-08-10August 10, 202391.420.44
2023-08-11August 11, 202391.210.42
2023-08-14August 14, 202390.790.49
2023-08-15August 15, 202390.910.36
2023-08-16August 16, 202390.850.44
2023-08-17August 17, 202390.430.69
2023-08-18August 18, 202390.470.78
2023-08-21August 21, 202390.720.35
2023-08-22August 22, 202391.660.69
2023-08-23August 23, 202391.740.46
2023-08-24August 24, 202391.410.61
2023-08-25August 25, 202391.660.49
2023-08-28August 28, 202391.770.29
2023-08-29August 29, 202391.980.38
2023-08-30August 30, 202391.980.32
2023-08-31August 31, 202391.990.21
2023-09-01September 1, 202392.040.27
2023-09-05September 5, 202392.030.31
2023-09-06September 6, 202392.070.13
2023-09-07September 7, 202392.010.17
2023-09-08September 8, 202392.120.25
2023-09-11September 11, 202392.180.36
2023-09-12September 12, 202392.130.33
2023-09-13September 13, 202392.270.35
2023-09-14September 14, 202392.220.34
2023-09-15September 15, 202391.820.65
2023-09-18September 18, 202391.910.25
2023-09-19September 19, 202392.070.34
2023-09-20September 20, 202392.560.33
2023-09-21September 21, 202392.350.31
2023-09-22September 22, 202393.920.27
2023-09-25September 25, 202394.050.17
2023-09-26September 26, 2023940.22
2023-09-27September 27, 202393.920.42
2023-09-28September 28, 202393.540.64
2023-09-29September 29, 202393.630.46
2023-10-02October 2, 202393.940.36
2023-10-03October 3, 202393.890.24
2023-10-04October 4, 202393.750.43
2023-10-05October 5, 202393.670.3
2023-10-06October 6, 202394.240.34
2023-10-09October 9, 202394.340.29
2023-10-10October 10, 202394.340.33
2023-10-11October 11, 202394.470.49
2023-10-12October 12, 202394.420.25
Rows × columns
83 × 4
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 A target stock pinning to its cash deal price (ATVI, 2023), derived from the stored result.
ColumnTypeRangeNotes
session_date date 2023-06-15 to 2023-10-12
session_label text 83 distinct values
close_px number 80.94 to 94.47 US dollars
day_range_pct number 0.13 to 11.39 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.

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(max(toFloat64(close)), 2)                                            AS close_px,
    round(100 * (max(toFloat64(high)) - min(toFloat64(low)))
          / max(toFloat64(close)), 2)                                          AS day_range_pct
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'ATVI'
  AND date BETWEEN '2023-06-15' AND '2023-10-20'
GROUP BY date
ORDER BY date

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisHow Options Adjust After Mergers & Spinoffs
Near-the-money implied volatility into a cash close (ATVI, 2023) series 83×4 → One deliverable, two companies: GE and GE HealthCare after the spin series 61×5 → 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,170 queries →