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)	PRAJIND	438.05	440.3	443	427.55	430.35	1059703	4621.21	30124	482929	45.56999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRAJIND	430.35	430	438.9	420	422.8	919159	3947.34	30536	413840	45.02000045776367
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRAJIND	422.8	426.5	429.8	401	411.95	771444	3190.46	29645	413890	53.650001525878906
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRAJIND	411.95	419.7	423.1	393.05	406.35	1792263	7243.87	50651	865002	48.2599983215332
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRAJIND	395	392	407.9	385	385.2	983179	3870.34	27752	569612	57.93999862670898
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRAJIND	406.35	406.35	408.65	394	395	713146	2855.81	24044	410044	57.5
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRAJIND	422.1	425.95	448	412.65	438.05	2304446	10022.64	46074	909028	39.45000076293945
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PRAJIND	102.55	103	108.9	102.7	107.45	3444885	3676.94	23334	775380	22.51
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PRAJIND	107.45	107.9	114.3	106.35	112.2	5578822	6216.95	33951	1049452	18.81
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PRAJIND	112.2	111	113.9	110.4	111.3	1431943	1605.39	11692	405043	28.29


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