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)	MAHINDCIE	214.75	214.75	215.05	212.15	212.75	62342	133.02	2178	28039	44.97999954223633
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHINDCIE	212.75	211	211.25	208	209.45	81697	171.41	3064	35257	43.15999984741211
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHINDCIE	209.45	212.6	212.6	204	206.95	92648	191.92	3661	37065	40.0099983215332
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHINDCIE	206.95	209.85	209.85	205.05	206.2	59929	124.01	2894	22207	37.060001373291016
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHINDCIE	208.05	205	213.95	205	211.05	232009	489.07	5599	86032	37.08000183105469
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHINDCIE	206.2	210	219.5	206	208.05	786889	1675.02	17841	173771	22.07999992370605
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHINDCIE	212.95	213	217.9	212.75	214.75	129982	280.55	4081	61369	47.209999084472656
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHINDCIE	164.75	164.55	165.7	163.1	164.45	88568	145.81	2014	35858	40.49
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHINDCIE	164.45	164.75	171.7	163.55	169.7	288598	487.83	5594	129601	44.91
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHINDCIE	169.7	170.4	172.75	167	169	139062	236.75	3075	58944	42.39


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