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)	GMMPFAUDLR	5049.25	4870	4947.65	4767.2	4876.35	88063	4267.64	18905	39968	45.38999938964844
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GMMPFAUDLR	4876.35	4875	4988.35	4875	4899.3	33207	1639.75	11244	15929	47.970001220703125
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GMMPFAUDLR	4899.3	4912.15	4930	4766.6	4840.3	18668	903.33	6336	7951	42.59000015258789
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GMMPFAUDLR	4840.3	4889.1	4969.95	4822.35	4864.55	12259	599.81	4567	6345	51.7599983215332
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GMMPFAUDLR	4843.4	4772	4829.85	4740.1	4760.2	16136	770.95	5203	8550	52.9900016784668
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GMMPFAUDLR	4864.55	4875	4940.45	4815	4843.4	20290	987.98	7733	7500	36.959999084472656
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GMMPFAUDLR	5158.3	5184.1	5220	5016.75	5049.25	28564	1460.82	8810	13894	48.63999938964844
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GMMPFAUDLR	1871.55	1887.7	1895	1865.1	1874.45	6037	113.61	992	2895	47.95
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GMMPFAUDLR	1874.45	1887.6	1889.95	1843.65	1864.35	5809	108.62	987	3155	54.31
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GMMPFAUDLR	1864.35	1877.95	1877.95	1852	1865.95	5543	103.34	746	3649	65.83


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