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)	MMTC	54.9	55.1	57.1	54.3	55	8605059	4774.2	24012	1862552	21.63999938964844
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MMTC	55	54.9	55.4	52.8	53.2	3995000	2157.47	14922	1470325	36.79999923706055
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MMTC	53.2	53.25	53.65	51	51.55	6839685	3566.35	20785	1543634	22.56999969482422
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MMTC	51.55	51.55	54.65	51.4	53.95	10948409	5857.74	35190	1900312	17.360000610351562
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MMTC	52.3	51.8	52.25	50.05	50.75	4147939	2133.24	13596	1248158	30.09000015258789
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MMTC	53.95	53.8	54.05	52	52.3	5087802	2693.03	13944	1297008	25.489999771118164
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MMTC	56.8	56.45	57.05	54.6	54.9	6808290	3793.61	22752	2367989	34.779998779296875
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MMTC	18.75	18.85	19.05	18.65	18.75	384009	72.4	1253	136971	35.67
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MMTC	18.75	18.9	21.1	18.75	20.2	7788468	1586.13	13896	1447860	18.59
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MMTC	20.2	20.1	20.4	19.45	19.55	1520774	302.34	3577	643038	42.28


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