raw_screen
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-10-06, from high-dividend-us-stocks-for-indian-investors.
| ticker | gross_yield_pct | price_change_12m_pct |
|---|---|---|
| BITU | 41.57 | -71.1 |
| BITI | 32.66 | -4.4 |
| IVR | 30.96 | -26.1 |
| PLTU | 29.15 | -43.8 |
| ORC | 26.03 | -29.5 |
| BITO | 21.41 | -40.6 |
| ARR | 21.14 | -11.6 |
| MUU | 18.96 | 1399.9 |
| DX | 18.72 | -12.7 |
| PDI | 18.41 | -27.6 |
| TU | 18.29 | -50.2 |
| FSK | 17.66 | -25.5 |
- Rows × columns
- 12 × 3
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
ticker |
text | 12 distinct values (ARR, BITI, BITO…) | |
gross_yield_pct |
number | 17.66 to 41.57 | percent |
price_change_12m_pct |
number | -71.1 to 1,399.9 | percent |
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 , 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.
SELECT
p.ticker AS ticker,
round(100 * d.div_ttm / p.last_close, 2) AS gross_yield_pct,
round(100 * (p.last_close / p.close_1y_ago - 1), 1) AS price_change_12m_pct
FROM
(
SELECT
ticker,
argMax(toFloat64(close), date) AS last_close,
argMin(toFloat64(close), date) AS close_1y_ago,
avg(volume) AS avg_vol,
count() AS sessions
FROM global_markets.stocks_daily_aggs
WHERE date >= today() - 370
AND ticker NOT IN ('SPCX')
GROUP BY ticker
HAVING avg_vol > 2000000
AND last_close > 5
AND sessions > 200
) AS p
INNER JOIN
(
SELECT
ticker,
sum(amt) AS div_ttm,
count() AS payments
FROM
(
SELECT
ticker,
ex_dividend_date,
max(toFloat64(cash_amount)) AS amt
FROM global_markets.stocks_dividends
WHERE ex_dividend_date >= today() - 365
AND ex_dividend_date <= today()
AND frequency IN (4, 12)
GROUP BY ticker, ex_dividend_date
)
GROUP BY ticker
HAVING payments >= 2
) AS d ON d.ticker = p.ticker
ORDER BY gross_yield_pct DESC
LIMIT 12
इस डेटा के साथ अपने AI असिस्टेंट में काम करें
इस पेज के डेटा के साथ, क्वेरी के लिए तैयार खुलता है। मुफ़्त, बिना अकाउंट।