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)	BERGEPAINT	736.8	739	739.95	726.85	735.2	412049	3025.65	14608	71320	17.309999465942383
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BERGEPAINT	735.2	732.3	737.1	715.4	719.1	312119	2257.57	17244	108422	34.7400016784668
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BERGEPAINT	719.1	721	725.6	714.55	718.4	244699	1762.21	12409	67172	27.450000762939453
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BERGEPAINT	718.4	720	728.65	718.55	721.45	462519	3339.5	11967	248338	53.68999862670898
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BERGEPAINT	726.75	724	730	713	717.95	523896	3765.38	31367	234352	44.72999954223633
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BERGEPAINT	721.45	715.7	737.75	713.6	726.75	873044	6330.88	30331	170750	19.559999465942383
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BERGEPAINT	742.65	745	746	735	736.8	159164	1177.15	10302	58402	36.68999862670898
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BERGEPAINT	515.55	515.55	521.65	515.3	517.45	606573	3142.11	12361	104906	17.29
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BERGEPAINT	517.45	517.95	518.85	509.2	511.65	687697	3525.06	16663	289115	42.04
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BERGEPAINT	511.65	509.05	513.45	505.65	509.8	888973	4533.77	13599	326996	36.78


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