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)	SJVN	31.45	31.6	31.7	31.2	31.25	1658162	520.98	6247	906332	54.65999984741211
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SJVN	31.25	31.4	31.6	31.2	31.3	1942712	608.41	6980	1035935	53.31999969482422
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SJVN	31.3	31.4	31.55	30.55	30.85	2126047	658.22	8800	1053765	49.560001373291016
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SJVN	30.85	31.3	31.4	31.05	31.25	1832191	572.29	6297	817243	44.59999847412109
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SJVN	31.75	30.95	31.25	30.6	30.75	3007513	928.31	9410	1641490	54.58000183105469
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SJVN	31.25	31.35	31.95	31.1	31.75	3005956	949.83	9070	1846824	61.43999862670898
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SJVN	30.95	30.85	31.6	30.85	31.45	3492756	1097.16	8859	1975828	56.56999969482422
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SJVN	25.45	25.6	25.9	25.3	25.75	475381	121.92	1264	321529	67.64
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SJVN	25.75	25.8	26	25.4	25.7	1903408	487.16	3021	1443516	75.84
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SJVN	25.7	25.7	26	25.55	25.95	1220886	315.32	3598	863224	70.7


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