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)	KANSAINER	555.3	557	559	538	540.7	231319	1271.64	8943	173221	74.87999725341797
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KANSAINER	540.7	544.5	546	531.15	534.35	77169	415.5	5251	38896	50.400001525878906
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KANSAINER	534.35	536.7	538.7	515.25	518.7	218012	1143.16	7922	134390	61.63999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KANSAINER	518.7	519.4	523.6	508	510.1	173029	890.86	5603	141316	81.66999816894531
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KANSAINER	509.05	509	509.05	495	497.5	271597	1354.53	10535	205220	75.55999755859375
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KANSAINER	510.1	510.75	514.15	506	509.05	137048	698.3	5886	89797	65.5199966430664
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KANSAINER	555.55	552.9	556.85	544.5	555.3	125540	691.15	5998	62503	49.790000915527344
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KANSAINER	521.65	522	522.9	518.05	519.9	95850	498.29	2959	67701	70.63
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KANSAINER	519.9	520	528.85	516.5	524.85	156512	814.51	3940	132723	84.8
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KANSAINER	524.85	524.95	525.95	512.4	515.2	71897	371.76	2749	52726	73.34


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