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)	HGS	2561.25	2565	2578.8	2540.25	2545.65	19941	509.02	2533	13090	65.63999938964844
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HGS	2545.65	2543.7	2570.15	2491.4	2509.1	32521	821.63	4783	22811	70.13999938964844
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HGS	2509.1	2519.9	2532	2501	2517.45	25399	637.9	2556	15973	62.88999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HGS	2517.45	2517.45	2580	2503.9	2569.7	18460	469.08	2382	11759	63.70000076293945
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HGS	2603.4	2591.1	2599.15	2565.05	2585.3	24117	622.53	3041	16785	69.5999984741211
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HGS	2569.7	2588.6	2620	2556.95	2603.4	24466	632.72	3237	14725	60.18999862670898
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HGS	2601.1	2598.7	2610	2556.35	2561.25	37150	957.98	3251	23639	63.630001068115234
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HGS	582.1	597.85	597.9	585.5	587.7	680	4.02	99	246	36.18
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HGS	587.7	585.6	596.35	582	591.65	3029	17.94	259	1518	50.12
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HGS	591.65	590.65	618.45	590.65	612.4	4630	28.22	746	2403	51.9


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