3,256 answered market questions

SELECT
    ticker                                            AS symbol,
    formatDateTime(execution_date, '%b %e, %Y')       AS effective_label,
    concat(
        toString(round(toFloat64(any(split_to)), 2)),
        '-for-',
        toString(round(toFloat64(any(split_from)), 2))
    )                                                 AS ratio,
    round(100 * toFloat64(any(split_to)) / toFloat64(any(split_from)), 2) AS shares_per_contract
FROM global_markets.stocks_splits
WHERE execution_date >= '2026-01-01'
  AND execution_date <= '2026-09-30'
  AND ticker NOT IN ('SPCX')
  AND toFloat64(split_to) < toFloat64(split_from)
GROUP BY ticker, execution_date
ORDER BY execution_date DESC
LIMIT 10