NVDA across its June 2024 split: stored close and one pre-split share

SELECT
    toString(a.date)                                                  AS session_date,
    formatDateTime(a.date, '%b %e, %Y')                               AS tape_label,
    if(a.date < '2024-06-10', 'before ex-date', 'on or after ex-date') AS tape_phase,
    round(toFloat64(a.close), 2)                                      AS close_price,
    round(toFloat64(a.close) * s.ratio, 2)                            AS one_prior_share_value
FROM
(
    SELECT
        date,
        max(close) AS close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'NVDA'
      AND date >= '2024-06-03'
      AND date <= '2024-06-14'
    GROUP BY date
) AS a
CROSS JOIN
(
    SELECT toFloat64(max(split_to)) / greatest(toFloat64(max(split_from)), 1.0) AS ratio
    FROM global_markets.stocks_splits
    WHERE ticker = 'NVDA'
      AND execution_date BETWEEN '2024-06-05' AND '2024-06-12'
) AS s
ORDER BY a.date