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)	EMAMILTD	497.8	501.1	507.8	500	502.65	219084	1104.03	16170	100692	45.959999084472656
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EMAMILTD	502.65	504.45	505.45	494.15	498.1	188340	941.8	15240	88008	46.72999954223633
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EMAMILTD	498.1	500	503.5	495.05	497.55	353656	1765.2	10038	250530	70.83999633789062
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EMAMILTD	497.55	501.05	503.65	495.35	496.5	65745	327.52	3825	26604	40.470001220703125
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EMAMILTD	501.3	494.35	501	493.25	497.95	147447	734.13	9464	79650	54.02000045776367
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EMAMILTD	496.5	493	504.5	492.6	501.3	156420	780.99	7661	85751	54.81999969482422
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EMAMILTD	508.3	510	513.15	495.5	497.8	402889	2024.15	20897	102830	25.520000457763672
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EMAMILTD	309.9	310	315	309.9	312.55	80450	251.86	4139	34977	43.48
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EMAMILTD	312.55	312.8	314	309.1	312	124367	387.67	5419	92661	74.51
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EMAMILTD	312	312	318	310.65	315.5	77456	244.03	2605	34909	45.07


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