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)	TEAMLEASE	4627.65	4688	4688	4342.55	4365.05	36404	1610.84	11544	16858	46.310001373291016
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TEAMLEASE	4365.05	4388	4550	4350	4417.1	18998	841.96	5574	8227	43.29999923706055
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TEAMLEASE	4417.1	4437.1	4510	4300	4333.1	9290	404.45	3443	4304	46.33000183105469
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TEAMLEASE	4333.1	4360	4438	4243.3	4351.1	89637	3889.64	6132	76718	85.58999633789062
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TEAMLEASE	4168.1	4196	4211	4093.35	4165.45	24795	1026.99	4162	18366	74.06999969482422
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TEAMLEASE	4351.1	4354.9	4354.9	4112.1	4168.1	10066	425.04	3155	5041	50.08000183105469
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TEAMLEASE	4485.35	4507.8	4680	4453.35	4627.65	128873	5827.46	6359	110631	85.83999633789062
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TEAMLEASE	2479.85	2482.45	2510	2475	2478.5	7482	186.35	1953	5003	66.87
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TEAMLEASE	2478.5	2475	2543.9	2475	2503.55	11553	289.33	1119	7854	67.98
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TEAMLEASE	2503.55	2539	2539	2480	2487.05	6459	160.74	717	4500	69.67


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