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)	TRIDENT	61.05	61.1	63.85	60.5	62.3	5620962	3492.01	41742
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TRIDENT	62.3	63.4	63.4	61.2	61.6	4953362	3074.87	49511
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TRIDENT	61.6	62	62.35	58.55	60.45	5626456	3381.56	54657
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TRIDENT	60.45	61	61.5	59.5	59.8	3851797	2307.88	43090
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TRIDENT	58.8	56.9	57.8	56.2	56.8	5708215	3251.49	68536
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TRIDENT	59.8	59.8	59.95	56.85	58.8	5826228	3380.58	57210
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TRIDENT	60.8	61.7	61.7	60.05	61.05	3723408	2264.73	36806
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TRIDENT	6.7	6.75	6.8	6.65	6.7	3261803	218.31	3371	1504773	46.13
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TRIDENT	6.7	6.7	6.8	6.65	6.75	4519956	303.58	3767	2211619	48.93
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TRIDENT	6.75	6.8	6.8	6.65	6.7	5222641	350.7	4684	2078106	39.79


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