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)	HEG	1556.4	1563	1590	1532.4	1538.3	258183	4020.83	25534	76924	29.790000915527344
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEG	1538.3	1538.3	1554.7	1511	1524.05	163501	2502.65	20209	60315	36.88999938964844
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEG	1524.05	1533	1577	1471	1544.55	477026	7288.84	45288	136261	28.559999465942383
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEG	1544.55	1555	1561.85	1511	1522.65	209069	3218.49	20595	65153	31.15999984741211
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEG	1512.2	1510	1510.9	1450	1454.55	279108	4105.47	21852	114292	40.95000076293945
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEG	1522.65	1540	1564.95	1506.85	1512.2	455234	7009.14	37053	115881	25.459999084472656
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEG	1557.8	1569	1578	1546.8	1556.4	219433	3428.02	24565	79462	36.209999084472656
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HEG	1065.95	1068	1086.4	1055.2	1065.8	305402	3273.11	12776	51820	16.97
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HEG	1065.8	1069	1099	1063.9	1076.1	413605	4467.74	19930	80048	19.35
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HEG	1076.1	1074.9	1125	1068.1	1081.4	651837	7144.31	27265	94752	14.54


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