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)	TTML	156.2	164	164	164	164	299211	490.71	2668
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TTML	164	172.2	172.2	165.1	172.2	8003863	13772.05	30421
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TTML	172.2	180.8	180.8	180.8	180.8	1491711	2697.01	5997
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TTML	180.8	177	177	171.8	171.8	3375930	5832.33	36991
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TTML	163.25	155.1	155.1	155.1	155.1	722713	1120.93	12930
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TTML	171.8	163.25	163.25	163.25	163.25	733728	1197.81	11737
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TTML	148.8	156.2	156.2	156.2	156.2	312915	488.77	3170
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TTML	2.2	2.25	2.25	2.2	2.25	197584	4.43	262	133569	67.6
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TTML	2.25	2.2	2.45	2.2	2.4	1056976	24.83	636	632138	59.81
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TTML	2.4	2.4	2.45	2.35	2.35	361537	8.61	393	263370	72.85


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