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)	SPICEJET	60.85	60.9	61.2	60.2	60.35	1346476	817.42	7416	653884	48.560001373291016
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SPICEJET	60.35	60.85	63.2	60.3	62.25	5051679	3107.97	19718	1321272	26.15999984741211
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SPICEJET	62.25	61.95	62.1	60.65	60.9	1610957	986.5	10261	581367	36.09000015258789
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SPICEJET	60.9	61.4	61.6	60.4	60.5	1223837	744.25	6887	623611	50.959999084472656
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SPICEJET	62.95	62.45	64.25	62	62.75	3523158	2225.34	15233	1209578	34.33000183105469
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SPICEJET	60.5	60.8	63.9	60.2	62.95	7291756	4540.93	31329	2157523	29.59000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SPICEJET	60.95	61	61.25	60.6	60.85	1367790	833.32	7092	609378	44.54999923706055
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SPICEJET	112.65	113.5	118.9	113	116.4	5151813	5984	31746	2076017	40.3
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SPICEJET	116.4	117.1	117.25	111.5	113.9	1472014	1677.41	14761	402935	27.37
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SPICEJET	113.9	113.6	113.6	105.3	106.2	3013776	3252.74	25770	1425669	47.31


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