2000-Indian-stock-detials

everything about indian stocks

@kaggle.mukul0610_2000_indian_stock_detials

Table List

1 table(165.89 KB)

Indian Stock

@kaggle.mukul0610_2000_indian_stock_detials.indian_stock

165.89 KB
1977 rows
21 columns

sombol Sombol	market_cap Market Cap	enterprise_value Enterprise Value	no_of_shares No. Of Shares	p_e P/E	p_b P/B	face_value Face Value	div_yield Div. Yield	cash CASH	debt DEBT	promoter_holding Promoter Holding	sales_growth Sales Growth	roe ROE	roce ROCE	casa CASA %	net_interest_income Net Interest Income	cost_to_income Cost To Income %	car CAR %	advances Advances	operating_revenue Operating Revenue	net_profit Net Profit
RELIANCE	₹ 1651037.86 Cr.	₹ 1823886.86 Cr.	676.6 Cr.	38.15	3.43	₹ 10	0.33%	₹ 21714 Cr.	₹ 194563 Cr.	50.49%	72.47%	8.63%	8.21%		nan			nan	nan	nan
TCS	₹ 1281088.77 Cr.	₹ 1267396.77 Cr.	365.91 Cr.	32.76	13.55	₹ 1	1.23%	₹ 13692 Cr.	₹ 0 Cr.	72.30%	17.93%	50.76%	66.74%		nan			nan	nan	nan
HDFCBANK	₹ 923696.03 Cr.	nan	557.82 Cr.	21.93	3.45	₹ 1	0.94%	nan	nan	25.60%	nan	16.67%	14.62%	48.17	₹ 72009.59 Cr.	36.88	18.9	nan	nan	nan
INFY	₹ 656905.52 Cr.	₹ 644635.52 Cr.	414.77 Cr.	29.14	8.23	₹ 5	1.96%	₹ 12270 Cr.	₹ 0 Cr.	15.11%	20.98%	30.37%	40.65%		nan			nan	nan	nan
ICICIBANK	₹ 602207.21 Cr.	nan	698.09 Cr.	20.21	3.21	₹ 2	0.58%	nan	nan	0%	nan	14.99%	14.01%	48.7	₹ 47466.09 Cr.	40.52	19.16	nan	nan	nan
HINDUNILVR	₹ 591039.68 Cr.	₹ 587421.68 Cr.	234.96 Cr.	60.7	11.44	₹ 1	1.35%	₹ 3618 Cr.	₹ 0 Cr.	61.90%	11.30%	18.33%	24.61%		nan			nan	nan	nan
SBIN	₹ 473896.88 Cr.	nan	892.46 Cr.	11.11	1.59	₹ 1	1.34%	nan	nan	57.50%	nan	13.01%	8.27%	44.52	₹ 120707.59 Cr.	57.91	13.83	nan	nan	nan
HDFC	₹ 492713.65 Cr.	nan	182.92 Cr.	31.76	3.88	₹ 2	1.11%	nan	nan	0%	-0.4	12.17%	7.53%		nan			₹ 554862.51 Cr.	₹ 47957.43 Cr.	₹ 13742.18 Cr.
BHARTIARTL	₹ 463431.24 Cr.	₹ 566510.84 Cr.	596.59 Cr.		5.7	₹ 5	0.39%	₹ 328.5 Cr.	₹ 103408.1 Cr.	55.12%	9.82%	-4.64%	5.60%		nan			nan	nan	nan
ADANIENT	₹ 196387.99 Cr.	₹ 200124.61 Cr.	114 Cr.	139.43	14.55	₹ 1	0.06%	₹ 485.21 Cr.	₹ 4221.83 Cr.	72.63%	100.80%	15.39%	20.43%		nan			nan	nan	nan


CREATE TABLE indian_stock (
  "sombol" VARCHAR,
  "market_cap" VARCHAR,
  "enterprise_value" VARCHAR,
  "no_of_shares" VARCHAR,
  "p_e" DOUBLE,
  "p_b" DOUBLE,
  "face_value" VARCHAR,
  "div_yield" VARCHAR,
  "cash" VARCHAR,
  "debt" VARCHAR,
  "promoter_holding" VARCHAR,
  "sales_growth" VARCHAR,
  "roe" VARCHAR,
  "roce" VARCHAR,
  "casa" DOUBLE,
  "net_interest_income" VARCHAR,
  "cost_to_income" DOUBLE,
  "car" DOUBLE,
  "advances" VARCHAR,
  "operating_revenue" VARCHAR,
  "net_profit" VARCHAR
);