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)	ROSSARI	1221.2	1215	1233.7	1201.6	1214.1	42657	518.22	4621	20160	47.2599983215332
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ROSSARI	1214.1	1212	1239	1190.5	1198.6	70801	861.34	14179	25794	36.43000030517578
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ROSSARI	1198.6	1202	1220	1170.65	1175.35	51535	610.12	8658	19417	37.68000030517578
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ROSSARI	1175.35	1180	1200	1160.25	1174.3	56091	658.33	5476	22732	40.52999877929688
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ROSSARI	1149.25	1148.05	1167	1138.25	1146.95	28574	329.67	4615	10114	35.400001525878906
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ROSSARI	1174.3	1174.5	1179.3	1141.1	1149.25	43255	502.48	8351	22560	52.15999984741211
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ROSSARI	1235.15	1235.85	1244.95	1192	1221.2	46491	565.87	5690	17901	38.5
Thu Jul 23 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ROSSARI	425	669.25	803.1	664	741.65	35781623	258634.52	998295	6967004	19.47
Fri Jul 24 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ROSSARI	741.65	754	793.9	723.35	731.2	7743490	58581.6	311421	1070353	13.82
Mon Jul 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ROSSARI	731.2	737.25	748.8	681.2	727.3	4512553	32466.83	156953	470183	10.42


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