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)	RAIN	227.25	228.4	233.7	225.5	228.05	3042638	6962.07	20730	753062	24.75
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAIN	228.05	227.9	232.3	225.05	226.7	1393500	3180.77	13862	373658	26.809999465942383
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAIN	226.7	227.45	230.8	216.1	226.2	2221002	4972.72	19805	464699	20.920000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAIN	226.2	228.35	240	228.35	238.6	9868431	23380.27	84843	1475342	14.949999809265137
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAIN	239.05	237	238.4	231.3	232.2	1917420	4508.85	19869	490872	25.600000381469727
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAIN	238.6	239.8	241.7	237.15	239.05	2471301	5909.19	22940	585222	23.68000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAIN	227.25	227.65	230.8	226.05	227.25	1189058	2713.12	10750	341415	28.709999084472656
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RAIN	98.6	98.9	101.65	98.45	99.65	974325	972.09	9536	305155	31.32
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RAIN	99.65	100	107.8	99.95	105.45	2738854	2877.96	20653	1041608	38.03
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RAIN	105.45	105.5	111	104.65	107	2382690	2573.59	16903	693835	29.12


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