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)	CENTURYTEX	868.5	870	887.15	861	881.45	236378	2070.56	8077	48169	20.3799991607666
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTURYTEX	881.45	879.9	879.9	856.2	861.5	162112	1405.98	6857	48304	29.799999237060547
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTURYTEX	861.5	864	869.85	831.35	837.45	226408	1916.62	10854	85490	37.7599983215332
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTURYTEX	837.45	844.8	865	844.25	858.3	187039	1595.3	8237	49078	26.239999771118164
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTURYTEX	867.45	859.9	859.9	833	838.2	119440	1011.82	7086	47843	40.060001373291016
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTURYTEX	858.3	861	881.1	855	867.45	262813	2281.37	8488	67993	25.8700008392334
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTURYTEX	883.45	884	887.2	862.2	868.5	160437	1402.18	6279	49172	30.64999961853028
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTURYTEX	477.35	478.25	481.1	470.05	476.05	1024990	4874.17	15267	43139	4.21
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTURYTEX	476.05	479	493	474.7	491.15	1233932	5989.21	15598	173469	14.06
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTURYTEX	491.15	491.35	492	474.6	476.85	796938	3838.48	12632	136427	17.12


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