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)	NESCO	595.05	593	597.8	578.25	584.05	30848	180.77	1977	17649	57.209999084472656
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NESCO	584.05	583	589.45	569.8	572.35	30103	173.22	1758	17624	58.54999923706055
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NESCO	572.35	574	575.25	559.7	563.65	34468	194.49	2358	20741	60.16999816894531
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NESCO	563.65	562	573.6	562	565.8	24059	136.56	1630	13316	55.34999847412109
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NESCO	572.1	562	571.7	560	563.5	17467	98.59	1238	10325	59.11000061035156
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NESCO	565.8	565.8	576	565	572.1	17095	97.87	1969	8684	50.79999923706055
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NESCO	597.35	600.35	605	590.55	595.05	39059	233.65	2988	15942	40.81999969482422
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NESCO	660.65	664.9	673.9	662.3	670.5	36213	242.47	1595	14846	41
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NESCO	670.5	674	674	664.2	669	21415	143.47	1311	12466	58.21
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NESCO	669	666	673.5	657.5	662.7	30657	204.65	1882	18041	58.85


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