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	704.6	713.3	693.85	697.95	704.1001392804403	238368	5114	167834942	29414	12.34	19.45	-6.65
8-June-2021	714.7	714.7	692.1	707.4	700.8571711719661	1564047	10918	1096173556	1164972	74.48	22.6	-7.3
7-June-2021	724	730.6	712.8	715.85	723.3109011298541	410407	9081	296851857	98615	24.03	17.8	-8.15
4-June-2021	706	725.9	703.05	721.5	715.1074408257451	361855	6572	258765203	52587	14.53	22.85	15.5
3-June-2021	708	720.9	702.75	713.85	712.2556165751373	344516	6612	245383456	46127	13.39	18.15	5.85
2-June-2021	700	708.8	697.3	705.45	701.6318635906728	402905	8172	282690986	97101	24.1	11.5	5.45
1-June-2021	719	719	687.8	694.35	696.3549324517853	502752	10359	350093835	81282	16.17	31.2	-24.65
31-May-2021	693	714.3	685.9	710.55	701.7034111384648	533341	8853	374247199	74232	13.92	28.4	17.55
28-May-2021	696	708.85	686.3	689.75	698.6474375999759	662660	11809	462965711	57755	8.72	22.55	-6.25
27-May-2021	684.9	694.05	678.05	681.6	685.1052366708321	530547	8927	363480528	53685	10.12	16	-3.3


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