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)	REDINGTON	162.8	163.5	168.25	161.85	163.65	2376227	3914.92	21604	769742	32.38999938964844
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	REDINGTON	163.65	164.65	164.95	161.2	163.25	1418132	2309.53	13986	635126	44.790000915527344
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	REDINGTON	163.25	163.5	165.85	155.05	159.7	2369740	3790.49	27526	1123561	47.40999984741211
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	REDINGTON	159.7	166	169.45	161.05	162.8	8065560	13244.47	64566	3560833	44.150001525878906
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	REDINGTON	173.65	171	174.6	168.45	170.7	8985699	15419.43	105513	3792555	42.209999084472656
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	REDINGTON	162.8	164	177.85	163.3	173.65	18168356	31385.6	117650	7569250	41.65999984741211
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	REDINGTON	166.05	166.7	166.7	161.65	162.8	1998709	3277.04	16529	881847	44.119998931884766
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	REDINGTON	117.8	118	118	116.4	116.95	30307	35.48	654	12595	41.56
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	REDINGTON	116.95	117.35	117.75	115.5	116.45	54115	63.1	1140	24487	45.25
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	REDINGTON	116.45	117	119.6	116.05	116.95	140805	165.35	3451	68358	48.55


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