Nifty 500

Nifty 500 Index: Nifty Share Price, Live Chart, Nifty PE Ratio

@kaggle.willianoliveiragibin_nifty_500

Table List

1 table(61.78 KB)

Nifty 500 Quarterly Results New

@kaggle.willianoliveiragibin_nifty_500.nifty_500_quarterly_results_new

61.78 KB
501 rows
17 columns

name Name	nse_code NSE Code	bse_code BSE Code	sector Sector	industry Industry	revenue Revenue	operating_expenses Operating Expenses	operating_profit Operating Profit	operating_profit_margin Operating Profit Margin	depreciation Depreciation	interest Interest	profit_before_tax Profit Before Tax	tax Tax	net_profit Net Profit	eps EPS	profit_ttm Profit TTM	eps_ttm EPS TTM
3M India Ltd.	3MINDIA	523395	GENERAL INDUSTRIALS	INDUSTRIAL MACHINERY	1057	847.4	192.1	18.48%	12.9	0.7	195.9	49.8	146.1	129.7	535.9	475.7
ACC Ltd.	ACC	500410	CEMENT AND CONSTRUCTION	CEMENT & CEMENT PRODUCTS	4644.8	3885.4	549.3	12.39%	212.8	28.9	517.7	131.5	387.9	20.7	1202.7	64
AIA Engineering Ltd.	AIAENG	532683	GENERAL INDUSTRIALS	OTHER INDUSTRIAL GOODS	1357.1	912.7	382.1	29.51%	24.5	7.4	412.5	88.4	323.1	34.3	1216.1	128.9
APL Apollo Tubes Ltd.	APLAPOLLO	533758	METALS & MINING	IRON & STEEL PRODUCTS	465	4305.4	325	7.02%	41.3	26.6	276.7	73.8	202.9	7.3	767.5	27.7
Au Small Finance Bank Ltd.	AUBANK	540611	BANKING AND FINANCE	BANKS	2956.5	1026.7	647.7	25.59%		1282.1	533.4	131.5	401.8	6	1606.2	24
Adani Ports & Special Economic Zone Ltd.	ADANIPORTS	532921	TRANSPORTATION	MARINE PORT & SERVICES	6951.9	2982.4	3664	55.13%	974.5	520.1	2474.9	759	1747.8	8.1	6337	29.3
Adani Energy Solutions Ltd.	ADANIENSOL	ASM	UTILITIES	ELECTRIC UTILITIES	3766.5	2169.3	1504.6	40.95%	432.1	640.8	369.9	84.9	275.9	2.5	1315.1	11.8
Aditya Birla Fashion and Retail Ltd.	ABFRL	535755	RETAILING	DEPARTMENT STORES	3272.2	2903.6	322.9	10.01%	388.8	208.4	-228.6	-28.2	-179.2	-1.9	-491.7	-5.2
Aegis Logistics Ltd.	AEGISCHEM	500003	OIL & GAS	OIL MARKETING & DISTRIBUTION	1279.3	1026.5	208.3	16.87%	34.1	26.6	192	42	127	3.6	509	14.5
Ajanta Pharma Ltd.	AJANTPHARM	532331	PHARMACEUTICALS & BIOTECHNOLOGY	PHARMACEUTICALS	1049.8	737.8	290.7	28.26%	33.7	2.3	275.9	80.6	195.3	15.5	660.2	52.3


CREATE TABLE nifty_500_quarterly_results_new (
  "name" VARCHAR,
  "nse_code" VARCHAR,
  "bse_code" VARCHAR,
  "sector" VARCHAR,
  "industry" VARCHAR,
  "revenue" DOUBLE,
  "operating_expenses" DOUBLE,
  "operating_profit" DOUBLE,
  "operating_profit_margin" VARCHAR,
  "depreciation" DOUBLE,
  "interest" DOUBLE,
  "profit_before_tax" DOUBLE,
  "tax" DOUBLE,
  "net_profit" DOUBLE,
  "eps" DOUBLE,
  "profit_ttm" DOUBLE,
  "eps_ttm" DOUBLE
);