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	680.05	684.5	667.7	672.8	678.6266593269426	285206	9519	193548395	134520	47.17	16.8	-7.25
8-June-2021	675	680.05	665.25	678.85	672.6341121035005	121816	3667	81937597	31616	25.95	14.8	3.85
7-June-2021	670	677.65	670	675.05	674.063309352518	193905	6987	130704246	89386	46.1	7.65	5.05
4-June-2021	676.55	679	672.7	674.2	675.8137223939807	360972	10699	243949831	216124	59.87	6.3	-2.35
3-June-2021	678.7	680.8	673.45	675.5	676.7042074185144	322787	8117	218431321	176751	54.76	7.35	-3.2
2-June-2021	673.5	678.5	666	677.65	676.299956315253	569993	12344	385486241	327589	57.47	12.5	4.15
1-June-2021	673.4	673.4	664.4	671.25	667.4513071695341	326660	6358	218029644	93473	28.61	9	-2.15
31-May-2021	673.15	675.4	659	668.3	667.3757664958417	563930	12315	376353216	244664	43.39	16.4	-4.85
28-May-2021	698.6	698.6	666.55	669.65	674.6135919159967	1451657	38403	979307543	723453	49.84	32.05	-28.95
27-May-2021	710	710	694.2	699.75	701.5383793410508	303210	7509	212713452	53221	17.55	15.8	-10.25


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