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)	CANBK	264.9	265.45	268.8	259.2	261	11744286	30930.73	80318	1758487	14.970000267028809
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CANBK	261	261.5	266.65	256.85	258.1	15923437	41678.4	93717	2541361	15.960000038146973
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CANBK	258.1	258.5	263.45	251.8	260.7	15401072	39724.43	88320	1501430	9.75
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CANBK	260.7	261.8	263.1	255.25	260.25	9234499	23895.87	54536	1113392	12.0600004196167
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CANBK	258.8	257.1	261.05	250.2	251.5	8807436	22490.26	50572	1831956	20.799999237060547
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CANBK	260.25	260.55	262.9	256.8	258.8	8841159	22962.88	55386	1282784	14.510000228881836
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CANBK	269.65	268.7	272.8	264.1	264.9	16775296	45050.93	88987	4079226	24.31999969482422
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CANBK	221.35	222.1	223.35	219.8	221.65	4215881	9339.68	24499	193125	4.58
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CANBK	221.65	222.4	229.8	220.95	228.85	7033453	15881.71	35737	1188607	16.9
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CANBK	228.85	227.8	228.5	220.65	221.65	6646941	14853.07	35653	969064	14.58


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