Three years of total return, split into price change and distributions: July 2023 to June 2026

WITH px AS (
    SELECT ticker,
           argMin(close, window_start) AS start_price,
           argMax(close, window_start) AS end_price
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('QYLD', 'XYLD', 'RYLD', 'JEPI', 'JEPQ', 'SPYI', 'QQQ', 'SPY')
      AND toDate(toTimeZone(window_start, 'America/New_York')) BETWEEN toDate('2023-07-03') AND toDate('2026-06-30')
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
    GROUP BY ticker
),
dv AS (
    SELECT ticker,
           sum(cash_amount) AS distributions,
           count() AS payments
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('QYLD', 'XYLD', 'RYLD', 'JEPI', 'JEPQ', 'SPYI', 'QQQ', 'SPY')
      AND ex_dividend_date BETWEEN toDate('2023-07-03') AND toDate('2026-06-30')
      AND cash_amount > 0
    GROUP BY ticker
)
SELECT px.ticker AS ticker,
       round(px.start_price, 2) AS start_price,
       round(px.end_price, 2) AS end_price,
       round((px.end_price - px.start_price) / px.start_price * 100, 1) AS price_return_pct,
       round(dv.distributions / px.start_price * 100, 1) AS distribution_return_pct,
       round(((px.end_price - px.start_price) + dv.distributions) / px.start_price * 100, 1) AS total_return_pct,
       dv.payments AS payments
FROM px
INNER JOIN dv ON px.ticker = dv.ticker
ORDER BY total_return_pct DESC