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)	ASTRAL	2184.25	2171	2199	2139.5	2180.6	334860	7293.49	31898	116586	34.81999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTRAL	2180.6	2160	2178.3	2071	2110	392740	8306.66	41100	157650	40.13999938964844
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTRAL	2110	2081.15	2134.75	2075	2120.15	342518	7206.12	35716	146264	42.70000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTRAL	2120.15	2120.15	2155	2100.85	2134.45	395723	8409.61	41303	224741	56.790000915527344
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTRAL	2122.95	2111.55	2111.55	2060	2073.85	361675	7544.51	31338	219521	60.70000076293945
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTRAL	2134.45	2150.5	2160	2103.15	2122.95	288130	6110.37	22557	165879	57.56999969482422
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTRAL	2220.1	2235	2235	2170.05	2184.25	355057	7801.71	24760	175666	49.47999954223633
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTRAL	1176.9	1175.5	1178.5	1156	1166.85	12034	140.59	1092	4633	38.5
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTRAL	1166.85	1161.1	1178.95	1152.55	1158.45	34737	403.11	4165	17952	51.68
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTRAL	1158.45	1160	1170.3	1145	1149.1	38292	440.76	6314	24240	63.3


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