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)	ADVENZYMES	348.45	350.95	354.9	338.45	340.45	150868	517.29	5927	62016	41.11000061035156
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADVENZYMES	340.45	329	332	320	321.25	198748	641.79	8422	81964	41.2400016784668
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADVENZYMES	321.25	321.25	332	314.9	316.45	97691	313.1	5304	35535	36.369998931884766
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADVENZYMES	316.45	318.05	322.6	309.65	310.45	120229	376.28	9156	59693	49.650001525878906
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADVENZYMES	311.85	309	313.25	309	311.95	52324	162.94	2324	26703	51.02999877929688
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADVENZYMES	310.45	313.5	316.7	310.15	311.85	117497	367.36	6211	48347	41.150001525878906
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADVENZYMES	336.1	337.8	351.05	337.2	348.45	730512	2548.62	19963	392367	53.709999084472656
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADVENZYMES	165.5	165.5	166.4	164.1	164.5	12150	20.04	546	7411	61
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADVENZYMES	164.5	164.55	169.7	164.5	169.3	131523	221.9	2312	67937	51.65
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADVENZYMES	169.3	169.9	175.6	168.4	169.4	122301	210.21	3530	56314	46.05


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