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)	HAL	1416.65	1416.6	1433.55	1394.6	1400.2	293206	4133.08	16071	107161	36.54999923706055
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HAL	1400.2	1400.2	1418.85	1382	1386.8	314116	4386.55	22137	100816	32.099998474121094
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HAL	1386.8	1390	1404	1365.2	1378.05	499717	6924.53	17204	222123	44.45000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HAL	1378.05	1385	1423	1383.1	1414.5	583529	8231.06	28062	341805	58.58000183105469
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HAL	1397.85	1370	1399	1370	1379.95	278609	3859.56	12183	103900	37.290000915527344
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HAL	1414.5	1419	1438	1383	1397.85	996820	14065.03	38301	284752	28.56999969482422
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HAL	1420.55	1425.9	1454	1407	1416.65	741303	10572.26	20895	356130	48.040000915527344
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HAL	730.4	735	735.15	730	730.2	3193	23.34	603	1971	61.73
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HAL	730.2	734.95	749.25	729.35	735.25	13059	96.26	1429	5687	43.55
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HAL	735.25	737.8	756.9	723.5	736.9	138709	1016.12	5367	109769	79.14


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