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)	OBEROIRLTY	949.65	960	998.9	938	946.05	3530406	34269.03	77259	592552	16.780000686645508
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OBEROIRLTY	946.05	928.1	938.5	905.55	916.9	1067062	9782.58	29620	236343	22.149999618530277
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OBEROIRLTY	916.9	921	928.7	898.05	909.75	592290	5399.89	19359	118713	20.040000915527344
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OBEROIRLTY	909.75	911.4	942.3	911.4	938.05	723669	6738.91	18534	219817	30.3799991607666
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OBEROIRLTY	939.2	929.8	934	909	912.1	412521	3793.22	11062	129435	31.3799991607666
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OBEROIRLTY	938.05	942.4	949	930.4	939.2	484049	4553.64	14151	99204	20.489999771118164
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OBEROIRLTY	954.9	959	965.7	915.3	949.65	983355	9307.71	30307	239320	24.34000015258789
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	OBEROIRLTY	530.65	530.65	530.7	521	522.95	45551	238.99	1350	15483	33.99
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	OBEROIRLTY	522.95	523	534.85	521.35	528.85	74931	395.28	2844	27876	37.2
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	OBEROIRLTY	528.85	528.9	532	523.05	525.85	196706	1036.5	2621	158280	80.47


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