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)	KAJARIACER	1296.6	1300	1307.55	1272.1	1284.95	67397	866.31	7245	24356	36.13999938964844
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KAJARIACER	1284.95	1270	1284.95	1255.55	1277.85	83718	1063.92	13951	39158	46.77000045776367
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KAJARIACER	1277.85	1284.6	1306	1260.05	1276.3	72452	927.63	12003	32156	44.380001068115234
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KAJARIACER	1276.3	1276.3	1300	1256.55	1277.6	283636	3581.96	13000	204991	72.2699966430664
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KAJARIACER	1274.9	1260	1276.95	1245.1	1270.25	67469	849.94	7347	35498	52.61000061035156
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KAJARIACER	1277.6	1277	1284.15	1256.55	1274.9	109696	1392.71	16111	64038	58.380001068115234
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KAJARIACER	1320.75	1329.75	1351.95	1291.1	1296.6	152268	1993.72	10625	58907	38.68999862670898
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KAJARIACER	525.2	527.5	527.5	522.35	525.55	26939	141.56	1308	12608	46.8
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KAJARIACER	525.55	525	534.8	524	533	400151	2121.02	2672	365554	91.35
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KAJARIACER	533	533	539.9	528	536.8	170159	913.09	3800	110485	64.93


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