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)	PRINCEPIPE	715.05	675.05	721.15	675	711.35	602725	4218.21	43552	270575	44.88999938964844
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRINCEPIPE	711.35	713	720.75	694.1	702.1	163020	1145.92	15631	87056	53.400001525878906
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRINCEPIPE	702.1	710	713.85	692	695.3	180895	1262.78	12129	111751	61.77999877929688
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRINCEPIPE	695.3	700.8	706.9	685	689.55	104791	729.21	8336	62825	59.95000076293945
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRINCEPIPE	689.8	680	692	680	682.3	123186	842.95	10777	75214	61.060001373291016
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRINCEPIPE	689.55	694	696.35	678.1	689.8	83134	571.35	6105	40857	49.150001525878906
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PRINCEPIPE	716.45	723	742.7	705	715.05	408184	2957.84	20690	190055	46.560001373291016
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PRINCEPIPE	152.45	153.05	159.5	152.4	155.85	3114230	4852.15	38149	583271	18.73
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PRINCEPIPE	155.85	156.05	158.7	154	155.7	1021302	1597.22	12425	250332	24.51
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PRINCEPIPE	155.7	156	156	151.25	151.9	623408	954.63	9564	219331	35.18


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