共同基金何时派发股息？时间表与税务

SELECT ticker,
       multiIf(ticker IN ('AGG', 'BND', 'LQD', 'HYG', 'TLT'), 'bonds',
               ticker = 'PFF', 'preferred shares',
               ticker = 'JEPI', 'stocks with options written against them',
               ticker = 'VNQ', 'real estate securities',
               ticker IN ('SCHD', 'VYM'), 'dividend-paying stocks',
               'large-cap stocks') AS portfolio,
       round(count() / 3, 1) AS payouts_per_year,
       uniqExact(toMonth(ex_dividend_date)) AS calendar_months_used,
       round(sum(toFloat64(cash_amount)) / 3, 3) AS annual_total_usd,
       round(avg(toFloat64(cash_amount)), 4) AS avg_payment_usd
FROM global_markets.stocks_dividends
WHERE ticker IN ('AGG', 'BND', 'LQD', 'HYG', 'TLT', 'PFF', 'JEPI',
                 'SPY', 'VOO', 'VTI', 'QQQ', 'SCHD', 'VYM', 'VNQ')
  AND cash_amount > 0
  AND ex_dividend_date >= toDate('2023-01-01')
  AND ex_dividend_date <= toDate('2025-12-31')
GROUP BY ticker
ORDER BY payouts_per_year DESC, ticker ASC

SELECT formatDateTime(toStartOfMonth(ex_dividend_date), '%Y-%m') AS month,
       formatDateTimeInJodaSyntax(toStartOfMonth(ex_dividend_date), 'MMMM yyyy') AS month_label,
       round(sum(toFloat64(cash_amount)), 4) AS distribution_per_share,
       count() AS records
FROM global_markets.stocks_dividends
WHERE ticker = 'AGG'
  AND cash_amount > 0
  AND ex_dividend_date >= toDate('2023-07-01')
  AND ex_dividend_date <= toDate('2026-06-30')
GROUP BY toStartOfMonth(ex_dividend_date)
ORDER BY toStartOfMonth(ex_dividend_date)

SELECT toMonth(ex_dividend_date) AS month,
       ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun',
        'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'][toMonth(ex_dividend_date)] AS month_label,
       round(100 * countIf(frequency = 1)
             / greatest(sum(countIf(frequency = 1)) OVER (), 1), 1) AS annual_payer_share_pct,
       round(100 * count()
             / greatest(sum(count()) OVER (), 1), 1) AS all_payer_share_pct
FROM global_markets.stocks_dividends
WHERE ex_dividend_date >= toDate('2023-01-01')
  AND ex_dividend_date <= toDate('2025-12-31')
  AND cash_amount > 0
GROUP BY month
ORDER BY month

WITH daily AS (
    SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS d,
           argMax(close, window_start) AS session_close
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'AGG'
      AND toDate(toTimeZone(window_start, 'America/New_York')) >= toDate('2023-07-01')
      AND toDate(toTimeZone(window_start, 'America/New_York')) <= 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 d
),
paid AS (
    SELECT ex_dividend_date AS d,
           sum(toFloat64(cash_amount)) AS amount
    FROM global_markets.stocks_dividends
    WHERE ticker = 'AGG'
      AND cash_amount > 0
      AND ex_dividend_date >= toDate('2023-07-01')
      AND ex_dividend_date <= toDate('2026-06-30')
    GROUP BY d
),
matched AS (
    SELECT paid.d AS ex_date,
           paid.amount AS amount,
           toFloat64(daily.session_close) AS px
    FROM paid
    INNER JOIN daily ON paid.d = daily.d
)
SELECT formatDateTime(ex_date, '%Y-%m-%d') AS date,
       formatDateTimeInJodaSyntax(ex_date, 'MMMM yyyy') AS date_label,
       round(px, 2) AS fund_price,
       round(100 * exp(sum(log(1 + amount / px))
             OVER (ORDER BY ex_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)), 3) AS shares_owned
FROM matched
ORDER BY ex_date