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	1702.95	1738.45	1697.9	1729.6	1719.7248681697515	83251	6013	143168815	30466	36.6	40.55	26.65
8-June-2021	1685	1725.55	1674.25	1712.75	1706.471073953123	96764	6436	165124967	26023	26.89	51.3	27.75
7-June-2021	1690	1713.25	1677	1685.35	1693.57143466697	70309	4246	119073314	24296	34.56	36.25	-4.65
4-June-2021	1705	1710	1665	1674.95	1683.3869881396186	135999	7709	228938947	19355	14.23	45	-30.05
3-June-2021	1602	1702	1591.4	1691	1666.8706260448873	377433	18795	629131981	51278	13.59	110.6	89
2-June-2021	1586	1597.05	1564.6	1585	1576.2178242730456	47699	3835	75184014	10872	22.79	32.45	-1
1-June-2021	1605	1612	1588.5	1591.5	1599.730147018637	36594	2312	58540525	8428	23.03	23.5	-13.5
31-May-2021	1572	1607.45	1570	1594.9	1594.3982315521628	78600	5134	125319701	23697	30.15	37.45	22.9
28-May-2021	1609	1612.65	1570.4	1577.15	1586.499372811373	38266	2463	60708985	8512	22.24	42.25	-31.85
27-May-2021	1591.75	1606.4	1568.4	1594.1	1589.0186501195965	57694	3241	91676842	8637	14.97	38	2.35


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