ETF 분배금 내 원금환급(Return of Capital)의 의미

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

WITH monthly AS
(
    SELECT
        ticker,
        toStartOfMonth(toTimeZone(window_start, 'America/New_York')) AS month_start,
        argMax(toFloat64(close), window_start)                       AS month_close
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('QYLD', 'XYLD', 'RYLD')
      AND window_start >= toDateTime('2021-09-01 04:00:00')
      AND window_start <  toDateTime('2026-08-01 04:00:00')
      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, month_start
),
base AS
(
    SELECT
        ticker,
        argMin(month_close, month_start) AS base_close
    FROM monthly
    GROUP BY ticker
)
SELECT
    formatDateTime(m.month_start, '%Y-%m')                                  AS month,
    round(100 * sumIf(m.month_close / b.base_close, m.ticker = 'QYLD'), 1)  AS qyld_price_index,
    round(100 * sumIf(m.month_close / b.base_close, m.ticker = 'XYLD'), 1)  AS xyld_price_index,
    round(100 * sumIf(m.month_close / b.base_close, m.ticker = 'RYLD'), 1)  AS ryld_price_index
FROM monthly AS m
INNER JOIN base AS b ON b.ticker = m.ticker
GROUP BY m.month_start
ORDER BY m.month_start

SELECT
    formatDateTime(toStartOfMonth(ex_dividend_date), '%Y-%m') AS month,
    round(sumIf(cash_amount, ticker = 'QYLD'), 4)             AS qyld_per_share,
    round(sumIf(cash_amount, ticker = 'XYLD'), 4)             AS xyld_per_share,
    round(sumIf(cash_amount, ticker = 'RYLD'), 4)             AS ryld_per_share
FROM
(
    SELECT
        ticker,
        ex_dividend_date,
        toFloat64(max(cash_amount)) AS cash_amount
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('QYLD', 'XYLD', 'RYLD')
      AND ex_dividend_date >= toDate('2021-09-01')
      AND ex_dividend_date <  toDate('2026-08-01')
    GROUP BY ticker, ex_dividend_date
)
GROUP BY toStartOfMonth(ex_dividend_date)
ORDER BY toStartOfMonth(ex_dividend_date)

WITH yearly_px AS
(
    SELECT
        toYear(toTimeZone(window_start, 'America/New_York')) AS yr,
        round(avg(toFloat64(close)), 2)                      AS avg_close
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'QYLD'
      AND window_start >= toDateTime('2021-01-01 05:00:00')
      AND window_start <  toDateTime('2026-01-01 05:00:00')
      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 yr
),
yearly_div AS
(
    SELECT
        toYear(ex_dividend_date)         AS yr,
        round(sum(cash_amount), 3)       AS distributions_per_share,
        count()                          AS payments
    FROM
    (
        SELECT
            ex_dividend_date,
            toFloat64(max(cash_amount)) AS cash_amount
        FROM global_markets.stocks_dividends
        WHERE ticker = 'QYLD'
          AND ex_dividend_date >= toDate('2021-01-01')
          AND ex_dividend_date <  toDate('2026-01-01')
        GROUP BY ex_dividend_date
    )
    GROUP BY yr
)
SELECT
    toString(p.yr)                                            AS year,
    d.distributions_per_share                                 AS distributions_per_share,
    p.avg_close                                               AS avg_close,
    round(100 * d.distributions_per_share / p.avg_close, 1)   AS distribution_rate_pct,
    d.payments                                                AS payments
FROM yearly_px AS p
INNER JOIN yearly_div AS d ON d.yr = p.yr
ORDER BY p.yr