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)	SYNGENE	578.05	576.5	584.55	565.95	567.55	243581	1395.06	6568	107660	44.20000076293945
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SYNGENE	567.55	576	581.4	563.75	574.45	518364	2969.58	15412	216354	41.7400016784668
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SYNGENE	574.45	578.95	580	565	572.5	304149	1745.33	9751	139123	45.7400016784668
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SYNGENE	572.5	578	588.15	573.05	586.8	341062	1988.14	9720	187512	54.97999954223633
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SYNGENE	597.95	594.9	594.9	583.3	587.8	277790	1635.16	13508	108294	38.97999954223633
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SYNGENE	586.8	589.8	603.9	587.85	597.95	467381	2784.63	14353	188946	40.43000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SYNGENE	585.35	586.4	586.95	575.2	578.05	183638	1068.67	5456	79238	43.150001525878906
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SYNGENE	320.15	320.15	324	318.25	322.3	63948	206.22	3071	38326	59.93
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SYNGENE	322.3	325	341.45	320.3	336.45	149154	493.83	4516	58396	39.15
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SYNGENE	336.45	337.2	341	327	328.55	92944	311.08	3221	49956	53.75


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