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)	TRITURBINE	205.65	208	213	205.65	209.9	891289	1868.07	20310	227400	25.51000022888184
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TRITURBINE	209.9	208.5	210.95	205.5	208	385331	802.13	10784	122207	31.709999084472656
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TRITURBINE	208	206.6	215.9	205.65	209.4	883443	1866.19	26059	265343	30.040000915527344
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TRITURBINE	209.4	211	213.95	202.7	204.85	554238	1151.03	15966	281641	50.81999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TRITURBINE	207.35	203	207.1	201	203.25	165103	337.92	5154	60231	36.47999954223633
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TRITURBINE	204.85	205.9	208.8	205	207.35	181218	375.41	6828	73009	40.290000915527344
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TRITURBINE	210	211.45	218.7	204.4	205.65	1621199	3400.84	31164	496640	30.6299991607666
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TRITURBINE	94.05	94.1	94.35	92.95	94.05	11275	10.57	268	7736	68.61
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TRITURBINE	94.05	94	96.5	93.95	96.15	15926	15.25	320	11650	73.15
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TRITURBINE	96.15	96.15	98	94.8	96.4	13906	13.48	372	7157	51.47


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