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)	INDIGO	1941.5	1950.65	2005	1937.05	1974.35	946376	18741.29	45166	191042	20.190000534057617
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIGO	1974.35	2005	2187.05	1985	2170.1	4481201	95566.97	190264	301759	6.730000019073486
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIGO	2170.1	2165	2235	2155	2182.6	2280188	50002.14	109589	242618	10.640000343322754
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIGO	2182.6	2190	2263	2180.1	2253.8	1079814	24105.98	49739	106495	9.859999656677246
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIGO	2236.75	2208.2	2282	2201.1	2264.95	1317813	29810.9	78305	345987	26.25
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIGO	2253.8	2250.5	2282.1	2195.1	2236.75	1182724	26422.41	62080	329198	27.82999992370605
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIGO	1947.55	1959.4	1959.4	1920	1941.5	258633	5011.1	21464	67127	25.950000762939453
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIGO	1333.55	1333.55	1347.65	1330	1333	377625	5050.41	12274	30416	8.05
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIGO	1333	1340	1346.95	1330	1332.4	396177	5300.05	10461	49514	12.5
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIGO	1332.4	1318.5	1382.5	1301.4	1360.95	3665728	49589.35	95801	307214	8.38


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