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)	AMBUJACEM	381.9	383	384.9	378	380.4	5637748	21569.1	75719	3959499	70.2300033569336
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AMBUJACEM	380.4	380	383.9	374.2	382.65	2535377	9626.38	65673	1201421	47.38999938964844
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AMBUJACEM	382.65	383	386.1	373.25	376.3	2089451	7910.53	27285	812498	38.88999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AMBUJACEM	376.3	379.35	385.9	376.85	382.8	2140597	8182.91	33325	1237125	57.790000915527344
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AMBUJACEM	374.85	375	375.85	366.6	367.9	2050063	7591.57	38304	770306	37.56999969482422
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AMBUJACEM	382.8	381.75	384.4	373.4	374.85	4638095	17459.4	63320	2884561	62.18999862670898
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AMBUJACEM	380	377.3	384.3	377.3	381.9	3772405	14427.99	56782	2716845	72.0199966430664
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AMBUJACEM	196.25	197.2	197.75	195.8	197	1459556	2874.55	9803	573653	39.3
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AMBUJACEM	197	197.35	206.4	197.2	205.35	8633553	17655.24	52407	3116407	36.1
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AMBUJACEM	205.35	204.95	205.8	202.25	203.4	2007973	4091.78	14470	823023	40.99


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