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)	QUESS	742.5	741.05	741.05	725	727.1	67642	493.24	6149	34914	51.619998931884766
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	QUESS	727.1	720	735.25	716.45	731	66493	484.32	6786	34772	52.290000915527344
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	QUESS	731	740	740	714.2	725	183796	1331.8	5923	149526	81.3499984741211
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	QUESS	725	726	737.35	720	730.15	38424	280.31	4228	14070	36.619998931884766
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	QUESS	659.6	695.5	723.55	635.1	641.3	1803235	12072.62	126066	740577	41.06999969482422
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	QUESS	730.15	725	725	630	659.6	1130827	7353.95	68187	424640	37.54999923706055
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	QUESS	725.5	727.85	753.9	726.25	742.5	158777	1184.68	21194	55831	35.15999984741211
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	QUESS	484.65	484.85	490.95	479.55	482.85	53889	260.97	2926	23102	42.87
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	QUESS	482.85	484.65	510	480.15	503.2	311806	1551.88	12919	125070	40.11
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	QUESS	503.2	510	532.8	508	525.2	637268	3333.93	23600	201578	31.63


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