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)	MINDAIND	1083.1	1075	1081.85	1051.25	1060.1	206684	2194.09	23891	83813	40.54999923706055
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDAIND	1060.1	1060	1145	1047	1112.4	861393	9397.26	55695	184636	21.43000030517578
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDAIND	1112.4	1105	1105.4	1011.2	1026.35	1054087	10879.01	56360	400970	38.040000915527344
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDAIND	1026.35	1037.3	1069	1031.15	1058	442172	4681.75	24756	195262	44.15999984741211
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDAIND	1054.95	1044	1044	995	1003	393789	3988.57	28810	187226	47.540000915527344
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDAIND	1058	1065	1067.55	1041.35	1054.95	169754	1796.67	10729	68554	40.380001068115234
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDAIND	1108.95	1112.05	1113.45	1070	1083.1	214109	2322.3	16237	85348	39.86000061035156
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDAIND	351.85	356	360	350.1	358.05	55555	197.96	4107	18225	32.81
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDAIND	358.05	359.9	364.9	354.9	361.4	94186	338.34	2829	62863	66.74
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MINDAIND	361.4	360	375	353.1	365.65	269267	981.53	11726	133611	49.62


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