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)	CREDITACC	658.05	661	661.1	643.2	655.75	99144	647.4	15900	53339	53.79999923706055
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CREDITACC	655.75	680	786.9	680	728.95	1869218	13695.91	85161	705703	37.75
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CREDITACC	728.95	727	740.95	709	728.75	461977	3336.38	31414	179609	38.880001068115234
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CREDITACC	728.75	735	765	730.05	757.65	584316	4419.77	21597	194419	33.27000045776367
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CREDITACC	759.75	747	770.75	724.1	762.2	230343	1720.41	14627	72738	31.57999992370605
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CREDITACC	757.65	754	764.45	736	759.75	206895	1562.01	13028	84487	40.84000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CREDITACC	654.2	660	675	646	658.05	173076	1147.87	21336	74260	42.90999984741211
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CREDITACC	767.95	775.9	781	756.65	764.4	55920	431.96	4290	21030	37.61
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CREDITACC	764.4	764.4	773.2	747.3	752.25	67181	511.59	6368	30613	45.57
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CREDITACC	752.25	752.25	765.2	743.15	761.9	104764	791.56	14445	69346	66.19


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