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	491	493.7	481.15	484.85	488.9211932161441	821008	17528	401408211	363853	44.32	12.55	-6.15
8-June-2021	484.5	489.6	476.3	487.55	483.0617303043191	439703	7159	212403692	173434	39.44	13.3	3.05
7-June-2021	481	485.5	478.8	481.25	482.7781334080629	635179	12419	306650532	355702	56	6.7	0.25
4-June-2021	474.05	482.7	474.05	478.45	479.00280413884735	975344	16540	467192511	539180	55.28	8.65	4.4
3-June-2021	475.95	478.35	473.1	473.95	475.6212992804297	246675	4731	117323884	97718	39.61	5.25	-2
2-June-2021	470.05	475.4	469.05	474.55	472.7949387638528	532202	9341	251622412	299308	56.24	6.35	4.5
1-June-2021	473	476.7	470.1	470.85	472.86522995154854	285234	5348	134877241	95927	33.63	6.6	-2.15
31-May-2021	473.2	473.5	468.25	472	470.5631029856711	560544	13037	263771324	247424	44.14	5.25	-1.2
28-May-2021	476	480	468.6	471.6	474.05855903638735	754162	14831	357516951	247834	32.86	11.4	-4.4
27-May-2021	488	488	465.9	467.75	476.6917168865734	2167965	39897	1033450958	928074	42.81	22.1	-20.25


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