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	955.3	975	950.85	958.5	963.0386287855137	400375	11273	385576591	133613	33.37	24.15	3.2
8-June-2021	940	954.85	931.7	953.35	945.2910083309392	215822	8254	204014596	112834	52.28	23.15	13.35
7-June-2021	950.15	951	937.55	940.5	941.5142163310736	138362	6352	130269790	59568	43.05	13.45	-9.65
4-June-2021	948.5	951.25	936.35	946.55	943.8780561683737	198083	5667	186966197	102680	51.84	14.9	-1.95
3-June-2021	957	960	946.1	948.5	951.2114094383726	79145	3450	75283627	18992	24	13.9	-8.5
2-June-2021	949	960.5	945.3	954.55	955.0428687208739	128322	4371	122553011	56131	43.74	15.2	5.55
1-June-2021	954	958	943.7	946.4	949.5499143709936	102185	4548	97029758	26038	25.48	14.3	-7.6
31-May-2021	934.5	950.8	923.65	949.15	940.7471318173565	247805	9451	233121843	141242	57	27.15	14.65
28-May-2021	937.1	947	930.55	934.5	938.63874623694	146822	6819	137812818	58276	39.69	16.45	-2.6
27-May-2021	947	948.75	934.15	942.5	940.2113393285555	129214	4361	121488468	29774	23.04	14.6	-4.5


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