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)	EIHOTEL	147.4	147.9	147.9	139.3	140.65	1191572	1708.74	18955	563588	47.29999923706055
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EIHOTEL	140.65	141.05	146.65	141.05	142.15	453764	649.65	6529	192143	42.34000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EIHOTEL	142.15	142.8	142.85	137.6	138.95	184136	257.43	2567	93327	50.68000030517578
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EIHOTEL	138.95	139.65	140.65	134.85	137.35	283209	390.64	3354	102416	36.15999984741211
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EIHOTEL	136.5	136	136.6	132	134.15	468066	627.62	6994	264105	56.41999816894531
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EIHOTEL	137.35	137.65	139.7	136.05	136.5	178352	245.64	2662	69141	38.77000045776367
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EIHOTEL	142.4	143.3	148.35	140.2	147.4	1044681	1518.25	11979	631025	60.400001525878906
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EIHOTEL	142.65	143.45	145.5	142.65	143.55	89504	129.01	1382	46540	52
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EIHOTEL	143.55	145	145.5	142.65	144.95	56905	82.04	3159	29112	51.16
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EIHOTEL	144.95	144.9	145.25	142.1	143.5	57978	83.37	1745	29193	50.35


CREATE TABLE eihotel (
  "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
);