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)	ERIS	703.15	700.9	718.7	700.9	715.7	25322	180.71	5353	11636	45.95000076293945
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ERIS	715.7	725	725	701.15	703.7	29762	211.34	7391	7733	25.979999542236328
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ERIS	703.7	702.9	707.8	695	697.7	22876	159.98	5247	9766	42.68999862670898
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ERIS	697.7	699.75	706.8	695	696.55	14330	100.23	2653	6074	42.38999938964844
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ERIS	699.45	697	702.95	686	688.65	32024	221.76	8696	13157	41.08000183105469
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ERIS	696.55	695.2	703.85	695.2	699.45	12158	85.07	2174	5827	47.93000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ERIS	699.15	702.8	711.45	687.55	703.15	40922	286.93	7591	14934	36.4900016784668
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ERIS	474	475	501.95	472	496.4	106636	522.63	4505	41112	38.55
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ERIS	496.4	499	504.9	487.2	490.3	58607	289.27	4008	23873	40.73
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ERIS	490.3	489.75	498.25	475	489.7	74300	360.8	4757	31784	42.78


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