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)	RITES	264.65	266	266.9	262.7	263.3	116732	308.4	3020	65470	56.09000015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RITES	263.3	264.8	267.9	264.05	264.95	79655	211.87	3069	32588	40.90999984741211
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RITES	264.95	267	267.85	258	263.2	57740	152.15	2781	29908	51.79999923706055
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RITES	263.2	267	268.6	264	265.65	171244	455.99	4624	59274	34.61000061035156
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RITES	261.1	261.1	262	255.6	259.55	129450	334.27	5420	60766	46.93999862670898
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RITES	265.65	264.6	267.7	259.7	261.1	137821	361.72	5045	81749	59.31999969482422
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RITES	270.2	271.3	271.75	263.5	264.65	222407	592.1	8455	139557	62.75
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RITES	289.75	291.4	295.8	291	294.45	535043	1569.63	7748	271843	50.81
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RITES	294.45	296.15	301.25	294	300.55	885150	2642.72	18508	379285	42.85
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RITES	300.55	303.5	317.6	302.4	309.5	2408058	7470.22	41254	924619	38.4


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