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)	ORIENTELEC	335.2	337.35	343.95	330	340.45	334595	1133.3	9277	236098	70.55999755859375
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ORIENTELEC	340.45	343.8	343.8	334	336	101370	341.14	5284	65412	64.52999877929688
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ORIENTELEC	336	337	337	331.05	334.9	112618	375.95	6983	68302	60.650001525878906
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ORIENTELEC	334.9	334.05	335.95	330.15	332.9	242621	805.78	5850	203516	83.87999725341797
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ORIENTELEC	335.05	333.8	334	328	333.05	90871	301.22	7431	58466	64.33999633789062
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ORIENTELEC	332.9	332.9	337	329.1	335.05	122372	406.42	4606	86314	70.52999877929688
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ORIENTELEC	335.35	337.95	339.9	333.55	335.2	78679	265.24	3886	37825	48.08000183105469
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ORIENTELEC	188.05	188.05	193	187.55	190.9	83076	157.57	2600	58379	70.27
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ORIENTELEC	190.9	192.65	193.7	189.5	191.8	226570	433.09	2567	168874	74.54
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ORIENTELEC	191.8	191.5	196	188.35	190.95	160034	306.37	1602	126186	78.85


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