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)	TITAN	2474.95	2510	2520	2430	2471.15	2718069	67245.48	131789	864802	31.81999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TITAN	2471.15	2480	2498.15	2388	2409.2	1119632	27222.13	69021	339196	30.299999237060547
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TITAN	2409.2	2418.4	2465	2400.9	2443.65	1524580	37125.47	98867	554343	36.36000061035156
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TITAN	2443.65	2465	2495	2456.05	2484.8	826261	20506.74	66348	362984	43.93000030517578
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TITAN	2491.85	2480	2480	2421.25	2442.25	1030760	25192.15	66364	550796	53.43999862670898
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TITAN	2484.8	2499.95	2503.95	2465.55	2491.85	788689	19618.08	57984	385842	48.91999816894531
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TITAN	2464	2480.5	2506.55	2417	2474.95	3883564	96150.7	184015	822375	21.18000030517578
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TITAN	1187.95	1194.45	1199	1152.2	1154.75	3137636	36666.82	91203	985291	31.4
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TITAN	1154.75	1157	1159.9	1140	1155.6	3286436	37818.8	120035	847441	25.79
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TITAN	1155.6	1156	1156	1132	1139.7	2695237	30790.27	105909	1017731	37.76


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