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)	HIKAL	415.25	418	434.75	412.75	429.75	392600	1671.7	13098	158248	40.310001373291016
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HIKAL	429.75	432.85	437.45	421	423.2	167662	715.29	6653	80837	48.209999084472656
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HIKAL	423.2	424.85	429.7	407	414.9	151060	631.46	6456	65887	43.619998931884766
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HIKAL	414.9	415.5	429.4	415.5	425.15	149099	631.34	5693	87613	58.7599983215332
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HIKAL	425	420	429.05	417.1	425.1	149098	633.32	7019	101447	68.04000091552734
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HIKAL	425.15	425	429.95	417	425	172215	731.03	7262	102954	59.77999877929688
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HIKAL	424.9	425.5	426.15	414	415.25	126568	531.28	5747	67491	53.31999969482422
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HIKAL	114.3	115	117.5	113.75	116.65	237880	275.41	4589	127065	53.42
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HIKAL	116.65	117	134.4	116.1	129.8	2268429	2891.03	21189	581176	25.62
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HIKAL	129.8	128.4	128.8	121.1	122.8	547533	684.58	8649	283631	51.8


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