2,170 answered market questions

SELECT
    execution_date,
    formatDateTime(execution_date, '%b %e, %Y') AS scheduled,
    ticker,
    concat(toString(toInt32(split_to)), '-for-', toString(toInt32(split_from))) AS ratio,
    if(adjustment_type = 'forward_split', 'forward split', 'reverse split') AS split_direction
FROM global_markets.stocks_splits
WHERE execution_date > today()
  AND adjustment_type IN ('forward_split', 'reverse_split')
ORDER BY execution_date, ticker
LIMIT 30