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)	CASTROLIND	122.55	123	123	121.8	122.5	434189	531.26	5523	224154	51.630001068115234
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CASTROLIND	122.5	123	124.75	122.8	124.45	725080	897.83	8495	416403	57.43000030517578
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CASTROLIND	124.45	126	126.45	121.05	123.1	1568494	1950.21	13466	540344	34.45000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CASTROLIND	123.1	124	124.2	121.45	121.6	1011638	1238.8	14311	581151	57.45000076293945
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CASTROLIND	120.1	120.1	120.65	119.55	120.25	522809	627.69	7777	305015	58.34000015258789
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CASTROLIND	121.6	121.7	122.95	120	120.1	1376217	1664.93	12737	842476	61.220001220703125
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CASTROLIND	123.4	124.2	124.2	122.3	122.55	539312	661.86	9126	370414	68.68000030517578
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CASTROLIND	129.3	129.7	130.15	128.7	129	413634	534.76	3850	126984	30.7
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CASTROLIND	129	129.3	130.9	128.55	130.25	2744539	3569.31	11815	2001903	72.94
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CASTROLIND	130.25	130.25	131.75	128.35	129	1393412	1811.84	20208	577387	41.44


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