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)	SONACOMS	686.45	688	689.5	667.8	682.05	895020	6090.03	26101	272732	30.46999931335449
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SONACOMS	682.05	680.95	683.7	655	659.85	846598	5638.09	31971	334680	39.52999877929688
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SONACOMS	659.85	668.25	671.7	622.05	625.4	1824482	11543.94	78135	907053	49.720001220703125
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SONACOMS	625.4	635.5	650	627.7	648.05	995602	6370.8	42793	308943	31.030000686645508
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SONACOMS	643.05	632	637.9	627.5	631.75	658919	4163.82	25937	243572	36.970001220703125
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SONACOMS	648.05	651.7	655.7	637.2	643.05	447740	2891.86	13555	143005	31.940000534057617
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SONACOMS	675.65	680.5	699.5	670.3	686.45	1969604	13488.4	43037	786742	39.93999862670898
Thu Jun 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	SONACOMS	291	301	361.2	295	361.2	41848082	138782.61	453287	18692430	44.67
Fri Jun 25 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	SONACOMS	361.2	387.9	413.9	355.45	364.7	30784367	118143.01	478191	11092382	36.03
Mon Jun 28 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	SONACOMS	364.7	357	361.7	337.3	347.5	5967165	20946.83	217419	2456828	41.17


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