Trailing year distribution rate, price change, and approximate total return

WITH divs AS
(
    SELECT
        ticker,
        sum(cash_amount) AS paid_12m
    FROM
    (
        SELECT
            ticker,
            ex_dividend_date,
            toFloat64(max(cash_amount)) AS cash_amount
        FROM global_markets.stocks_dividends
        WHERE ticker IN ('JEPI', 'JEPQ', 'QYLD', 'XYLD', 'RYLD', 'SCHD', 'SPY')
          AND ex_dividend_date >= today() - 373
          AND ex_dividend_date <  today() - 5
        GROUP BY ticker, ex_dividend_date
    )
    GROUP BY ticker
),
px AS
(
    SELECT
        ticker,
        toFloat64(argMin(close, window_start)) AS price_then,
        toFloat64(argMax(close, window_start)) AS price_now
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('JEPI', 'JEPQ', 'QYLD', 'XYLD', 'RYLD', 'SCHD', 'SPY')
      AND (
            (window_start >= now() - INTERVAL 375 DAY AND window_start < now() - INTERVAL 368 DAY)
         OR (window_start >= now() - INTERVAL 9 DAY   AND window_start < now() - INTERVAL 2 DAY)
          )
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) >= 570
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) < 960
    GROUP BY ticker
)
SELECT
    px.ticker                                                          AS ticker,
    round(100 * divs.paid_12m / px.price_then, 1)                      AS distribution_rate_pct,
    round(100 * (px.price_now / px.price_then - 1), 1)                 AS price_change_pct,
    round(100 * ((px.price_now + divs.paid_12m) / px.price_then - 1), 1) AS approx_total_return_pct
FROM px
INNER JOIN divs ON divs.ticker = px.ticker
ORDER BY distribution_rate_pct DESC