adjusted_close / close, with the
day before. On a split day the factor steps by the split ratio while the
adjusted price barely moves: Nvidia’s factor stepped exactly 10x on June 10,
2024. Across every US stock and ETF since January 2025, the test finds
1,878 splits with clean ratios, 1,580 of them reverse splits.
Below are the queries to list one ticker’s splits and every split in the
market, what the counts show, how to tell a split from a crash or a bad
print, and when a backtest should use raw prices instead of adjusted ones.
Fruit Stand publishes the Historical Stock Prices listing used here. Every
query in this post was run on November 15, 2026, against the listing, with
prices through November 13, 2026. Split ratios and dates for the companies
named were checked against their own press releases or SEC filings the same
day.
What a split looks like in daily prices
A split changes the number of shares, not what the company is worth. So on the first day at the new price, the rawclose jumps or drops by the split
ratio, and the split- and dividend-adjusted adjusted_close moves only by
the day’s real gain or loss.
The adjustment factor, adjusted_close / close, shows the split directly.
It’s 1.0 on the latest date and shrinks going back each time a split or
dividend is applied. Divide one day’s factor by the day before’s and you get:
Nvidia is the usual example: its close went from $1,208.88 on June 7, 2024,
to $121.79 on June 10, its factor stepped by 10.0, and its adjusted price
rose 0.75%. How to Calculate Stock Returns From Daily Prices in
SQL shows the returns either side of that
day, and Adjusted Close vs. Close explains
how the factor is built.
Note the date. Nvidia’s 8-K
says the new shares were distributed after the close on June 7 and trading
on a split-adjusted basis began June 10. Price data marks the split on June
10, the first day at the new price. Press releases often call the earlier
date the effective date.
List every split for one ticker
This query finds every day where the factor stepped more than 20% and the raw close moved more than 20% too:
Those are Nvidia’s six splits, which turned one original share into 480
(2 × 2 × 2 × 1.5 × 4 × 10). Swap in any ticker. For Lucid Group (
LCID) the
query returns a single row: a 1-for-10 reverse split on September 2, 2025,
when the close went from $1.98 to $17.66.
Both filters matter. The factor step alone also catches big special
dividends, and the close move alone catches every crash.
List every split and reverse split in the market
The same test across every stock and ETF needs a few more guards. This version saves the results to a temporary table,splits, for the queries
that follow:
- Stocks and ETFs only. Mutual funds pay large year-end distributions that step the factor by 20% or more with no split.
- Prices of at least one cent. Below that, a quote moving from $0.0002 to $0.0001 halves the close in one tick, and the factor flips back and forth without any corporate action.
- The adjusted price moved less than 2x either way. Real reverse splits are often followed by a big drop the same day, so a tight limit here misses them.
- Rounding to a clean ratio. Whole numbers within 3% (2-for-1, 1-for-10,
1-for-17), and the common fractions 3-for-2, 4-for-3, 5-for-4 and
1-for-2.5 within 0.3%. Anything else is labelled
unclear.
How many splits and reverse splits there were
From January 2, 2025, to November 13, 2026:
Reverse splits outnumbered forward splits by more than five to one. Some
companies did several: Workhorse Group (
WKHS) shows up twice, at 1-for-12.5
in March 2025 and 1-for-12 in December 2025.
By venue, with how many of the splits were in shares that traded under $1
just before or after:
The reverse-split count is mostly Nasdaq stocks trying to get back above $1.
Nasdaq requires a minimum bid of $1.00, and Workhorse’s March 2025
release
gave that as the reason for its split. Of 964 Nasdaq reverse splits, 835
were in shares under $1. The ETF reverse splits are mostly leveraged and
inverse funds, whose prices decay over time: 176 of the 217 have “2x”,
“ultra”, “short”, “daily” or similar in their names.
Forward splits are rarer, and the OTC ones are mostly foreign companies’
shares and ADRs trading over the counter in the US, such as Japanese
companies that split at home.
The most common ratios:
Checking a simpler rule
A quick first pass is “the close went up more than 4x while the adjusted price moved less than 50%.” Since January 2025 that matches 1,568 days. Of those, 1,381 are reverse splits the full query confirms, 147 are sub-penny quotes ticking between $0.0001 and $0.0009, 36 are mutual funds, and 4 have ratios that don’t round cleanly. So the simple rule is about 88% right, and nearly all its misses are sub-penny quotes.Notable splits, checked against company sources
Every one matches on ratio. The dates differ only where the company names
the effective date and trading starts at the next open, as with Lucid
(effective Friday, August 29; the next trading day was September 2, after
Labor Day) and Booking (effected Thursday, April 2; markets were closed on
Good Friday, so trading resumed April 6).
What the unclear ones are
The 113 unclear days are worth a look, because they’re what an automated split detector gets wrong:- Spinoffs. A spinoff removes value from the parent’s price, so the
factor steps by the spun-off share. DuPont (
DD) stepped by 2.39 on November 3, 2025, after it distributed Qnity Electronics, and FedEx (FDX) stepped by 1.241 on June 1, 2026, when FedEx Freight began trading. FedEx’s 1.241 is less than 1% from 5-for-4, which is why the query only accepts fractions within 0.3%. - Large special distributions from REITs and companies selling assets, and year-end distributions from some leveraged and option-income ETFs.
- Foreign shares that split abroad. A 2-for-1 split at home can show up as 2.05 on a thinly traded US over-the-counter line, whose quote doesn’t move exactly with the home market. Most fall within the 3% tolerance; some don’t.
- Bad raw prices. If a vendor’s raw close is wrong for a stretch of days while the adjusted price stays right, the factor steps by an odd ratio and steps back when the raw price is corrected. Before treating an odd ratio as a split, check the price against a second source.
How to tell a split from a crash or a data error
The last two columns do most of the work. This finds one-day spikes on NYSE
and Nasdaq that reversed the next day with no change in the factor:
test stock filter matters too. Nasdaq’s test tickers, such as ZVZZT,
have prices in the data, and the security master lists four of them. Their
prices swing wildly and would fill this list.
Adjusted prices for returns, raw prices for price filters
Adjusted prices are right for returns, moving averages and anything else that compares prices across time. The backtest guide covers why. But any rule about the price level itself has to use the rawclose:
“stocks under $5," "skip anything under $1,” minimum share prices for
shorting, or position sizing by share count. Adjusted prices rewrite old
levels. Forward splits push old adjusted prices down, and reverse splits
push them up, sometimes by thousands of times. On January 2, 2024:
Workhorse traded at 36 cents that day. After reverse splits of 1-for-20
(2024), 1-for-12.5 and 1-for-12 (both 2025), its adjusted price says
$1,082.70.
Across the whole market the error adds up:
close and compute returns from adjusted_close,
in the same query.
Build a split-adjusted series without dividends
Some charts and price-return calculations want prices adjusted for splits but not dividends. With no splits table, you can build it from the detected split days: round each split’s factor step to its ratio, which drops the small dividend part, and divide every earlier close by the product of the later ratios.
Apple’s 7-for-1 (2014) and 4-for-1 (2020) splits combine to 28, so $645.57
becomes $23.06. From June 6, 2014, to November 13, 2026, the split-adjusted
series gives a price return of 1,445%, and the fully adjusted one a total
return of 1,665%. The gap is the dividends.
What this method leaves out:
- It only removes splits the test finds. A missed or unclear event stays in
the series as a jump, so check the
split_ratiorows for any ticker you use. - Rounding to two decimals assumes clean ratios. An odd ratio such as 1-for-12.5 works; a 1-for-7.75 would need more decimals.
- Spinoffs aren’t splits, so they’re left in, which is usually what you want for a price-only series.
- There’s no dividend table, so you can’t build the reverse (dividends but not splits) this way.
Limitations of finding splits from prices
- No announcement, record or payable dates. Prices only show the first day at the new price. For event studies around the announcement, you need the company’s release or 8-K.
- Spinoffs step the factor too. Large ones land in
unclear, but a small one can land near 5-for-4 or 4-for-3. Check fractional ratios by hand. - No delisted securities. The Historical Stock Prices listing covers securities that still trade, so a company that reverse split and was delisted anyway isn’t in these counts. The real number of reverse splits is higher.
- A split only appears once the vendor applies it. If the adjusted price hasn’t been updated yet, a split looks like a crash in both columns for a day or two.
- Share classes and temporary tickers count separately.
RUSHAandRUSHBare one company, and an OTC stock can show up under a temporary ticker with aDadded after a reverse split as well as its usual one.
STOCKHISTORY returning Netflix’s
pre-split prices around $1,000 after its 10-for-1 split, while recent prices
were split-adjusted. On QuantConnect’s forum, a user traced a profit
spike
in a backtest to Top Ships’ 1-for-25 reverse split in August 2020, which their
algorithm never saw as a split event. Running the factor test on your own
data catches both kinds of problem.
F.A.Q.
How do I know if a stock had a reverse split?
How do I know if a stock had a reverse split?
Look for a day when the raw close jumped by a clean multiple, such as 10x or 20x, while the adjusted close barely moved. In SQL, divide
adjusted_close / close by the previous day’s value; a reverse split shows as 0.1 for 1-for-10, 0.05 for 1-for-20. Confirm the ratio in the company’s press release or 8-K.Is there a table of stock splits in the Historical Stock Prices listing?
Is there a table of stock splits in the Historical Stock Prices listing?
No. The listing has daily prices, adjusted prices and the security master, but no splits or dividends table. The queries in this post rebuild split dates and ratios from the prices, which is enough for most backtests and screens.
Why are there so many more reverse splits than forward splits?
Why are there so many more reverse splits than forward splits?
Mostly because of exchange price minimums. Nasdaq requires a $1.00 minimum bid, and companies that fall below it often reverse split to stay listed. Of 1,580 reverse splits since January 2025, 1,257 were in shares trading under $1. Leveraged and inverse ETFs also reverse split often, because their prices tend to decay.
Should a backtest use adjusted or raw prices?
Should a backtest use adjusted or raw prices?
Both. Use
adjusted_close for returns and signals, and the raw close for anything about the price level, such as a “stocks under $5" filter or share counts. On January 2, 2024, a $5 screen on adjusted prices put 575 of 4,523 NYSE and Nasdaq stocks on the wrong side.Why does a split show up a day after the date in the press release?
Why does a split show up a day after the date in the press release?
Companies often give the effective date as the day the new shares are distributed, after that day’s close. Price data marks the split on the first trading day at the new price. Nvidia’s split was effective after the close on June 7, 2024, and traded split-adjusted from June 10.