NIFTY ALL STOCK Dataset

date Date	symbol Symbol	pre_close Pre Close	open Open	high High	low Low	close Close	volume Volume	turnover_lacs Turnover Lacs	no_of_trades No Of Trades	deliv_volume Deliv Volume	deliv Deliv %
Fri Feb 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MHRIL	205.8	206	210.8	202	202.85	399316	823.85	7520	182169	45.619998931884766
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MHRIL	202.85	202.75	207	201.5	203.8	277891	566.97	6064	158024	56.869998931884766
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MHRIL	203.8	205	207.3	199.5	206.05	470245	958.85	8162	240720	51.18999862670898
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MHRIL	206.05	207.1	208.1	204.8	206.55	101432	209.44	2666	59444	58.59999847412109
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MHRIL	203.45	204.8	208.05	201.5	206.05	170959	350.66	3850	70780	41.400001525878906
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MHRIL	206.55	207.6	207.6	201.25	203.45	165353	338.08	3950	93700	56.66999816894531
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MHRIL	215.05	218	220.7	204.2	205.8	857496	1834.36	19449	267340	31.18000030517578
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MHRIL	227.3	228.85	229	224.6	227.7	6303	14.31	354	3908	62
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MHRIL	227.7	226.65	234.8	226.65	233.75	36472	85.01	1050	25085	68.78
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MHRIL	233.75	233	234.5	228.35	232	22953	53.09	647	16608	72.36


CREATE TABLE mhril (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE
);