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)	GRANULES	324.5	324.5	325.45	316.5	320.15	1019282	3263.72	12699	250908	24.6200008392334
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRANULES	320.15	319.75	321	311	312	541316	1702.88	10066	147454	27.239999771118164
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRANULES	312	311.85	316	301.5	309.75	2539806	7882.26	50082	209034	8.229999542236328
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRANULES	309.75	310.95	315.85	306	311.65	741264	2310.61	10657	245525	33.119998931884766
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRANULES	313.4	310	311.8	305	306.25	738423	2277.05	9492	214316	29.020000457763672
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRANULES	311.65	313.3	315.35	310.45	313.4	546014	1709.15	7514	190232	34.84000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRANULES	321.35	321.35	327	321.35	324.5	1391481	4516.01	19574	675260	48.52999877929688
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GRANULES	123.1	123.2	124.1	121.65	121.9	382672	468.05	5399	265941	69.5
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GRANULES	121.9	122.05	123.75	121.5	122	694594	850.39	7547	444224	63.95
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GRANULES	122	122.3	126	122.05	123.6	969986	1205.35	10432	382248	39.41


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