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)	SBIN	540.1	542.15	546.4	527.3	530.3	25332894	135759.88	325989	7851720	30.989999771118164
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SBIN	530.3	531.9	549	525.25	533.25	52289545	281469.61	564783	14452562	27.63999938964844
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SBIN	533.25	535.5	537.65	519	531.35	26567546	140383.49	305464	5243345	19.739999771118164
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SBIN	531.35	534.95	536.5	527.75	535.25	14856155	79142.33	191210	5270035	35.470001220703125
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SBIN	540.55	536.25	537.7	527.1	529.6	14607095	77749.22	177760	5300325	36.290000915527344
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SBIN	535.25	537.1	543.95	534.4	540.55	18659370	100825.67	228387	6678600	35.790000915527344
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SBIN	539.8	537.15	544.7	537.15	540.1	22717677	122900.17	323435	10843133	47.72999954223633
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SBIN	333.75	334.7	335.95	332.15	334.45	17379320	58051.3	99108	1850790	10.65
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SBIN	334.45	334.5	339.85	333.35	339.3	20324236	68453.41	123189	4239894	20.86
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SBIN	339.3	337.95	337.95	332	333.7	21853208	73226	139793	6309081	28.87


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