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)	GILLETTE	5150.25	5179.9	5213.3	5110	5117.45	9820	504.15	2324	6351	64.66999816894531
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GILLETTE	5117.45	5149.95	5180	5060.05	5091	31891	1624.82	2826	28614	89.72000122070312
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GILLETTE	5091	5139.9	5140	5076.8	5109.4	7006	358.31	2132	3516	50.18999862670898
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GILLETTE	5109.4	5072.5	5144.95	5072.5	5102.85	3465	177.26	1057	1986	57.31999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GILLETTE	5089.75	5089.75	5136	5058.7	5085.7	7602	386.64	2131	5215	68.5999984741211
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GILLETTE	5102.85	5109.6	5135	5085	5089.75	4364	222.63	1185	2707	62.02999877929688
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GILLETTE	5295.3	5280	5280	5140.1	5150.25	25225	1305.17	6961	13982	55.43000030517578
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GILLETTE	6576.55	6576.55	6615	6555.1	6597.65	1764	116.28	657	1070	60.66
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GILLETTE	6597.65	6570.15	6621	6570.15	6587	2323	153.3	777	1553	66.85
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GILLETTE	6587	6587.05	6625	6550	6571.65	3646	240.12	1494	2509	68.82


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