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)	HONAUT	45915.35	45915.35	45915.35	44444	44677.85	5134	2318.35	3299	2199	42.83000183105469
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HONAUT	44677.85	44777	45199.75	44000.1	44992.15	3088	1377.63	1865	1073	34.75
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HONAUT	44992.15	45000	45469.45	44114.8	44493	3877	1729.5	2311	1709	44.08000183105469
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HONAUT	44493	44351	44782.4	44200.15	44332.8	1274	567.48	755	378	29.670000076293945
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HONAUT	44871.8	44601	45047.45	43289.8	43511.2	3750	1663.39	2084	1405	37.470001220703125
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HONAUT	44332.8	44687.2	45100.25	43917.5	44871.8	2943	1313.06	1565	647	21.979999542236328
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HONAUT	46086.1	46010	46250	45751	45915.35	2742	1259.94	1800	798	29.100000381469727
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HONAUT	27315.05	27350	27415.65	27050	27137.95	657	178.66	299	371	56.47
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HONAUT	27137.95	27289	27498.8	27015	27107.8	2060	559.95	458	1439	69.85
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HONAUT	27107.8	27022	27249.95	27021	27102.2	337	91.37	238	179	53.12


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