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)	LXCHEM	484.2	492	492.2	475.1	477.2	938245	4525.84	27662	385826	41.119998931884766
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LXCHEM	477.2	474	486.95	465.5	468.8	613295	2914.89	21545	260952	42.54999923706055
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LXCHEM	468.8	472.7	474.95	446.05	454	648411	2961.53	21308	228602	35.2599983215332
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LXCHEM	454	458.9	464	451	453.35	384850	1759.03	13132	163911	42.59000015258789
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LXCHEM	455.05	452	455	440.95	444.25	474290	2130.2	18598	206427	43.52000045776367
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LXCHEM	453.35	454.8	469.45	450.8	455.05	570957	2629.04	19227	189877	33.2599983215332
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LXCHEM	477.2	501.05	501.05	480.8	484.2	2635359	12957.75	60796	1150140	43.63999938964844
Thu Mar 25 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	LXCHEM	130	155.5	174.6	143.25	164.45	68702462	109919.07	854987	22535458	32.8
Fri Mar 26 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	LXCHEM	164.45	173.45	194.4	172	186.6	30116742	56166.53	365931	4667159	15.5
Tue Mar 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	LXCHEM	186.6	190.3	191.95	171.1	175.05	8839565	15736.91	131583	2761811	31.24


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