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)	SUNTV	514.5	515	515	502.45	505.45	544445	2763.69	9279	126520	23.239999771118164
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNTV	505.45	503.2	511.85	500.5	504.85	632134	3200.77	11288	195515	30.93000030517578
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNTV	504.85	508.85	509.25	493.75	503.6	630782	3156.16	11662	187648	29.75
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNTV	503.6	508	533.45	505.3	517.25	3016310	15779.22	43288	583196	19.32999992370605
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNTV	521.6	526.45	539.8	515.25	517.85	4839806	25545.44	77116	662425	13.6899995803833
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNTV	517.25	521	528	515.25	521.6	1125210	5871.34	18702	344041	30.57999992370605
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNTV	516.2	518	518.9	511.1	514.5	752221	3870.93	10257	177122	23.549999237060547
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNTV	441.8	442.7	444.85	438.5	439.55	703692	3101.52	8516	80437	11.43
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNTV	439.55	430	437	410	434.2	6011135	25684.71	93583	1187290	19.75
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNTV	434.2	432.95	439.9	426.05	430.1	2064472	8915.09	22903	268766	13.02


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