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)	VEDL	345.3	345	362.75	343.6	356.35	20184671	72130.29	142578	6470988	32.060001373291016
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VEDL	356.35	358.15	371	355.95	365.35	15757583	57679.27	138193	4896186	31.06999969482422
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VEDL	365.35	368.25	374.8	359.3	369.45	14209893	52180.29	122367	3330208	23.440000534057617
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VEDL	369.45	371.5	378.95	364.2	376.65	17184515	63849.93	119706	5270310	30.670000076293945
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VEDL	379.5	378	384.45	372.25	378.05	9277013	35208.34	80100	2387710	25.739999771118164
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VEDL	376.65	378	385.85	375.5	379.5	11642228	44341.15	113044	2900539	24.90999984741211
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VEDL	343.25	335	351.8	329.15	345.3	15147036	52388.87	104492	5323338	35.13999938964844
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VEDL	152.45	152.8	155.15	151.45	154.6	14266524	21911.05	67844	3734478	26.18
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VEDL	154.6	155.3	159.85	155.3	159.45	17137897	27054.21	88006	3700905	21.59
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VEDL	159.45	158.4	160.9	156.7	157.75	12108687	19206.29	52394	1996014	16.48


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