What one 100 share contract covers after a non whole split ratio, 2020 to July 2026

WITH ratio_counts AS (
    SELECT concat(toString(toUInt32(split_to)), '-for-', toString(toUInt32(split_from))) AS ratio_label,
           if(toFloat64(split_to) > toFloat64(split_from), 'forward split', 'reverse split') AS direction,
           round(100 * toFloat64(split_to) / toFloat64(split_from), 2) AS shares_per_contract_after,
           count() AS split_count
    FROM global_markets.stocks_splits
    WHERE execution_date >= toDate('2020-01-01')
      AND execution_date < toDate('2026-08-01')
      AND toFloat64(split_from) > 0
      AND toFloat64(split_to) > 0
      AND toFloat64(split_from) = round(toFloat64(split_from))
      AND toFloat64(split_to) = round(toFloat64(split_to))
      AND modulo(toUInt32(split_to), toUInt32(split_from)) != 0
    GROUP BY ratio_label, direction, shares_per_contract_after
),
ranked AS (
    SELECT ratio_label,
           direction,
           shares_per_contract_after,
           split_count,
           row_number() OVER (PARTITION BY direction ORDER BY split_count DESC) AS rank_in_direction
    FROM ratio_counts
)
SELECT ratio_label,
       direction,
       split_count,
       shares_per_contract_after
FROM ranked
WHERE rank_in_direction <= 5
ORDER BY shares_per_contract_after DESC