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)	HDFCBANK	1515.35	1528.4	1532.85	1514.1	1524	5789979	88213.63	168452	3967301	68.5199966430664
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCBANK	1524	1512.1	1519	1460	1468.15	6134021	90695.79	263901	3793237	61.84000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCBANK	1468.15	1476.4	1478.45	1444.55	1461.85	6990565	102040.66	217552	4197709	60.04999923706055
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCBANK	1461.85	1474	1499.7	1467	1497.6	5654171	84092.12	152404	3379878	59.77999877929688
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCBANK	1525.1	1500.25	1525	1499.5	1518.85	5355552	81101.62	143617	3704108	69.16000366210938
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCBANK	1497.6	1514	1535.5	1501.65	1525.1	7157265	109029.4	213562	4616913	64.51000213623047
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCBANK	1531.2	1528.75	1539.95	1509	1515.35	5282381	80704.76	280078	3547783	67.16000366210938
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCBANK	1272.1	1276.1	1280	1270.6	1278.6	1836849	23450.01	46625	809152	44.05
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCBANK	1278.6	1279	1288	1279	1286.75	3068583	39417.92	104570	1957617	63.8
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCBANK	1286.75	1282.2	1285	1263.6	1268.4	5427775	68958.86	157066	3459267	63.73


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