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)	LAOPALA	384.5	385.9	394	381.1	382.95	169842	657.74	9211	50492	29.729999542236328
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LAOPALA	382.95	381	391	373.9	383.05	148422	565.46	8170	49659	33.459999084472656
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LAOPALA	383.05	386.4	389.6	373	380.25	92857	352.77	5334	27548	29.670000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LAOPALA	380.25	382.5	394.6	380.45	387.4	179409	696.32	11386	75482	42.06999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LAOPALA	380	377	385.2	375	377	108949	412.37	5246	39816	36.54999923706055
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LAOPALA	387.4	389.7	390.7	378	380	126989	485.24	7907	58430	46.0099983215332
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LAOPALA	391.15	391.95	403.15	381.15	384.5	208228	813.24	15275	63283	30.38999938964844
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LAOPALA	146.1	146.1	146.1	143.05	144.45	30757	44.32	592	24195	78.67
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LAOPALA	144.45	143.5	147	143.5	145.6	116798	169.7	1612	82579	70.7
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LAOPALA	145.6	144	154	144	151	179547	270.92	2606	78427	43.68


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