תשואת דיבידנד טובה 2026

WITH payers AS (
    SELECT ticker,
           argMax(dividend_yield, date) * 100 AS yield_pct
    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
    GROUP BY ticker
),
banded AS (
    SELECT multiIf(yield_pct < 1, 'under 1%',
                   yield_pct < 2, '1 to 2%',
                   yield_pct < 3, '2 to 3%',
                   yield_pct < 4, '3 to 4%',
                   yield_pct < 6, '4 to 6%',
                   yield_pct < 8, '6 to 8%',
                   '8% and up') AS yield_band,
           min(yield_pct) AS band_floor,
           count() AS company_count
    FROM payers
    GROUP BY yield_band
)
SELECT yield_band,
       company_count,
       round(100 * company_count / sum(company_count) OVER (), 1) AS pct_of_payers,
       round(100 * sum(company_count) OVER (ORDER BY band_floor) / sum(company_count) OVER (), 1) AS cumulative_pct
FROM banded
ORDER BY band_floor

WITH px AS (
    SELECT ticker,
           argMax(close, window_start) AS price
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('XLU','XLRE','XLP','XLE','XLF','XLV','XLB','XLI','XLC','XLY','XLK')
      AND window_start >= toDateTime('2026-07-20 00:00:00')
      AND window_start < toDateTime('2026-07-31 00:00:00')
      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_distributions
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('XLU','XLRE','XLP','XLE','XLF','XLV','XLB','XLI','XLC','XLY','XLK')
      AND cash_amount > 0
      AND ex_dividend_date > toDate('2025-07-30')
      AND ex_dividend_date <= toDate('2026-07-30')
    GROUP BY ticker
)
SELECT transform(px.ticker,
                 ['XLU','XLRE','XLP','XLE','XLF','XLV','XLB','XLI','XLC','XLY','XLK'],
                 ['Utilities','Real estate','Consumer staples','Energy','Financials',
                  'Health care','Materials','Industrials','Communications',
                  'Consumer discretionary','Technology'],
                 'Other') AS sector,
       px.ticker AS fund_ticker,
       round(dv.ttm_distributions, 3) AS annual_distributions_usd,
       round(dv.ttm_distributions / px.price * 100, 2) AS trailing_yield_pct
FROM px
INNER JOIN dv ON px.ticker = dv.ticker
ORDER BY trailing_yield_pct DESC

WITH px AS (
    SELECT ticker,
           argMax(close, window_start) AS price
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('MSFT','MCD','HD','PG','KO','JNJ','XOM','CVX','VZ','MO')
      AND window_start >= toDateTime('2026-07-20 00:00:00')
      AND window_start < toDateTime('2026-07-31 00:00:00')
      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,
           sumIf(cash_amount, ex_dividend_date > toDate('2025-07-30')
                          AND ex_dividend_date <= toDate('2026-07-30')) AS ttm_now,
           sumIf(cash_amount, ex_dividend_date > toDate('2020-07-30')
                          AND ex_dividend_date <= toDate('2021-07-30')) AS ttm_five_years_ago
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('MSFT','MCD','HD','PG','KO','JNJ','XOM','CVX','VZ','MO')
      AND distribution_type = 'recurring'
      AND cash_amount > 0
      AND ((ex_dividend_date > toDate('2020-07-30') AND ex_dividend_date <= toDate('2021-07-30'))
        OR (ex_dividend_date > toDate('2025-07-30') AND ex_dividend_date <= toDate('2026-07-30')))
    GROUP BY ticker
)
SELECT px.ticker AS symbol,
       round(dv.ttm_now / px.price * 100, 2) AS current_yield_pct,
       round(100 * (dv.ttm_now / dv.ttm_five_years_ago - 1), 1) AS five_year_dividend_growth_pct,
       round(dv.ttm_now, 2) AS dividends_per_share_ttm
FROM px
INNER JOIN dv ON px.ticker = dv.ticker
WHERE dv.ttm_five_years_ago > 0
  AND dv.ttm_now > 0
ORDER BY current_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 = 'INTC'
      AND toDate(toTimeZone(window_start, 'America/New_York')) >= toDate('2021-01-01')
      AND toDate(toTimeZone(window_start, 'America/New_York')) <= toDate('2024-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 = 'INTC'
      AND distribution_type = 'recurring'
      AND frequency = 4
      AND cash_amount > 0
      AND ex_dividend_date >= toDate('2020-01-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), 4) 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 formatDateTime(toStartOfMonth(date), '%Y-%m') AS month,
       formatDateTimeInJodaSyntax(toStartOfMonth(date), 'MMMM yyyy') AS month_label,
       round(argMax(yield_10_year, date), 2) AS treasury_10y_pct
FROM global_markets.treasury_yields
WHERE date >= toDate('2021-07-01')
  AND date <= toDate('2026-07-30')
  AND yield_10_year IS NOT NULL
GROUP BY toStartOfMonth(date)
ORDER BY toStartOfMonth(date)