STRASMORE/EXPLORE 2,170 QUERIES

Payers across their own share split: the raw change against the split-adjusted change

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-25, from Dividend Increases & Cuts This Week.

as of series 9×7read in context →
Payers across their own share split: the raw change against the split-adjusted change — 9 rows by 7 columns, computed from US exchange, SIP and OPRA data.
tickersplit_ratioexecuted_datebefore_split_usdafter_split_usdapparent_pctadjusted_pct
NVDA10-for-12024-06-100.040.01-75150
WMT3-for-12024-02-260.570.2075-63.69.2
AVGO10-for-12024-07-155.250.53-89.91
BKNG25-for-12026-04-0610.50.42-960
CTAS4-for-12024-09-121.560.39-750
ETR2-for-12024-12-131.20.6-500
FAST2-for-12025-05-220.440.22-500
LRCX10-for-12024-10-032.30.23-900
ODFL2-for-12024-03-280.520.26-500
Rows × columns
9 × 7
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 Payers across their own share split: the raw change against the split-adjusted change, derived from the stored result.
ColumnTypeRangeNotes
ticker text 9 distinct values (AVGO, BKNG, CTAS…)
split_ratio text 5 distinct values (10-for-1, 2-for-1, 25-for-1…)
executed_date date 2024-02-26 to 2026-04-06
before_split_usd number 0.04 to 10.5 US dollars
after_split_usd number 0.01 to 0.6 US dollars
apparent_pct number -96 to -50 percent
adjusted_pct number 0 to 150 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 
WITH sp AS (
    SELECT ticker,
           max(execution_date) AS exec_date,
           argMax(split_to / split_from, execution_date) AS ratio
    FROM global_markets.stocks_splits
    WHERE adjustment_type = 'forward_split'
      AND split_from > 0
      AND split_to >= split_from * 2
      AND modulo(split_to, split_from) = 0
      AND ticker IN ('NVDA', 'AVGO', 'WMT', 'LRCX', 'CTAS', 'ETR', 'FAST', 'ODFL', 'BKNG')
      AND execution_date >= today() - 1500
      AND execution_date <= today() - 90
    GROUP BY ticker
),
divs AS (
    SELECT ticker, ex_dividend_date, argMax(cash_amount, declaration_date) AS amt
    FROM global_markets.stocks_dividends
    WHERE distribution_type = 'recurring'
      AND cash_amount > 0
      AND currency = 'USD'
      AND ticker IN ('NVDA', 'AVGO', 'WMT', 'LRCX', 'CTAS', 'ETR', 'FAST', 'ODFL', 'BKNG')
    GROUP BY ticker, ex_dividend_date
)
SELECT sp.ticker AS ticker,
       concat(toString(toUInt32(round(sp.ratio))), '-for-1') AS split_ratio,
       toString(sp.exec_date) AS executed_date,
       round(argMaxIf(d.amt, d.ex_dividend_date, d.ex_dividend_date < sp.exec_date), 4) AS before_split_usd,
       round(argMinIf(d.amt, d.ex_dividend_date, d.ex_dividend_date >= sp.exec_date), 4) AS after_split_usd,
       round(100 * (argMinIf(d.amt, d.ex_dividend_date, d.ex_dividend_date >= sp.exec_date)
                    / argMaxIf(d.amt, d.ex_dividend_date, d.ex_dividend_date < sp.exec_date) - 1), 1) AS apparent_pct,
       round(100 * (argMinIf(d.amt, d.ex_dividend_date, d.ex_dividend_date >= sp.exec_date) * sp.ratio
                    / argMaxIf(d.amt, d.ex_dividend_date, d.ex_dividend_date < sp.exec_date) - 1), 1) AS adjusted_pct
FROM sp
INNER JOIN divs d ON d.ticker = sp.ticker
GROUP BY sp.ticker, sp.ratio, sp.exec_date
HAVING countIf(d.ex_dividend_date < sp.exec_date) > 0
   AND countIf(d.ex_dividend_date >= sp.exec_date) > 0
ORDER BY adjusted_pct DESC, sp.ticker

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 analysisDividend Increases & Cuts This Week
Increases against cuts, by week of declaration (complete weeks only) series 26×4 → Dividend cuts declared in the last 90 days, the deepest 14 first (one week is too thin for a table) series 14×6 → Dividend increases declared in the last 7 days, largest companies first (capped at 12 rows) series 12×8 → Increases, cuts and the typical raise this calendar year, by company size (bands use today's market value) table 4×6 → Dividend cuts at major US companies, ranked by the size of the drop (last 6 years) ranking 14×4 → AT&T's annual dividend per share, before and after its 2022 reset ranking 8×2 → See all 2,170 queries →