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)	AUBANK	1380.85	1384.5	1389.85	1333.6	1343.9	881399	11997.37	35213	231952	26.31999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AUBANK	1343.9	1351.4	1364	1318.4	1339	960983	12900.86	39762	225660	23.479999542236328
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AUBANK	1339	1346	1361.25	1303	1334.35	1047707	13965.98	31966	208340	19.88999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AUBANK	1334.35	1342.9	1373.65	1338	1366.9	804292	10912.68	49339	280372	34.86000061035156
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AUBANK	1377.95	1367	1377.95	1316	1320.3	838862	11261.68	37711	168203	20.049999237060547
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AUBANK	1366.9	1368	1383.85	1357	1377.95	754309	10364.41	37170	284498	37.720001220703125
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AUBANK	1396.8	1395	1421	1371.05	1380.85	1488776	20824.28	71246	351470	23.61000061035156
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AUBANK	803.1	804	809.85	792	797.7	89721	716.47	7416	43292	48.25
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AUBANK	797.7	793.5	801.05	793.05	795.9	63607	507.27	3923	31773	49.95
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AUBANK	795.9	796.8	802.5	792	797.95	90898	724.15	6087	45380	49.92


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