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	1792	1812.35	1775	1782.5	1800.8593562039841	158777	9081	285935046	92633	58.34	37.35	-9.5
8-June-2021	1820	1820	1788	1796.45	1798.8157143706521	134552	7620	242034252	91267	67.83	32	-23.55
7-June-2021	1824	1824	1807.7	1816.55	1816.3167114750672	105263	3822	191190946	80422	76.4	16.3	-7.45
4-June-2021	1820.1	1824.8	1796.6	1810.2	1809.116452573145	186445	9624	337300717	136962	73.46	28.2	-9.9
3-June-2021	1798.7	1828	1793	1814.75	1813.5169893808284	77313	4343	140208439	20139	26.05	35	16.05
2-June-2021	1796	1796	1770.1	1782.6	1778.1029026860035	93224	6684	165761865	45155	48.44	25.9	-13.4
1-June-2021	1815.9	1824	1787.5	1797.7	1801.3199008539725	154923	11449	279065883	69824	45.07	36.5	-18.2
31-May-2021	1803	1811.95	1784.8	1807.8	1803.2882983474765	107472	8617	193803000	69364	64.54	27.15	4.8
28-May-2021	1785	1812.8	1776.6	1800.1	1798.7195324564673	187790	12897	337781541	110974	59.09	36.2	15.1
27-May-2021	1744.9	1784.7	1725.65	1778.25	1759.99415333788	253649	6281	446420757	177475	69.97	59.05	33.35


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