Tracker distribution yield vs the 10 year Treasury, calendar year ends 2015-2025

WITH px AS (
    SELECT toYear(toTimeZone(window_start, 'America/New_York')) AS year,
           argMax(close, window_start) AS year_end_price
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND toYear(toTimeZone(window_start, 'America/New_York')) BETWEEN 2015 AND 2025
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
    GROUP BY year
),
dv AS (
    SELECT toYear(ex_dividend_date) AS year,
           sum(cash_amount) AS annual_distributions,
           count() AS payments
    FROM global_markets.stocks_dividends
    WHERE ticker = 'SPY'
      AND cash_amount > 0
      AND ex_dividend_date >= toDate('2015-01-01')
      AND ex_dividend_date <= toDate('2025-12-31')
    GROUP BY year
),
tsy AS (
    SELECT toYear(date) AS year,
           argMax(yield_10_year, date) AS y10
    FROM global_markets.treasury_yields
    WHERE toYear(date) BETWEEN 2015 AND 2025
      AND toMonth(date) = 12
      AND yield_10_year IS NOT NULL
    GROUP BY year
)
SELECT px.year AS year,
       round(dv.annual_distributions / px.year_end_price * 100, 2) AS tracker_yield_pct,
       round(tsy.y10, 2) AS treasury_10y_pct,
       round(dv.annual_distributions, 2) AS distributions_per_share_usd,
       dv.payments AS payments
FROM px
INNER JOIN dv ON px.year = dv.year
INNER JOIN tsy ON px.year = tsy.year
ORDER BY year