3,293 answered market questions

WITH
    large_caps AS
    (
        SELECT ticker
        FROM global_markets.stocks_ratios
        WHERE date >= today() - 60
          AND market_cap > 20000000000
        GROUP BY ticker
    ),
    forward_splits AS
    (
        SELECT
            ticker,
            execution_date,
            any(split_to)   AS split_to,
            any(split_from) AS split_from
        FROM global_markets.stocks_splits
        WHERE execution_date >= '2022-01-01'
          AND execution_date <  today()
          AND ticker NOT IN ('SPCX')
        GROUP BY ticker, execution_date
        HAVING split_to > split_from
    )
SELECT
    f.ticker                                                                AS ticker,
    concat(toString(toUInt32(f.split_to)), '-for-',
           toString(toUInt32(f.split_from)))                                AS split_label,
    formatDateTime(f.execution_date, '%b %e, %Y')                           AS effective_on,
    toUInt32(round(100 * toFloat64(f.split_to) / toFloat64(f.split_from)))  AS shares_after_100,
    round(100 * (1 - toFloat64(f.split_from) / toFloat64(f.split_to)), 1)   AS ticket_cut_pct
FROM forward_splits AS f
INNER JOIN large_caps AS l ON l.ticker = f.ticker
ORDER BY shares_after_100 DESC, f.execution_date DESC
LIMIT 12