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)	INDOCO	391.8	393.6	394.85	382.5	384.55	191361	740.85	6863	123133	64.3499984741211
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDOCO	384.55	381	386.5	376.8	377.75	118200	450.25	5171	62973	53.27999877929688
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDOCO	377.75	377	381.75	365	367.8	155538	578.52	8422	88308	56.77999877929688
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDOCO	367.8	369.7	375.45	367.35	368.9	99774	371.05	3136	63335	63.47999954223633
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDOCO	377.7	372	377.95	366.25	367.6	115907	432.65	7740	42924	37.02999877929688
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDOCO	368.9	378.4	379.85	371.4	377.7	102957	386.45	6692	28556	27.739999771118164
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDOCO	397.7	401.9	406	390.85	391.8	128117	508.13	5179	81340	63.4900016784668
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INDOCO	191.55	192.8	193.7	187	188.55	38702	73.73	1309	15440	39.89
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INDOCO	188.55	189.7	190.5	184.05	185.2	26333	48.97	838	11783	44.75
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INDOCO	185.2	185.6	188.7	184	185.05	22267	41.44	775	8213	36.88


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