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	11749.75	11865	11432.9	11558.65	11696.309984845931	11878	2513	138928770	2323	19.56	432.1	-191.1
8-June-2021	11850	11890	11671	11730.85	11756.456734731251	10921	2173	128392264	1522	13.94	219	-119.15
7-June-2021	11969.75	12028.05	11683.45	11828.5	11798.287070056367	17386	3858	205125019	3310	19.04	344.6	-141.25
4-June-2021	11775	12189	11775	12152.4	12006.457914110428	20375	4294	244631580	6706	32.91	414	377.4
3-June-2021	11823.6	11922.85	11789.15	11820.55	11848.734099616859	7830	1460	92775588	1985	25.35	133.7	-3.05
2-June-2021	11730	11853.3	11702.75	11819.55	11771.893549267583	10991	2072	129384882	2905	26.43	150.55	89.55
1-June-2021	11800	11940	11631.7	11832.25	11806.77916212428	12842	2429	151622658	2499	19.46	308.3	32.25
31-May-2021	11715	11853.3	11618.95	11796.8	11716.224592662056	8531	1677	99951112	923	10.82	234.35	81.8
28-May-2021	11890	12021	11679.9	11712.55	11833.402114732107	12673	2546	149964705	1815	14.32	341.1	-177.45
27-May-2021	11938	11965	11730.15	11883.65	11816.346393203095	18479	3926	218354265	3231	17.48	234.85	-54.35


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