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)	GALAXYSURF	3230.95	3225	3247.15	3156.35	3186.1	14188	453.95	6115	6877	48.470001220703125
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GALAXYSURF	3186.1	3155.1	3210	3122.75	3165	11299	356.21	5448	5479	48.4900016784668
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GALAXYSURF	3165	3180.25	3206.65	3053	3061.9	17394	541.48	7235	8311	47.77999877929688
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GALAXYSURF	3061.9	3050.05	3077.25	2971.05	2996.25	26788	803.14	6485	16289	60.810001373291016
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GALAXYSURF	2956.5	2936.5	2955.55	2890	2899.9	13512	393.72	5118	6744	49.90999984741211
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GALAXYSURF	2996.25	2994	3009.9	2910	2956.5	22986	676.69	8027	11993	52.18000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GALAXYSURF	3228.05	3275	3275	3195	3230.95	12911	417.12	5511	6847	53.02999877929688
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GALAXYSURF	1500	1510	1511.1	1481.9	1490.55	3721	55.51	546	2483	66.73
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GALAXYSURF	1490.55	1500	1515.55	1460	1466.5	58180	858.57	1553	55008	94.55
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GALAXYSURF	1466.5	1463	1545	1463	1506.35	46452	706.24	6258	23657	50.93


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