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)	VAKRANGEE	39.15	39.3	39.35	38.65	39	2236441	872.87	5192	1434664	64.1500015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VAKRANGEE	39	39	39.25	38.1	38.2	2041637	785.22	6324	1235926	60.540000915527344
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VAKRANGEE	38.2	38.2	38.7	36.9	38.2	1998892	756.19	7962	965796	48.31999969482422
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VAKRANGEE	38.2	38	39.3	37.8	38.15	1631013	625.79	6677	654096	40.09999847412109
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VAKRANGEE	37.7	37.4	37.5	36.75	36.85	1735679	642.64	5965	1249170	71.97000122070312
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VAKRANGEE	38.15	38.25	38.35	37.6	37.7	1411824	533.95	5680	793680	56.220001220703125
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VAKRANGEE	39.5	39.6	39.75	38.95	39.15	1516844	595.93	4994	787254	51.900001525878906
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VAKRANGEE	47.75	47.6	48	46.6	47.4	3423864	1624.78	6082	1882075	54.97
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VAKRANGEE	47.4	47.6	50.3	47	49.95	6001678	2927.41	10519	3279551	54.64
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VAKRANGEE	49.95	50.5	52.8	50.4	52.3	6275763	3243.79	14031	2756913	43.93


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