S&P BSE SENSEX 50

date Date	open_price Open Price	high_price High Price	low_price Low Price	close_price Close Price	wap WAP	no_of_shares No.of Shares	no_of_trades No. Of Trades	total_turnover_rs Total Turnover (Rs.)	deliverable_quantity Deliverable Quantity	n__deli_qty_to_traded_qty % Deli. Qty To Traded Qty	spread_high_low Spread High-Low	spread_close_open Spread Close-Open
9-June-2021	711	714.55	700.45	702.65	706.7916852822913	85054	3664	60115460	35865	42.17	14.1	-8.35
8-June-2021	704.15	715.45	701.5	709.9	710.7140895640745	272386	9916	193588568	109750	40.29	13.95	5.75
7-June-2021	688	706.5	687.15	700	700.2009845000626	151549	5112	106114759	37992	25.07	19.35	12
4-June-2021	680	689.85	675.15	686.7	686.0140132876805	88202	2782	60507808	23192	26.29	14.7	6.7
3-June-2021	675.15	683	673.3	679.85	678.6017986288776	90291	3057	61271635	25786	28.56	9.7	4.7
2-June-2021	666	674.55	660.5	673.3	670.2243793194444	140209	2993	93971490	63486	45.28	14.05	7.3
1-June-2021	664.95	667	657	665.55	663.5333825117333	93537	2341	62064922	31770	33.97	10	0.6
31-May-2021	658.05	664.85	650.5	663.7	658.666094941552	113691	3242	74884407	35515	31.24	14.35	5.65
28-May-2021	651.8	657.5	646.25	654.8	653.806256805736	190097	7121	124286608	120761	63.53	11.25	3
27-May-2021	644	651.7	641.5	649.05	645.5449065937642	76815	2512	49587532	17766	23.13	10.2	5.05


CREATE TABLE tataconsumer (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT,
  "total_turnover_rs" DOUBLE,
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);