Top Indian Stocks Dataset

Comprehensive Dataset of Key Financial Metrics for the Top 1000 Indian Stocks

@kaggle.forgetabhi_top_1000_stocks

Table List

1 table(123.21 KB)

Top1kstocks

@kaggle.forgetabhi_top_1000_stocks.top1kstocks

123.21 KB
1574 rows
12 columns

unnamed_0 Unnamed: 0	name Name	cmp Cmp	p_e P/e	mar_cap Mar Cap	div_yld Div Yld %	np_qtr Np Qtr	qtr_profit Qtr Profit %	sales_qtr Sales Qtr	qtr_saeles Qtr Saeles %	roce Roce %	pat_ann Pat Ann
1	Reliance Industr	2961.4	28.75	2003965.01	0.3	21243	-1.34	236533	11.13	10.02	69621
2	TCS	3814.75	29.73	1380210.04	1.45	12502	9.15	61237	3.51	64.28	46598.19
3	HDFC Bank	1608.75	19.07	1223559.58	1.22	18012.87	39.92	79433.61	67.06	9.5	64062.04
4	Bharti Airtel	1428.7	71.63	853241.05	0.27	2068.2	29.63	37599.1	4.42	13.13	11911.52
5	ICICI Bank	1123.05	17.89	789893.47	0.72	12200.05	18.46	42606.72	23.72	8.37	44256.37
6	St Bk of India	844.6	11.09	753772.79	1.61	22202.73	18.18	117469.38	19.77	6.16	67102.23
7	Life Insurance	1056.1	16.27	667983.02	0.93	13784.08	4.49	238968.3	18.75	66.35	40884.77
8	Infosys	1497.65	23.92	621808.55	2.51	7975	30.04	37923	1.29	39.99	26025.25
9	Hind. Unilever	2485	56.87	583991.14	1.69	2561	-1.59	15210	-0.03	27.24	10272.57
10	ITC	428.8	26.13	535406.98	3.2	5190.71	0.02	17922.7	1.63	37.46	20464.49


CREATE TABLE top1kstocks (
  "unnamed_0" BIGINT,
  "name" VARCHAR,
  "cmp" DOUBLE,
  "p_e" DOUBLE,
  "mar_cap" DOUBLE,
  "div_yld" DOUBLE,
  "np_qtr" DOUBLE,
  "qtr_profit" DOUBLE,
  "sales_qtr" DOUBLE,
  "qtr_saeles" DOUBLE,
  "roce" DOUBLE,
  "pat_ann" DOUBLE
);