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)	KARURVYSYA	54.45	54.7	54.85	52.55	53.05	6453585	3454.72	21532	2493169	38.630001068115234
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KARURVYSYA	53.05	53.4	55.3	52.8	54.6	8893261	4850.46	34648	4350932	48.91999816894531
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KARURVYSYA	54.6	55	55.3	52.25	54.45	4274216	2295.87	20221	1373591	32.13999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KARURVYSYA	54.45	54.75	55.3	53.25	54.6	3335071	1813.05	12026	1258171	37.72999954223633
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KARURVYSYA	55.4	54.5	55.5	53.8	54.65	3402409	1864.04	13066	1256041	36.91999816894531
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KARURVYSYA	54.6	55	56.45	54.7	55.4	5463456	3027.1	17506	2111158	38.63999938964844
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KARURVYSYA	55.6	55.8	55.95	54.2	54.45	7447524	4092.23	41227	3170815	42.58000183105469
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KARURVYSYA	60.25	60.5	60.5	59.8	59.85	114408	68.77	1016	77710	67.92
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KARURVYSYA	59.85	60.1	61	59.8	60.1	369277	222.98	1759	247975	67.15
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KARURVYSYA	60.1	59.2	60.4	59.2	59.75	307900	184.07	2281	148412	48.2


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