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)	CYIENT	966.95	969	983.55	956.45	960.2	122741	1191.03	10335	71542	58.290000915527344
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CYIENT	960.2	965.05	969.7	935.1	937.15	100056	944.12	9537	51248	51.220001220703125
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CYIENT	937.15	943	944.9	909.55	915.1	125293	1157.02	11576	57980	46.27999877929688
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CYIENT	915.1	919.9	929.55	910.1	912.15	101016	927.08	12040	48534	48.04999923706055
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CYIENT	901.7	895	897.6	873.55	886.55	179867	1590.95	18798	108432	60.27999877929688
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CYIENT	912.15	919.1	919.15	894.1	901.7	217774	1965.11	14471	145996	67.04000091552734
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CYIENT	1003.1	1003	1004	960	966.95	170625	1673.6	21482	93797	54.970001220703125
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CYIENT	410.3	415	437.75	411.7	432.7	322406	1386.46	8922	94600	29.34
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CYIENT	432.7	433.45	447.5	433.45	442.4	232669	1028.83	6877	116639	50.13
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CYIENT	442.4	435.8	442.55	435	436.9	43377	190.21	1745	19116	44.07


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