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)	AXISBANK	799.55	796.95	804.5	791.15	798.55	10776387	85996.97	179860	6622993	61.459999084472656
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AXISBANK	798.55	802.5	803.6	784.1	789.6	10939179	86738.48	175867	6690140	61.15999984741211
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AXISBANK	789.6	794	801	776.15	798.55	12300670	97402.31	185106	6858414	55.7599983215332
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AXISBANK	798.55	801	809.5	800.15	803.85	9399830	75693.17	194648	5590343	59.470001220703125
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AXISBANK	809.8	800.95	809.9	798.5	803.8	9717894	78191.12	125113	5439771	55.97999954223633
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AXISBANK	803.85	807.55	815.95	803.1	809.8	12848281	104110.43	197237	8084474	62.91999816894531
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AXISBANK	804.1	802.2	811.9	793.05	799.55	10802708	87004.43	144086	6456964	59.77000045776367
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AXISBANK	754.1	754.9	759.95	747.2	748.7	4917748	36972.21	80824	988375	20.1
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AXISBANK	748.7	750	759	747.6	756.95	5156046	38867.39	88337	1572942	30.51
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AXISBANK	756.95	753.15	756.25	740.5	742.95	8489729	63361.65	139161	3834757	45.17


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