splits_2026

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
    s.ticker                                                    AS ticker,
    concat(toString(s.to_shares), ':', toString(s.from_shares)) AS ratio,
    toUInt32(round(100 * s.to_shares / s.from_shares))          AS shares_from_100,
    concat(toString(toMonth(s.exec_day)), '月',
           toString(toDayOfMonth(s.exec_day)), '日')            AS effective_label
FROM
(
    SELECT
        ticker,
        execution_date  AS exec_day,
        max(split_to)   AS to_shares,
        max(split_from) AS from_shares
    FROM global_markets.stocks_splits
    WHERE execution_date >= '2026-01-01'
      AND execution_date <  '2027-01-01'
      AND split_to > split_from
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker, execution_date
) AS s
INNER JOIN
(
    SELECT
        ticker,
        avg(volume) AS adv
    FROM global_markets.stocks_daily_aggs
    WHERE date >= '2026-01-01'
      AND date <  '2027-01-01'
    GROUP BY ticker
    HAVING adv > 500000
) AS v ON v.ticker = s.ticker
ORDER BY s.exec_day
LIMIT 12