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)	VIPIND	648.05	647.3	665.55	641.5	648.2	711852	4642.25	38724	172436	24.21999931335449
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VIPIND	648.2	649.6	696	643.4	670.85	2290935	15547.45	84998	472601	20.6299991607666
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VIPIND	670.85	669.9	673.6	644	660.1	472553	3107	24026	103944	22
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VIPIND	660.1	664	672.85	655.6	664.15	461221	3062.71	22703	190859	41.380001068115234
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VIPIND	648.95	650	686.6	644.65	669.55	899521	6034.94	32752	226083	25.1299991607666
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VIPIND	664.15	666	688.7	644	648.95	752331	5010.39	36349	264160	35.11000061035156
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VIPIND	676.55	667	677.65	640	648.05	1674858	10978.58	62060	387826	23.15999984741211
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VIPIND	431.65	434.6	436.5	425.05	429.05	83024	358.65	3261	34724	41.82
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VIPIND	429.05	427	438	425.1	429.95	265949	1155.52	6353	175545	66.01
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VIPIND	429.95	438	443.7	435.3	440.15	518924	2283.84	17610	193882	37.36


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