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)	FINPIPE	182.75	183.7	184.15	179.55	180.2	376867	680.52	9159	225828	59.91999816894531
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FINPIPE	180.2	181.5	184.5	180.55	183.4	480489	879.26	11492	265513	55.2599983215332
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FINPIPE	183.4	184.9	186.8	181.15	184.95	485250	895.84	13390	190420	39.2400016784668
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FINPIPE	184.95	185.85	186.45	176.8	177.5	495944	898.04	14007	277823	56.02000045776367
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FINPIPE	173.2	173	175.65	169	169.75	524890	898.55	14671	276066	52.59999847412109
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FINPIPE	177.5	179.25	179.5	171.9	173.2	679306	1180.34	14580	348125	51.25
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FINPIPE	180.05	181.25	184.55	179.8	182.75	640588	1171.04	10356	381472	59.54999923706055
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FINPIPE	546.2	542	551.95	535.25	539.7	20971	113.27	2128	10828	51.63
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FINPIPE	539.7	541.95	551	535.5	547.9	23021	125.18	1972	11527	50.07
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FINPIPE	547.9	550.15	554	544.15	548.75	14625	80.19	1648	7312	50


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