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)	DBL	370.75	372	372.9	360	363.1	308922	1132.45	8383	137545	44.52000045776367
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DBL	363.1	363	366.5	352.1	356.25	328266	1174.6	8100	114168	34.779998779296875
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DBL	356.25	357	361.25	350.15	354.15	384192	1364.5	9228	87309	22.729999542236328
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DBL	354.15	356.4	357.65	351.45	352.65	188663	667.54	4398	71358	37.81999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DBL	349.7	347	349.1	340	341.3	319274	1098.77	7590	127482	39.93000030517578
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DBL	352.65	354	355.75	349.05	349.7	400987	1409.39	10692	135528	33.79999923706055
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DBL	371.15	373	376.75	370	370.75	293407	1093.92	7295	118535	40.400001525878906
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DBL	402.65	402.65	406.9	400	403.6	158608	639.79	4851	48548	30.61
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DBL	403.6	405.7	420.7	403	413	509104	2105.64	12629	135796	26.67
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DBL	413	412.5	436	408.05	421.45	1102624	4690.18	29356	209660	19.01


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