monthly_payers

Name: monthly_payers
Creator: Strasmore
Published: 2026-09-25
License: https://www.strasmore.com/terms/

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-09-25, from us-dividend-frequency-for-russian-investors.

as of 2026-09-25 ranking 10×3read in context →

monthly_payers — 10 rows by 3 columns, computed 2026-09-25 from US exchange, SIP and OPRA data.
ticker	payouts_12m	cash_per_share_usd
BITO	12	3.208
HYG	12	4.738
TLT	12	3.89
LQD	12	5.016
ITUB	15	0.587
SGOV	12	3.712
USHY	12	2.546
BITX	13	2.667
GOVT	12	0.827
VTEB	12	1.703

Rows × columns: 10 × 3
Computed: 2026-09-25
Completeness: No missing values
Source: US exchange, SIP and OPRA market data
Licence: Strasmore terms · free, no signup
Formats: JSON · CSV · the SQL below

What each column holds

Column definitions for monthly_payers, derived from the stored result.
Column	Type	Range	Notes
`ticker`	text	10 distinct values (BITO, BITX, GOVT…)
`payouts_12m`	number	12 to 15
`cash_per_share_usd`	number	0.587 to 5.016	US dollars

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on 2026-09-25, and the query below is what returned them.

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 liquid AS
(
    SELECT
        ticker,
        avg(volume) AS adv
    FROM global_markets.stocks_daily_aggs
    WHERE date >= today() - 120
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker
    HAVING avg(volume) >= 1000000
       AND avg(close)  >= 5
),
divs AS
(
    SELECT
        d.ticker                AS ticker,
        d.id                    AS payment_id,
        any(d.ex_dividend_date) AS ex_date,
        any(d.cash_amount)      AS cash_amount
    FROM global_markets.stocks_dividends AS d
    WHERE d.ex_dividend_date >= today() - 365
      AND d.ex_dividend_date <  today()
      AND d.cash_amount > 0
    GROUP BY d.ticker, d.id
)
SELECT
    ticker,
    payouts_12m,
    cash_per_share_usd
FROM
(
    SELECT
        v.ticker                     AS ticker,
        any(l.adv)                   AS adv,
        countDistinct(v.ex_date)     AS payouts_12m,
        round(sum(v.cash_amount), 3) AS cash_per_share_usd
    FROM divs AS v
    INNER JOIN liquid AS l ON l.ticker = v.ticker
    GROUP BY v.ticker
    HAVING payouts_12m >= 12
)
ORDER BY adv DESC
LIMIT 10

SQL to run

WITH liquid AS
(
    SELECT
        ticker,
        avg(volume) AS adv
    FROM global_markets.stocks_daily_aggs
    WHERE date >= today() - 120
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker
    HAVING avg(volume) >= 1000000
       AND avg(close)  >= 5
),
divs AS
(
    SELECT
        d.ticker                AS ticker,
        d.id                    AS payment_id,
        any(d.ex_dividend_date) AS ex_date,
        any(d.cash_amount)      AS cash_amount
    FROM global_markets.stocks_dividends AS d
    WHERE d.ex_dividend_date >= today() - 365
      AND d.ex_dividend_date <  today()
      AND d.cash_amount > 0
    GROUP BY d.ticker, d.id
)
SELECT
    ticker,
    payouts_12m,
    cash_per_share_usd
FROM
(
    SELECT
        v.ticker                     AS ticker,
        any(l.adv)                   AS adv,
        countDistinct(v.ex_date)     AS payouts_12m,
        round(sum(v.cash_amount), 3) AS cash_per_share_usd
    FROM divs AS v
    INNER JOIN liquid AS l ON l.ticker = v.ticker
    GROUP BY v.ticker
    HAVING payouts_12m >= 12
)
ORDER BY adv DESC
LIMIT 10

⌘/Ctrl + Enter

Работайте с этими данными в своём ИИ-ассистенте

Открывается готовым к запросам, с данными этой страницы. Бесплатно, без аккаунта.

Claude ChatGPT Gemini Muse Свой агент