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)	IRB	292.8	294	300.9	281.1	298.15	7204715	21168.4	56281	2834860	39.34999847412109
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRB	298.15	297.55	302.95	285.9	296.45	4600963	13559.96	50643	1769662	38.459999084472656
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRB	296.45	293.4	298.8	282.15	287.8	3823485	11012.54	24255	1861789	48.68999862670898
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRB	287.8	286.6	302	275.1	299.75	6557024	19199.37	35799	2209767	33.70000076293945
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRB	292.15	289.95	297.5	285	287.3	2929054	8531.64	33038	1069592	36.52000045776367
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRB	299.75	299.95	301.05	288.6	292.15	2196467	6497.69	25041	827741	37.68999862670898
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRB	279.3	279	293.25	275.1	292.8	5830445	16774.53	43032	2661915	45.65999984741211
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IRB	74.5	74.9	75.15	72.5	73.1	993560	733.02	6150	295652	29.76
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IRB	73.1	73.1	76	73.1	74.9	1409991	1053.6	9370	492315	34.92
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IRB	74.9	75.55	79.45	75	77.1	3418669	2661.14	21454	936491	27.39


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