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)	MINDTREE	3913.1	3903.1	3988	3828.45	3965.85	606538	23894.92	44580	74341	12.260000228881836
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDTREE	3965.85	3965	4025	3850.85	3870.05	452237	17700.66	40065	95549	21.1299991607666
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDTREE	3870.05	3910	3956.4	3821.2	3884.5	528879	20573.24	40578	84398	15.960000038146973
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDTREE	3884.5	3930	4021.95	3922.05	3993.3	605069	24135.14	48169	194176	32.09000015258789
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDTREE	4029.55	3930	3980	3831	3869.65	860200	33340.27	68270	350639	40.7599983215332
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDTREE	3993.3	4024	4041.65	3965.05	4029.55	377038	15119.84	37112	108177	28.690000534057617
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDTREE	4066.1	4027	4044	3895.4	3913.1	608593	24111.74	52035	158866	26.100000381469727
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDTREE	800.15	801	815	795.5	811.75	848083	6873.4	13208	100475	11.85
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDTREE	811.75	815.5	819.5	800.2	813.75	1015807	8219.6	21690	164544	16.2
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDTREE	813.75	811.95	823.25	804.55	815.55	784180	6411.52	14106	99779	12.72


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