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)	OIL	231.2	234	240.95	224	225	1444856	3313.96	47234	753169	52.130001068115234
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OIL	225	225	235	224.95	231.2	1285820	2951.97	18658	609376	47.38999938964844
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OIL	231.2	230.15	234.75	221.55	230.05	969686	2226.12	24367	553645	57.09999847412109
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OIL	230.05	231	235	228.45	232.15	800673	1856.18	17881	452351	56.5
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OIL	230.2	228	233.4	227	229.2	1760936	4049.74	27350	435835	24.75
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OIL	232.15	232.15	233.55	229.6	230.2	370009	853.9	8512	209574	56.63999938964844
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OIL	233.5	233.5	241.6	230	231.2	1304172	3060.48	25391	725023	55.59000015258789
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	OIL	153.05	153.3	153.45	151.75	152.2	244943	373.62	2793	79440	32.43
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	OIL	152.2	152.5	153.75	151.15	153.05	272684	416.53	2862	94272	34.57
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	OIL	153.05	155.15	158.2	154.2	155.95	1808825	2825.48	13309	301458	16.67


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