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)	CENTRALBK	22	22	22.05	21.4	21.55	3613692	784.75	6243	1439753	39.84000015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTRALBK	21.55	21.5	22.05	21.4	21.5	4776528	1034.65	6873	1516463	31.75
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTRALBK	21.5	21.65	21.9	21.05	21.15	4025042	857.12	6213	1214399	30.170000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTRALBK	21.15	21.2	21.45	21.1	21.2	2185186	463.65	3809	696151	31.86000061035156
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTRALBK	21.15	20.75	21.15	20.75	20.8	2391016	500.49	4714	1072925	44.869998931884766
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTRALBK	21.2	21.5	21.5	21.1	21.15	2696555	572.91	4331	1027340	38.09999847412109
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTRALBK	21.7	21.75	22.7	21.65	22	10433882	2298.66	11099	2777645	26.6200008392334
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTRALBK	17.9	17.9	18.15	17.9	17.95	381560	68.64	1324	214941	56.33
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTRALBK	17.95	18	18.3	17.95	18.15	627853	113.92	1600	439181	69.95
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CENTRALBK	18.15	18.25	18.3	18	18.15	390318	70.92	1284	224077	57.41


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