ratios_courants
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-09-28, from stock-splits-on-euronext-paris.
| ratio_label | sens | operations |
|---|---|---|
| 1 pour 10 | regroupement | 966 |
| 1 pour 20 | regroupement | 426 |
| 2 pour 1 | division | 355 |
| 1 pour 5 | regroupement | 342 |
| 1 pour 4 | regroupement | 212 |
| 1 pour 15 | regroupement | 195 |
| 3 pour 1 | division | 189 |
| 1 pour 3 | regroupement | 179 |
| 1 pour 25 | regroupement | 178 |
| 1 pour 2 | regroupement | 156 |
| 1 pour 50 | regroupement | 154 |
| 1 pour 100 | regroupement | 153 |
- Rows × columns
- 12 × 3
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
ratio_label |
text | 12 distinct values (1 pour 10, 1 pour 100, 1 pour 15…) | |
sens |
text | 2 distinct values (division, regroupement) | |
operations |
number | 153 to 966 |
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
concat(toString(nb_nouvelles), ' pour ', toString(nb_anciennes)) AS ratio_label,
if(nb_nouvelles > nb_anciennes, 'division', 'regroupement') AS sens,
count() AS operations
FROM
(
SELECT
ticker,
execution_date,
toUInt32(any(split_from)) AS nb_anciennes,
toUInt32(any(split_to)) AS nb_nouvelles
FROM global_markets.stocks_splits
WHERE execution_date >= today() - 1830
AND execution_date < today()
AND ticker NOT IN ('SPCX')
GROUP BY ticker, execution_date
)
WHERE nb_nouvelles != nb_anciennes
GROUP BY nb_anciennes, nb_nouvelles
ORDER BY operations DESC
LIMIT 12
Work with this data in your AI assistant
Opens ready to query, with this page's data. Free, no account.