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)	LUPIN	900	887	899.95	859.4	872.2	7628986	66630.4	167718	2932747	38.43999862670898
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LUPIN	872.2	859	862.9	801.55	804.7	5308221	43533.55	148893	1725501	32.5099983215332
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LUPIN	804.7	804.75	810.85	784.45	787.6	3627659	28786.72	93780	1280912	35.310001373291016
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LUPIN	787.6	796	804.9	786.15	800.95	2378442	18892.2	63331	989305	41.59000015258789
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LUPIN	806.35	805.45	805.45	791.5	798.1	1279333	10195.68	39837	616187	48.15999984741211
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LUPIN	800.95	808.45	812	800	806.35	1583276	12745.85	46138	770484	48.65999984741211
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LUPIN	913.55	906	913.15	896	900	1420412	12815.83	55758	679861	47.86000061035156
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LUPIN	763.45	765.3	773.25	765.3	771.15	465429	3582.27	14055	45743	9.83
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LUPIN	771.15	773	780.35	764.2	775.6	867603	6709.03	16310	122187	14.08
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LUPIN	775.6	775.9	786.5	770	776.9	1110452	8655.09	21769	199755	17.99


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