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)	POLYCAB	2494.85	2490.1	2516.7	2475	2497.2	212422	5311.29	14315	88470	41.650001525878906
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYCAB	2497.2	2497.2	2506.1	2387	2401	279580	6814.85	28923	109389	39.130001068115234
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYCAB	2401	2400	2435	2323	2368.75	342707	8158.11	28336	99782	29.1200008392334
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYCAB	2368.75	2370.15	2448.75	2370.15	2440.8	247301	5976.76	17606	104417	42.220001220703125
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYCAB	2416.65	2410	2410	2350	2366.75	243601	5816.53	15140	118556	48.66999816894531
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYCAB	2440.8	2455	2458	2410	2416.65	129427	3134.46	9680	61043	47.15999984741211
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYCAB	2499.9	2504	2522.8	2481	2494.85	255814	6408.35	20859	109432	42.77999877929688
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYCAB	992.25	988.15	1009	988.15	993.9	107585	1074.14	4946	36262	33.71
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYCAB	993.9	994	994.4	975	977.05	106092	1040.49	5353	51365	48.42
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYCAB	977.05	978	993.8	971	982.25	208019	2044.46	7068	112535	54.1


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