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)	MPHASIS	3013.75	2986	3064.6	2977.3	3051.85	226441	6859.57	20758	79533	35.119998931884766
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MPHASIS	3051.85	3051.7	3077.95	2995	3022.4	193583	5858.54	18630	72122	37.2599983215332
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MPHASIS	3022.4	3040.2	3057.5	2940	2981.6	235153	7021.14	20402	92901	39.5099983215332
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MPHASIS	2981.6	2997.3	3069.95	2993.6	3030.25	384113	11607.49	32636	196948	51.27000045776367
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MPHASIS	3110.15	3068	3077.65	2945	3001.55	589646	17661.62	47961	281994	47.81999969482422
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MPHASIS	3030.25	3046.2	3118	3020	3110.15	634918	19535	34243	421507	66.38999938964844
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MPHASIS	3127.7	3129	3129.95	2990.3	3013.75	302239	9236.67	28270	127917	42.31999969482422
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MPHASIS	922.25	927	929	913.55	923.8	131875	1219.84	16551	13461	10.21
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MPHASIS	923.8	923.8	926.5	890.5	894.05	360884	3236.36	7501	298811	82.8
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MPHASIS	894.05	894	900.8	878.45	883.7	235166	2084.28	23846	156224	66.43


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