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)	RAILTEL	115.05	115.4	115.4	113.5	113.95	531182	606.5	9265	352349	66.33000183105469
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAILTEL	113.95	113.6	114.2	112.3	112.6	424067	479.47	8731	256265	60.43000030517578
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAILTEL	112.6	113.2	113.5	110.75	111.6	578093	645.56	9590	311603	53.900001525878906
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAILTEL	111.6	112.25	112.9	111.5	112	356367	398.8	6024	198764	55.77999877929688
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAILTEL	112.15	111.95	111.95	111.1	111.5	325674	363.09	5818	187517	57.58000183105469
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAILTEL	112	112.5	112.5	111.6	112.15	271840	304.73	5366	155970	57.380001068115234
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAILTEL	115.6	115.95	115.95	114.8	115.05	453629	522.65	7340	245190	54.04999923706055
Fri Feb 26 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	RAILTEL	94	109	127.85	101	121.35	128128642	150522.41	846064	37502680	29.27
Mon Mar 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	RAILTEL	121.35	128.85	145.6	127.4	145.6	44411780	62558.28	286541	9989849	22.49
Tue Mar 02 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	RAILTEL	145.6	159	174.7	155.9	174.7	47816924	80731.29	375897	9926186	20.76


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