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)	SPARC	333.75	334.1	348.4	330	334.85	1539056	5215.53	24810	339393	22.049999237060547
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SPARC	334.85	336	338	324	325.7	642927	2114.56	12315	151244	23.520000457763672
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SPARC	325.7	325	329.9	316.4	322.15	645437	2081.15	10299	208955	32.369998931884766
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SPARC	322.15	323.1	328.8	321.6	324.35	411051	1337.2	7600	116868	28.43000030517578
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SPARC	324.5	324	324	317.05	319.25	220841	706.33	4338	90160	40.83000183105469
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SPARC	324.35	326	328.9	322.15	324.5	325343	1059.04	5634	102360	31.459999084472656
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SPARC	344.2	344	346.95	331.85	333.75	764083	2574.49	20724	246516	32.2599983215332
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SPARC	156.2	157.2	158.5	155.7	156.6	228579	358.6	2732	47259	20.68
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SPARC	156.6	156.95	164.25	155.2	160.45	958246	1536.01	9058	296124	30.9
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SPARC	160.45	161	168.3	160.2	164.45	1482391	2447.32	15529	368788	24.88


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