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)	TRENT	1083.3	1086.2	1090	1052	1057.4	305527	3255.5	17449	121944	39.90999984741211
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TRENT	1057.4	1060.2	1068.8	1025	1050.45	648493	6744.86	18420	379645	58.540000915527344
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TRENT	1050.45	1054.8	1067.05	1035.35	1053.95	377585	3982.36	15280	159584	42.2599983215332
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TRENT	1053.95	1064	1075	1053	1070.6	304759	3249.99	14924	140839	46.209999084472656
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TRENT	1075.6	1085	1099.55	1055.4	1071.35	1656107	17870.26	71099	410587	24.790000915527344
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TRENT	1070.6	1076.5	1085	1055	1075.6	411046	4402.92	22373	188555	45.869998931884766
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TRENT	1097.55	1098	1100	1077.35	1083.3	416753	4530.07	12330	241111	57.84999847412109
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TRENT	527.15	527	534.75	524	529.65	107849	572.5	4279	49290	45.7
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TRENT	529.65	529.5	545.9	528.7	541.35	158640	856.9	8740	79267	49.97
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TRENT	541.35	542.4	542.8	534	535.9	63423	340.82	3215	23667	37.32


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