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)	VALIANTORG	1168.4	1174.65	1180.25	1144	1162.3	31034	361.46	4902	15601	50.27000045776367
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VALIANTORG	1162.3	1169.8	1174	1112	1127.2	47335	541.57	7466	21033	44.43000030517578
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VALIANTORG	1127.2	1135	1156.6	1090	1110.75	33932	377.96	5910	16178	47.68000030517578
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VALIANTORG	1110.75	1120	1132.05	1087	1094.55	35351	392.97	5955	17650	49.93000030517578
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VALIANTORG	1070.4	1060	1074.35	1012.1	1017.2	50547	525.96	6490	26447	52.31999969482422
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VALIANTORG	1094.55	1080.3	1098.8	1065.4	1070.4	42745	464.78	6898	13158	30.780000686645508
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VALIANTORG	1139.95	1137.85	1195	1105.35	1168.4	65194	754.49	10029	28801	44.18000030517578
Mon Oct 05 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VALIANTORG	2876	2973	3131	2910	2948.5	4233	124.99	801	2432	57.45
Tue Oct 06 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VALIANTORG	2948.5	2970	3010	2875.05	2969.7	4409	130.95	1013	2722	61.74
Wed Oct 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VALIANTORG	2969.7	2974.65	2995	2877	2912.95	3807	112.3	753	2736	71.87


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