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)	SCI	130.05	130.95	133.3	129.4	130.1	2035710	2669.7	11112	843942	41.459999084472656
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SCI	130.1	129.45	130.3	126.5	127.95	1039576	1334.42	6239	396556	38.150001525878906
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SCI	127.95	128.8	129	124.75	125.55	708791	893.92	5638	268676	37.90999984741211
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SCI	125.55	125.95	128.9	124.85	125.95	1039216	1311.43	6286	432746	41.63999938964844
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SCI	124.6	124.05	126.15	123.4	123.85	1131324	1407.5	6912	523653	46.290000915527344
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SCI	125.95	126.25	127.3	124.1	124.6	1151378	1448.17	6641	514402	44.68000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SCI	130.6	131.3	132.25	129.65	130.05	980187	1280.7	5506	410950	41.93000030517578
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SCI	62	62.3	62.4	61.6	61.75	535532	331.25	2433	234914	43.87
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SCI	61.75	62	64.4	61.7	62.45	1690440	1065.26	6589	470629	27.84
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SCI	62.45	62.4	63.35	62	62.4	914000	572.18	7437	359358	39.32


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