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)	RVNL	35.5	35.5	35.65	35	35.05	2687122	946.91	13155	1395158	51.91999816894531
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RVNL	35.05	35.1	35.35	34.6	34.85	2815265	983.74	12487	1333382	47.36000061035156
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RVNL	34.85	34.9	35.1	34.05	34.45	2432754	839.02	11378	1153352	47.40999984741211
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RVNL	34.45	34.7	34.8	34.1	34.2	2436984	837.89	12923	1415975	58.09999847412109
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RVNL	35.5	35.05	35.45	34.5	34.65	4159845	1453.39	13716	1752048	42.119998931884766
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RVNL	34.2	35	35.9	34.8	35.5	9664613	3415	24677	3261424	33.75
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RVNL	35.65	35.8	35.95	35.15	35.5	2793237	995.37	9769	1251360	44.79999923706055
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RVNL	22.95	23.05	23.3	22.95	23	3128543	721.61	8389	1912927	61.14
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RVNL	23	23.05	23.9	22.9	23.75	7744461	1807.76	12477	3622879	46.78
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RVNL	23.75	23.6	25.3	23.6	25.05	17976269	4437.22	21604	7067819	39.32


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