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)	ANURAS	1032.4	1038	1043.8	1016	1022.8	95566	983.06	11126	34059	35.63999938964844
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ANURAS	1022.8	1024.7	1024.75	1002.75	1008.35	87620	885.24	12023	36584	41.75
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ANURAS	1008.35	1014.75	1024.85	991.5	997.35	89353	894.84	7569	50675	56.709999084472656
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ANURAS	997.35	1005	1005	980.3	988.45	83922	830.47	5144	41755	49.75
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ANURAS	985.1	985	1000	960	970.75	63830	626.86	6443	28647	44.880001068115234
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ANURAS	988.45	995.9	995.9	980.3	985.1	61718	608.53	5821	24769	40.130001068115234
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ANURAS	1051.55	1061.25	1095	1027	1032.4	367773	3884.63	21071	152259	41.400001525878906
Wed Mar 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ANURAS	555	520	548.95	502.25	526.8	16135816	84945.5	430183	4594968	28.48
Thu Mar 25 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ANURAS	526.8	511.5	518.8	491	494.75	2119014	10688.33	91649	632389	29.84
Fri Mar 26 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ANURAS	494.75	502	510	491	495.7	925705	4625.64	45471	338374	36.55


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