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)	UPL	773.5	773.6	776.8	765	767.2	992052	7644.96	38325	321894	32.45000076293945
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UPL	767.2	764.2	774.9	750.25	756.6	1255955	9559.35	38720	384447	30.61000061035156
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UPL	756.6	757	763.95	744.1	758.65	2063533	15581.31	61970	927869	44.970001220703125
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UPL	758.65	764.5	772.45	760	770.5	1342782	10305.43	40319	494238	36.810001373291016
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UPL	770.1	765.85	766.95	750	753.2	1621795	12273.12	53454	783953	48.34000015258789
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UPL	770.5	775	778.95	767.95	770.1	2561635	19793.59	59463	1528509	59.66999816894531
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UPL	785.95	788.95	791	771	773.5	1493402	11626.71	49491	651058	43.59999847412109
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	UPL	584.5	585	589.5	580.7	588.25	720807	4222.2	10631	103653	14.38
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	UPL	588.25	589.5	597.2	584.2	595.45	1388201	8230.92	28402	408803	29.45
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	UPL	595.45	591.5	594.2	587.3	590.75	1063950	6286.08	25690	469433	44.12


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