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)	TIMKEN	2030.7	2012.2	2048.75	1976.15	1982.6	18615	373	3586	6367	34.20000076293945
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TIMKEN	1982.6	1983	2004.8	1920	1936.7	25326	492.22	6426	10036	39.630001068115234
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TIMKEN	1936.7	1935	1945	1909	1930.55	12625	242.77	3306	5820	46.09999847412109
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TIMKEN	1930.55	1940.25	1963	1920	1938.6	13150	256.01	3625	5287	40.209999084472656
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TIMKEN	1912.95	1922	1980	1910	1963.2	24563	478.06	6353	8299	33.790000915527344
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TIMKEN	1938.6	1944.9	1948.3	1900.2	1912.95	14127	271.37	3225	6442	45.59999847412109
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TIMKEN	2051.2	2088.8	2089	2010.05	2030.7	123689	2531.29	7821	95257	77.01000213623047
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TIMKEN	922	918	931.4	918	927.15	30766	284.67	3990	17972	58.42
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TIMKEN	927.15	930	931.1	907	911.8	22392	205.75	1549	8264	36.91
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TIMKEN	911.8	905.35	914.25	895.7	908.05	18939	171.61	1943	9195	48.55


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