payout_change

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

WITH monthly AS (
    SELECT
        ticker,
        ex_dividend_date,
        max(cash_amount) AS amount
    FROM global_markets.stocks_dividends
    WHERE ex_dividend_date >= addMonths(toStartOfMonth(today()), -24)
      AND ex_dividend_date <  toStartOfMonth(today())
      AND currency = 'USD'
      AND cash_amount > 0
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker, ex_dividend_date
),
stable AS (
    SELECT
        ticker,
        round(toFloat64(argMin(amount, ex_dividend_date)), 4) AS first_payment_usd,
        round(toFloat64(argMax(amount, ex_dividend_date)), 4) AS last_payment_usd,
        round(100 * (toFloat64(argMax(amount, ex_dividend_date))
                     / toFloat64(argMin(amount, ex_dividend_date)) - 1), 1) AS change_pct
    FROM monthly
    GROUP BY ticker
    HAVING count() = 24
       AND countDistinct(toStartOfMonth(ex_dividend_date)) = 24
),
priced AS (
    SELECT
        ticker,
        toFloat64(argMax(close, date)) AS last_close
    FROM global_markets.stocks_daily_aggs
    WHERE date >= today() - 30
      AND ticker IN (SELECT ticker FROM stable)
    GROUP BY ticker
)
SELECT
    s.ticker            AS ticker,
    s.first_payment_usd AS first_payment_usd,
    s.last_payment_usd  AS last_payment_usd,
    s.change_pct        AS change_pct
FROM stable AS s
INNER JOIN priced AS x ON x.ticker = s.ticker
WHERE x.last_close >= 5
ORDER BY s.change_pct
LIMIT 14