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)	GRAPHITE	535.75	538.4	554	531.05	539.1	1253197	6803.65	28226	263312	21.01000022888184
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRAPHITE	539.1	539.1	542.55	518.15	523.1	670872	3548.48	16236	205099	30.56999969482422
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRAPHITE	523.1	525.65	538.15	507	530.65	1354117	7121.03	35064	215942	15.949999809265137
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRAPHITE	530.65	533.35	535.45	520.1	525.5	668030	3530.27	19494	197220	29.520000457763672
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRAPHITE	529.5	529.5	529.5	511.1	515.45	717993	3731.01	16182	244243	34.02000045776367
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRAPHITE	525.5	528.7	543	523.3	529.5	1306449	6996.31	28424	256222	19.61000061035156
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRAPHITE	545.15	545	545	532.2	535.75	798778	4298.94	19094	184105	23.049999237060547
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GRAPHITE	303.25	303.7	310.7	302.15	306.5	1127394	3459.14	14438	198276	17.59
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GRAPHITE	306.5	307.35	314.65	306.65	310.55	2172895	6750.15	26258	644487	29.66
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GRAPHITE	310.55	309	318.9	308.2	309.2	3316089	10412.17	40492	765786	23.09


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