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	6790	6790	6684	6724.7	6733.359003558719	7025	1513	47301847	1458	20.75	106	-65.3
8-June-2021	6880	6881.7	6727.65	6790.3	6790.299975502205	8164	1554	55436009	1637	20.05	154.05	-89.7
7-June-2021	6670	6903.55	6666.75	6848.65	6675.981615274029	272672	3382	1820353259	255831	93.82	236.8	178.65
4-June-2021	6660	6682	6618	6663.1	6656.584387617766	7430	1035	49458422	1525	20.52	64	3.1
3-June-2021	6649.95	6655	6578.05	6635.8	6623.050503235082	5564	1074	36850653	1206	21.68	76.95	-14.15
2-June-2021	6630	6670	6552.45	6592.9	6613.695940756994	18230	2565	120567677	2881	15.8	117.55	-37.1
1-June-2021	6702.05	6723.1	6560	6600.75	6623.014407863731	14853	3441	98371633	4847	32.63	163.1	-101.3
31-May-2021	6625	6720.9	6591	6710.1	6657.6940522512505	8995	1516	59885958	1872	20.81	129.9	85.1
28-May-2021	6725	6727.4	6579.35	6597	6651.999475616151	17163	2873	114168267	3334	19.43	148.05	-128
27-May-2021	6600	6722.5	6585.35	6679.9	6672.319545823195	20961	3121	139858490	3976	18.97	137.15	79.9


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