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)	IBREALEST	145.45	146.1	148.2	144.5	146.05	5511855	8048.49	29071	1465359	26.59000015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IBREALEST	146.05	146.25	147.4	143.65	144.3	5321260	7734.45	30498	1869467	35.130001068115234
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IBREALEST	144.3	145	145.45	136.3	137.65	9350707	13012.61	49204	3064250	32.77000045776367
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IBREALEST	137.65	138.5	142.4	135.1	141.4	8346541	11571.79	43919	2650579	31.76000022888184
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IBREALEST	142.3	141	141.85	138.3	139	4042760	5660	21615	1433835	35.470001220703125
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IBREALEST	141.4	142	145.5	139.5	142.3	6369964	9092.56	33410	1855567	29.1299991607666
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IBREALEST	146.45	146.45	150.5	144.6	145.45	8530183	12569.08	41417	2581519	30.26000022888184
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IBREALEST	65.35	67.25	71.85	67	71.85	8398192	5970.92	23808	2614404	31.13
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IBREALEST	71.85	77.35	79	76.35	79	6932568	5427.55	21530	3381175	48.77
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IBREALEST	79	82.95	82.95	81.1	82.95	4537215	3760.59	4196	1926804	42.47


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