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)	UJJIVAN	140.05	140.45	141.5	135.6	136	615251	845.85	5832	358987	58.34999847412109
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UJJIVAN	136	130	130	119.5	123.35	9666433	11979.79	65098	4370976	45.220001220703125
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UJJIVAN	123.35	123	127.45	122.15	123.8	2671484	3350.79	26818	1154114	43.20000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UJJIVAN	123.8	124.85	125	120.1	123.2	1627405	1993.73	12692	766019	47.06999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UJJIVAN	123.6	121.65	124.5	121	123.9	1072218	1318.75	7217	616846	57.52999877929688
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UJJIVAN	123.2	123.25	125.55	122.75	123.6	991112	1231.6	8752	531572	53.630001068115234
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UJJIVAN	139.5	138.6	141	138.5	140.05	421208	589.53	4513	209167	49.65999984741211
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	UJJIVAN	347.4	349.55	351.55	345.4	346.4	1256425	4383.75	8617	155487	12.38
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	UJJIVAN	346.4	346.4	354	346.4	352	1063537	3728.94	9725	160269	15.07
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	UJJIVAN	352	352.8	352.8	343.4	345.05	848121	2940.27	8018	156109	18.41


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