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)	BHARATRAS	12976.5	12975	13499	12900	13299.2	3018	397.28	1243	1683	55.77000045776367
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARATRAS	13299.2	13240	13419.6	13050	13295.25	3472	458.29	1664	1282	36.91999816894531
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARATRAS	13295.25	13255	13396.15	12750	12871.2	2211	287.13	1230	792	35.81999969482422
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARATRAS	12871.2	13048.85	13275	12890	12921.15	2583	338.55	1202	1118	43.27999877929688
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARATRAS	13094.65	13300	13401	12549.95	12634.3	6133	793.07	2038	2787	45.43999862670898
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARATRAS	12921.15	12930	13272	12910	13094.65	2634	344.48	1046	1129	42.86000061035156
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARATRAS	13065.5	13117.75	13244.2	12700	12976.5	5574	726.46	2097	1702	30.530000686645508
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARATRAS	6291.7	6300	6389	6216.05	6276.65	696	43.79	297	412	59.2
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARATRAS	6276.65	6328.75	6335	6220	6279.75	1261	79.02	482	713	56.54
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARATRAS	6279.75	6340	6340	6189.75	6206.5	636	39.68	276	407	63.99


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