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)	SFL	3250.8	3250.9	3328.8	3210.25	3312.85	10250	337.31	2910	3792	37
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SFL	3312.85	3349	3355	3253	3275.45	7403	244.67	2532	2919	39.43000030517578
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SFL	3275.45	3275.45	3360	3235.25	3304	8606	283.88	2925	3226	37.4900016784668
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SFL	3304	3320.55	3398	3294.8	3345.4	4471	149.63	1613	2092	46.790000915527344
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SFL	3325	3255	3279.35	3228.45	3239.35	14959	485.97	5682	9413	62.93000030517578
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SFL	3345.4	3340.05	3379.35	3310	3325	5640	187.93	2595	2010	35.63999938964844
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SFL	3403.8	3351.05	3360	3209	3250.8	46787	1522.2	8088	20078	42.90999984741211
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SFL	1266.5	1261.25	1318.5	1260.3	1304.15	2850	36.98	385	1662	58.32
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SFL	1304.15	1309.25	1324.45	1290	1298.35	2854	37.27	467	1729	60.58
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SFL	1298.35	1298	1339.55	1283.5	1321.5	1496	19.62	320	745	49.8


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