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)	TATACOMM	1303.5	1296	1320.9	1288	1311.75	461335	6029.39	20534	205723	44.59000015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACOMM	1311.75	1316.5	1316.5	1268	1275.9	358386	4607.62	20200	149036	41.59000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACOMM	1275.9	1272.25	1302	1255.55	1268.55	532828	6815.54	23598	211309	39.65999984741211
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACOMM	1268.55	1279.8	1293.7	1272.2	1284.35	201937	2593.58	9353	83856	41.52999877929688
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACOMM	1307	1304	1304	1250	1254.9	310184	3944.32	16498	163023	52.560001373291016
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACOMM	1284.35	1290.15	1312	1278	1307	342830	4449.26	10643	149131	43.5
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACOMM	1312.35	1318.9	1328.7	1292	1303.5	563851	7395.49	19657	297916	52.84000015258789
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACOMM	396.95	397.3	404	393.05	399.35	38131	151.84	1325	10007	26.24
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACOMM	399.35	400.95	411	399.6	404.75	166789	677.56	4950	45771	27.44
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACOMM	404.75	404.5	425	398.3	420.75	248117	1031.93	16974	95975	38.68


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