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)	HDFC	2527.8	2546.5	2547	2497	2503.25	4404184	110730.56	239694	3052324	69.30999755859375
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFC	2503.25	2488.5	2512.1	2420	2428.15	3664108	89806.14	200599	2345861	64.0199966430664
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFC	2428.15	2441	2452	2405	2414.6	6127473	148226.6	226531	4491186	73.30000305175781
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFC	2414.6	2432	2442.5	2402.5	2435.35	7141774	172886.95	215047	5527426	77.4000015258789
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFC	2476.55	2449.95	2449.95	2417.1	2426.35	4062444	98724.89	196048	2706316	66.62000274658203
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFC	2435.35	2462	2505.7	2441.6	2476.55	6346218	157117.98	277489	4321538	68.0999984741211
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFC	2612.95	2613	2620	2520	2527.8	4647089	118292.15	243196	2714821	58.41999816894531
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFC	2412.55	2418	2438.5	2409	2433.95	945874	22945.34	29500	355005	37.53
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFC	2433.95	2430	2472.75	2422	2466.4	1701396	41696.05	74760	990649	58.23
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFC	2466.4	2455	2466.4	2441.8	2454.45	1963923	48152.98	92333	1260684	64.19


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