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)	TVSMOTOR	657.25	655	655	643.5	653	1376064	8940.72	33656	175902	12.779999732971191
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TVSMOTOR	653	653	653.25	628.6	636.95	1305798	8333.67	30117	236023	18.07999992370605
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TVSMOTOR	636.95	669	669	638.5	656.5	10100060	65853.28	174129	1699510	16.829999923706055
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TVSMOTOR	656.5	654	665.85	648.8	659.85	1943723	12810.91	44064	354784	18.25
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TVSMOTOR	668.45	659.9	673.15	640.6	660.45	6277578	41225.42	86209	1894527	30.18000030517578
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TVSMOTOR	659.85	668	677	665	668.45	3502156	23500.15	68055	548343	15.65999984741211
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TVSMOTOR	626.15	628	663	626.35	657.25	4972594	32588.11	105862	1152352	23.170000076293945
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TVSMOTOR	468.45	469.9	471.75	464.3	468.6	902225	4221.64	9860	233601	25.89
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TVSMOTOR	468.6	467.85	469.6	456	459.35	1474570	6813.08	31749	315543	21.4
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TVSMOTOR	459.35	457.95	457.95	447	452.6	1890542	8524.99	34091	413996	21.9


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