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)	CHOLAFIN	642.75	645.25	680	643.55	675.7	4779062	31743.74	104919	1380860	28.88999938964844
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHOLAFIN	675.7	682	682	646.85	650.1	4384201	29207.51	72260	1386179	31.6200008392334
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHOLAFIN	650.1	645	667.35	644.25	657.5	2630525	17295.22	52725	573652	21.809999465942383
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHOLAFIN	657.5	664	684.4	660.5	682.95	2574872	17388.07	52070	798991	31.030000686645508
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHOLAFIN	690.75	680	692	673.65	680.35	2487787	16983.05	36059	694502	27.920000076293945
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHOLAFIN	682.95	685	698.35	673.6	690.75	4068283	28021.22	64827	1414820	34.779998779296875
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHOLAFIN	639.2	639.2	645.5	630	642.75	2271472	14513.73	95715	1005343	44.2599983215332
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHOLAFIN	305.5	306.65	308	302.1	302.85	357891	1090.76	6842	97727	27.31
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHOLAFIN	302.85	304.25	309.9	301.5	309.2	1409338	4329.95	17640	385570	27.36
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHOLAFIN	309.2	310.5	310.5	299.35	303.05	1026261	3122.99	14580	337010	32.84


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