每月赚一千美元股息需要多少本金

WITH px AS (
    SELECT ticker, argMax(close, window_start) AS price
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('JEPI', 'SPYD', 'VYM', 'SCHD', 'HDV', 'DVY', 'VIG', 'SPY', 'XLU', 'VNQ')
      AND window_start >= now() - INTERVAL 7 DAY
      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 ttm_div, count() AS payments
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('JEPI', 'SPYD', 'VYM', 'SCHD', 'HDV', 'DVY', 'VIG', 'SPY', 'XLU', 'VNQ')
      AND ex_dividend_date > today() - INTERVAL 1 YEAR
      AND ex_dividend_date <= today()
      AND cash_amount > 0
    GROUP BY ticker
)
SELECT px.ticker AS ticker,
       round(px.price, 2) AS price,
       dv.payments AS payments,
       round(dv.ttm_div / px.price * 100, 2) AS trailing_yield_pct,
       round(12000 / (dv.ttm_div / px.price) / 1000, 0) AS capital_thousands_usd
FROM px
INNER JOIN dv ON px.ticker = dv.ticker
ORDER BY trailing_yield_pct DESC

SELECT multiIf(dividend_yield * 100 >= 8, '8% and up',
               dividend_yield * 100 >= 5, '5-8%',
               dividend_yield * 100 >= 2.5, '2.5-5%',
               'under 2.5%') AS yield_band,
       count() AS payers,
       round(quantileDeterministic(0.5)(dividend_yield * 100, cityHash64(ticker)), 2) AS median_yield_pct,
       round(quantileDeterministicIf(0.5)(dividend_yield * price / earnings_per_share * 100,
                                          cityHash64(ticker), earnings_per_share > 0), 1) AS median_payout_ratio_pct,
       round(100 * countIf(earnings_per_share > 0 AND dividend_yield * price > earnings_per_share)
             / countIf(earnings_per_share > 0), 1) AS pct_paying_over_earnings
FROM global_markets.stocks_ratios
WHERE date = (SELECT max(date) FROM global_markets.stocks_ratios)
  AND price >= 5
  AND market_cap >= 1000000000
  AND dividend_yield > 0
  AND earnings_per_share IS NOT NULL
GROUP BY yield_band
HAVING countIf(earnings_per_share > 0) > 0
ORDER BY median_yield_pct

WITH px AS (
    SELECT toStartOfMonth(toDate(toTimeZone(window_start, 'America/New_York'))) AS month_start,
           argMax(close, window_start) AS price,
           max(toDate(toTimeZone(window_start, 'America/New_York'))) AS last_day
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'CAG'
      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 month_start
),
dv AS (
    SELECT ex_dividend_date, cash_amount
    FROM global_markets.stocks_dividends
    WHERE ticker = 'CAG'
      AND distribution_type = 'recurring'
      AND frequency = 4
      AND cash_amount > 0
      AND ex_dividend_date >= toDate('2022-06-01')
)
SELECT formatDateTime(px.month_start, '%Y-%m') AS month,
       formatDateTimeInJodaSyntax(px.month_start, 'MMMM yyyy') AS month_label,
       round(any(px.price), 2) AS price,
       round(argMax(dv.cash_amount, dv.ex_dividend_date), 2) AS quarterly_dividend_usd,
       round(argMax(dv.cash_amount, dv.ex_dividend_date) * 4 / any(px.price) * 100, 2) AS dividend_yield_pct
FROM px, dv
WHERE dv.ex_dividend_date <= px.last_day
GROUP BY px.month_start
ORDER BY px.month_start

SELECT toYear(ex_dividend_date) AS year,
       count() AS payments,
       round(sum(cash_amount), 3) AS distributions_per_share_usd
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
ORDER BY year