SPY by calendar year: price change against dividends collected

WITH
    px AS
    (
        SELECT
            toDate(toTimeZone(window_start, 'America/New_York')) AS d,
            toFloat64(argMax(close, window_start))               AS close_px
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'SPY'
          AND window_start >= today() - 2950
          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 d
    ),
    by_year AS
    (
        SELECT
            toYear(d)           AS year,
            argMin(close_px, d) AS first_close,
            argMax(close_px, d) AS last_close
        FROM px
        GROUP BY year
    ),
    divs AS
    (
        SELECT
            toYear(ex_date)  AS year,
            sum(cash_amount) AS year_dividends
        FROM
        (
            SELECT
                ex_dividend_date            AS ex_date,
                max(toFloat64(cash_amount)) AS cash_amount
            FROM global_markets.stocks_dividends
            WHERE ticker = 'SPY'
              AND ex_dividend_date >= today() - 2950
            GROUP BY ex_dividend_date
        )
        GROUP BY year
    )
SELECT
    by_year.year                                                   AS year,
    round((by_year.last_close / by_year.first_close - 1) * 100, 2) AS price_return_pct,
    round(divs.year_dividends / by_year.first_close * 100, 2)      AS dividend_return_pct
FROM by_year
INNER JOIN divs ON divs.year = by_year.year
WHERE by_year.year > toYear(today() - 2950)
  AND by_year.year < toYear(today())
ORDER BY year