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)	TTKPRESTIG	933.95	945	945	912.8	916.95	113799	1047.12	9349	57159	50.22999954223633
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TTKPRESTIG	916.95	912.1	924.75	893	901.55	67270	607.49	7864	42238	62.790000915527344
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TTKPRESTIG	901.55	914.9	914.9	881.05	887.75	56139	500.24	8773	33251	59.22999954223633
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TTKPRESTIG	887.75	885	916.95	884.5	907.25	71228	639.47	9164	33540	47.09000015258789
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TTKPRESTIG	886.4	886.4	889.8	850	855.25	167919	1449.02	15209	105045	62.560001373291016
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TTKPRESTIG	907.25	916	920	883	886.4	79455	710.43	10412	38042	47.880001068115234
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TTKPRESTIG	941.35	957	957	930	933.95	45838	430.2	6110	26002	56.72999954223633
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TTKPRESTIG	5713.05	5718.3	5770	5710.05	5743.55	1434	82.44	676	931	64.92
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TTKPRESTIG	5743.55	5745	5948	5710	5805.2	3638	211.58	1319	1555	42.74
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TTKPRESTIG	5805.2	5820.6	5850	5780.15	5833.75	2433	141.65	1155	1505	61.86


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