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	1021.7	1035.65	997.6	1003.4	1021.2642568879583	223506	7447	228258689	107007	47.88	38.05	-18.3
8-June-2021	1029	1029	1006	1020.05	1018.032786885246	102175	4340	104017500	19861	19.44	23	-8.95
7-June-2021	1020	1032.75	1010	1025.1	1021.8822161175832	99742	3838	101924576	30108	30.19	22.75	5.1
4-June-2021	1012	1022.95	1004	1009.25	1006.4790190942427	3901333	9765	3926609811	3710814	95.12	18.95	-2.75
3-June-2021	1035	1036	964.75	1005.85	1000.1949658647972	774274	27196	774424957	129101	16.67	71.25	-29.15
2-June-2021	1010.05	1030	1001.25	1028	1019.9735977018302	135064	4663	137761714	27552	20.4	28.75	17.95
1-June-2021	1015	1031.45	1006.2	1009.75	1017.0684194173336	218856	8690	222591526	72580	33.16	25.25	-5.25
31-May-2021	1021.8	1021.8	1004.15	1013.45	1014.3770319489598	81818	3174	82994300	12491	15.27	17.65	-8.35
28-May-2021	1016	1025	1003.2	1018.85	1013.3024839641204	156524	5308	158606158	30411	19.43	21.8	2.85
27-May-2021	999	1012.35	987	1006.75	997.7929253118792	153505	4293	153166203	18261	11.9	25.35	7.75


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