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)	RALLIS	253	253.3	254.9	250.5	251.65	270722	682.55	6373	177057	65.4000015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RALLIS	251.65	251.7	255	247.1	253.3	526752	1312.54	8866	368277	69.91000366210938
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RALLIS	253.3	253.95	255	249	249.8	223976	563.04	4897	94536	42.209999084472656
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RALLIS	249.8	250	254	249.05	249.65	183788	460.7	4114	78207	42.54999923706055
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RALLIS	253.3	252	252.65	248	248.6	322071	806.71	5250	198686	61.68999862670898
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RALLIS	249.65	250	254	248.5	253.3	237760	596.9	5931	116906	49.16999816894531
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RALLIS	257.9	258.3	258.9	252.35	253	339007	865.7	8250	183339	54.08000183105469
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RALLIS	168.2	169	176.5	168.6	174.75	135105	233.5	2782	77728	57.53
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RALLIS	174.75	175.15	181.7	175.15	179.25	346286	619.78	13465	158380	45.74
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RALLIS	179.25	177	183.3	176.25	180.45	302527	547.06	10107	129513	42.81


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