Trailing 12-month dividend yield: SPY against two open-end S&P 500 ETFs

WITH
    divs AS
    (
        SELECT
            ticker,
            ex_dividend_date,
            max(toFloat64(cash_amount)) AS cash_amount
        FROM global_markets.stocks_dividends
        WHERE ticker IN ('SPY', 'VOO', 'IVV')
          AND ex_dividend_date >= today() - 365
          AND ex_dividend_date <  today()
        GROUP BY ticker, ex_dividend_date
    ),
    ttm AS
    (
        SELECT
            ticker,
            sum(cash_amount) AS ttm_dividend
        FROM divs
        GROUP BY ticker
        HAVING count() = 4
    ),
    px AS
    (
        SELECT
            ticker,
            toFloat64(argMax(close, window_start)) AS last_close
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker IN ('SPY', 'VOO', 'IVV')
          AND window_start >= today() - 15
          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
    ),
    fund_yield AS
    (
        SELECT
            ttm.ticker                             AS ticker,
            ttm.ttm_dividend / px.last_close * 100 AS yield_pct
        FROM ttm
        INNER JOIN px ON px.ticker = ttm.ticker
    ),
    spy_yield AS
    (
        SELECT max(yield_pct) AS spy_pct
        FROM fund_yield
        WHERE ticker = 'SPY'
    )
SELECT
    fund_yield.ticker                                          AS ticker,
    round(fund_yield.yield_pct, 3)                             AS trailing_yield_pct,
    round((fund_yield.yield_pct - spy_yield.spy_pct) * 100, 1) AS yield_spread_vs_spy_bps
FROM fund_yield
CROSS JOIN spy_yield
ORDER BY ticker