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)	RCF	77.45	78.75	78.9	76.9	77.1	2122935	1650.32	12469	615185	28.979999542236328
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RCF	77.1	77.25	79.5	77.25	77.85	2669419	2092.43	14415	593481	22.229999542236328
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RCF	77.85	78.2	78.6	75.4	76.9	3063834	2361.58	19461	601192	19.6200008392334
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RCF	76.9	77.5	78.15	77	77.35	951619	736.47	5690	382008	40.13999938964844
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RCF	77.75	78	82.95	78	80.55	9673245	7819.53	51677	2400746	24.81999969482422
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RCF	77.35	77.4	78.45	76.7	77.75	1193927	923.86	8023	428005	35.849998474121094
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RCF	77.6	77.95	78.6	77.3	77.45	1139121	886.16	6870	413809	36.33000183105469
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RCF	46.7	46.65	47.1	46.25	46.45	526148	245.31	2311	201414	38.28
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RCF	46.45	46.55	49.5	46.35	49.25	3219297	1561.15	11115	1002291	31.13
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RCF	49.25	48.3	50.35	48.1	49.2	2278926	1125.12	9028	486941	21.37


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