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)	POONAWALLA	262.65	264	271.5	262.1	264.25	2690918	7158.01	19218	1102918	40.9900016784668
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POONAWALLA	264.25	266.3	267.75	249.15	251.25	4460803	11391.97	33711	2277444	51.04999923706055
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POONAWALLA	251.25	252.5	257.4	245.5	247.1	3850964	9593.5	35462	1496926	38.869998931884766
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POONAWALLA	247.1	249.4	267.5	247.5	257.75	5301601	13692.64	42530	1929575	36.400001525878906
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POONAWALLA	263.55	259.6	261.7	253.2	253.9	2150089	5520.91	18498	1022937	47.58000183105469
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POONAWALLA	257.75	259.45	267.8	254.05	263.55	3500626	9189.83	33387	1189229	33.970001220703125
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POONAWALLA	272	272.9	275.45	261.8	262.65	4501597	12004.56	37403	2403935	53.400001525878906
Thu Aug 05 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	POONAWALLA	169.5	172.75	173.7	165	166.65	340034	569.38	2720
Fri Aug 06 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	POONAWALLA	166.65	168.9	169	161.25	164.3	315560	521.05	2194
Mon Aug 09 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	POONAWALLA	164.3	166.8	172.5	166	172.5	338685	581.42	1706


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