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)	JUBLINGREA	596.5	590.3	603.6	582	596.1	436088	2578.99	11214	152064	34.869998931884766
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLINGREA	596.1	594	615	592	606.75	713870	4332.33	22694	328145	45.970001220703125
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLINGREA	606.75	609.7	611.4	584.05	587.35	359243	2130.11	17350	131661	36.650001525878906
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLINGREA	587.35	592	595.9	577	578.55	326321	1898.28	15181	159954	49.02000045776367
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLINGREA	568.05	568	574	550.55	553.7	339757	1905.84	13421	154646	45.52000045776367
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLINGREA	578.55	588	588	565.55	568.05	268424	1538.25	9635	123707	46.09000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLINGREA	602.55	607	608	593	596.5	425057	2554.33	11741	174496	41.04999923706055
Fri Mar 19 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLINGREA	1025.6	255.95	268.7	243.2	268.7	797366	2048.28	4437
Mon Mar 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLINGREA	268.7	282.1	282.1	282.1	282.1	103188	291.09	716
Tue Mar 23 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLINGREA	282.1	296.2	296.2	293	296.2	807676	2391.58	2857


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