inr_income
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 | div_inr_per_share | net_inr_per_share | net_inr_per_100_shares |
|---|---|---|---|
| CVX | 620.4 | 465.3 | 46530 |
| ABBV | 601 | 450.8 | 45078 |
| IBM | 593.1 | 444.8 | 44484 |
| PEP | 510.8 | 383.1 | 38313 |
| JNJ | 464.6 | 348.5 | 34848 |
| PG | 377.6 | 283.2 | 28318 |
| MO | 377.5 | 283.1 | 28314 |
| XOM | 362.6 | 271.9 | 27192 |
| VZ | 246 | 184.5 | 18447 |
| KO | 184.8 | 138.6 | 13860 |
| CSCO | 147 | 110.2 | 11022 |
| T | 97.7 | 73.3 | 7326 |
- Rows × columns
- 12 × 4
- 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 (ABBV, CSCO, CVX…) | |
div_inr_per_share |
number | 97.7 to 620.4 | |
net_inr_per_share |
number | 73.3 to 465.3 | |
net_inr_per_100_shares |
number | 7,326 to 46,530 | count |
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.
WITH 88.0 AS usd_inr
SELECT
p.ticker AS ticker,
round(d.div_ttm * usd_inr, 1) AS div_inr_per_share,
round(0.75 * d.div_ttm * usd_inr, 1) AS net_inr_per_share,
round(0.75 * d.div_ttm * usd_inr * 100) AS net_inr_per_100_shares
FROM
(
SELECT
ticker,
argMax(toFloat64(close), date) AS last_close
FROM global_markets.stocks_daily_aggs
WHERE ticker IN ('ABBV','CSCO','CVX','IBM','JNJ','KO','MO','PEP','PG','T','VZ','XOM')
AND date >= today() - 30
GROUP BY ticker
) AS p
INNER JOIN
(
SELECT
ticker,
sum(amt) AS div_ttm
FROM
(
SELECT
ticker,
ex_dividend_date,
max(toFloat64(cash_amount)) AS amt
FROM global_markets.stocks_dividends
WHERE ticker IN ('ABBV','CSCO','CVX','IBM','JNJ','KO','MO','PEP','PG','T','VZ','XOM')
AND ex_dividend_date >= today() - 365
AND ex_dividend_date <= today()
AND frequency IN (4, 12)
GROUP BY ticker, ex_dividend_date
)
GROUP BY ticker
) AS d ON d.ticker = p.ticker
ORDER BY net_inr_per_100_shares DESC
इस डेटा के साथ अपने AI असिस्टेंट में काम करें
इस पेज के डेटा के साथ, क्वेरी के लिए तैयार खुलता है। मुफ़्त, बिना अकाउंट।