tranches_de_prix

Name: tranches_de_prix
Creator: Strasmore
Published: 2026-09-28
License: https://www.strasmore.com/terms/

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.

as of 2026-09-28 ranking 6×3read in context →

tranches_de_prix — 6 rows by 3 columns, computed 2026-09-28 from US exchange, SIP and OPRA data.
tranche_de_prix	divisions	regroupements
moins de 0,50 $	2	58
de 0,50 $ a 1 $	2	21
de 1 $ a 2 $	7	99
de 2 $ a 5 $	19	472
de 5 $ a 10 $	33	393
10 $ et plus	258	861

Rows × columns: 6 × 3
Computed: 2026-09-28
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 tranches_de_prix, derived from the stored result.
Column	Type	Range
`tranche_de_prix`	text	6 distinct values
`divisions`	number	2 to 258
`regroupements`	number	21 to 861

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 2026-09-28, 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.

WITH operations AS
(
    SELECT
        ticker,
        execution_date,
        if(toFloat64(any(split_to)) > toFloat64(any(split_from)), 'division', 'regroupement') AS sens
    FROM global_markets.stocks_splits
    WHERE execution_date >= today() - 1100
      AND execution_date <  today() - 5
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker, execution_date
    HAVING toFloat64(any(split_to)) != toFloat64(any(split_from))
)
SELECT
    tranche_de_prix,
    countIf(sens = 'division')     AS divisions,
    countIf(sens = 'regroupement') AS regroupements
FROM
(
    SELECT
        sens,
        dernier_cours,
        multiIf(
            dernier_cours < 0.5, 'moins de 0,50 $',
            dernier_cours < 1,   'de 0,50 $ a 1 $',
            dernier_cours < 2,   'de 1 $ a 2 $',
            dernier_cours < 5,   'de 2 $ a 5 $',
            dernier_cours < 10,  'de 5 $ a 10 $',
                                 '10 $ et plus'
        ) AS tranche_de_prix
    FROM
    (
        SELECT
            o.sens                             AS sens,
            argMax(toFloat64(d.close), d.date) AS dernier_cours
        FROM operations AS o
        INNER JOIN global_markets.stocks_daily_aggs AS d ON d.ticker = o.ticker
        WHERE d.date >= o.execution_date - 15
          AND d.date <  o.execution_date
          AND d.date >= today() - 1120
          AND d.date <  today()
        GROUP BY o.ticker, o.execution_date, o.sens
    )
)
GROUP BY tranche_de_prix
ORDER BY min(dernier_cours)

SQL to run

WITH operations AS
(
    SELECT
        ticker,
        execution_date,
        if(toFloat64(any(split_to)) > toFloat64(any(split_from)), 'division', 'regroupement') AS sens
    FROM global_markets.stocks_splits
    WHERE execution_date >= today() - 1100
      AND execution_date <  today() - 5
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker, execution_date
    HAVING toFloat64(any(split_to)) != toFloat64(any(split_from))
)
SELECT
    tranche_de_prix,
    countIf(sens = 'division')     AS divisions,
    countIf(sens = 'regroupement') AS regroupements
FROM
(
    SELECT
        sens,
        dernier_cours,
        multiIf(
            dernier_cours < 0.5, 'moins de 0,50 $',
            dernier_cours < 1,   'de 0,50 $ a 1 $',
            dernier_cours < 2,   'de 1 $ a 2 $',
            dernier_cours < 5,   'de 2 $ a 5 $',
            dernier_cours < 10,  'de 5 $ a 10 $',
                                 '10 $ et plus'
        ) AS tranche_de_prix
    FROM
    (
        SELECT
            o.sens                             AS sens,
            argMax(toFloat64(d.close), d.date) AS dernier_cours
        FROM operations AS o
        INNER JOIN global_markets.stocks_daily_aggs AS d ON d.ticker = o.ticker
        WHERE d.date >= o.execution_date - 15
          AND d.date <  o.execution_date
          AND d.date >= today() - 1120
          AND d.date <  today()
        GROUP BY o.ticker, o.execution_date, o.sens
    )
)
GROUP BY tranche_de_prix
ORDER BY min(dernier_cours)

⌘/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