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)	GODREJAGRO	527.3	525	530.75	517	520.45	70090	366.57	3880	42871	61.16999816894531
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJAGRO	520.45	517	517.5	505	507.8	129246	658.26	6980	66745	51.63999938964844
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJAGRO	507.8	513.5	513.5	502	506.5	51990	263.25	3407	20501	39.43000030517578
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJAGRO	506.5	506.5	511	504.6	507.4	41671	211.29	2765	23232	55.75
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJAGRO	507	505	507.5	498.5	500.75	73322	367.27	4174	45782	62.43999862670898
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJAGRO	507.4	512	512	505	507	41216	209.12	2731	21032	51.02999877929688
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJAGRO	523.6	526.55	530	521.55	527.3	69276	364.81	3526	38004	54.86000061035156
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJAGRO	516.95	515.6	532.5	515.6	523.2	131972	691.69	5916	40068	30.36
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJAGRO	523.2	520	529	517	520.55	46665	244.24	2683	19296	41.35
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJAGRO	520.55	517	527.95	512.3	520.9	52250	272.31	3185	19847	37.98


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