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)	ULTRACEMCO	7375.35	7389	7529.9	7380.15	7439.65	462491	34517.06	46366	241447	52.209999084472656
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ULTRACEMCO	7439.65	7439.65	7518.95	7362.5	7469.35	391483	29183.33	37806	199423	50.93999862670898
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ULTRACEMCO	7469.35	7475.95	7499	7355.8	7421.35	270604	20071.86	36730	150566	55.63999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ULTRACEMCO	7421.35	7436	7547.9	7421.45	7504.05	253643	19036.28	31572	135232	53.31999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ULTRACEMCO	7474.5	7460.1	7460.1	7294.1	7323.6	265177	19470.8	35444	139477	52.59999847412109
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ULTRACEMCO	7504.05	7514.7	7548.95	7460.3	7474.5	284223	21322.49	44290	177504	62.45000076293945
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ULTRACEMCO	7441	7461	7485	7351	7375.35	167162	12417.46	30730	66300	39.65999984741211
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ULTRACEMCO	4046.05	4060	4071.95	4045	4065	163949	6654.88	9451	30007	18.3
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ULTRACEMCO	4065	4069.9	4256.3	4068.15	4244.8	1458328	61265.22	94709	403142	27.64
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ULTRACEMCO	4244.8	4237	4258	4185.85	4219.2	635983	26852.49	46789	174945	27.51


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