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)	SOBHA	868.15	866.9	874.7	851.25	857	147811	1277.3	8210	41220	27.88999938964844
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SOBHA	857	854.9	875.05	845.9	867.5	234024	2019.04	12540	64497	27.559999465942383
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SOBHA	867.5	867	890	852	882.15	180785	1569.62	11198	58937	32.599998474121094
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SOBHA	882.15	894.9	894.9	859	866.05	99453	870.38	6103	34495	34.68000030517578
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SOBHA	874.9	857	875	845.6	850.25	110531	949.91	7384	45544	41.20000076293945
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SOBHA	866.05	871.5	885	865.1	874.9	105321	923.61	6389	27609	26.209999084472656
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SOBHA	878.35	882	897.85	859.5	868.15	247652	2183.66	10863	67031	27.06999969482422
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SOBHA	401.5	402.8	404.4	398	401.3	94743	379.92	2392	62864	66.35
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SOBHA	401.3	402	410.05	399.65	406.85	100540	408.68	5235	49291	49.03
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SOBHA	406.85	407	412	401.15	404.35	63951	260.17	4707	28942	45.26


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