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	1550	1550.05	1513.75	1518.7	1530.9049867461897	96576	5703	147848680	34328	35.54	36.3	-31.3
8-June-2021	1559.8	1582.65	1533.55	1546.6	1564.9169461520648	133877	7693	209506386	52873	39.49	49.1	-13.2
7-June-2021	1540.6	1569.5	1540.6	1557.35	1543.0363241707212	1117658	12445	1724586892	1025138	91.72	28.9	16.75
4-June-2021	1518.7	1547	1515.7	1537.6	1534.6029726888228	249202	9812	382426130	104739	42.03	31.3	18.9
3-June-2021	1466.05	1514.8	1466.05	1510.25	1492.5380744328456	259321	14957	387046466	200342	77.26	48.75	44.2
2-June-2021	1473.95	1474.55	1455.1	1471.45	1464.2711897185252	56879	3197	83286281	20069	35.28	19.45	-2.5
1-June-2021	1469.85	1492.5	1464.95	1474.3	1478.4134242096968	68518	4048	101297931	20019	29.22	27.55	4.45
31-May-2021	1477	1478	1457.6	1465.55	1466.4871754332623	82225	4557	120581908	26195	31.86	20.4	-11.45
28-May-2021	1485	1499.8	1473.9	1477.2	1484.8896725549798	92443	4287	137267656	44543	48.18	25.9	-7.8
27-May-2021	1479	1485	1462	1482.75	1473.0871212709455	128786	6010	189712998	62767	48.74	23	3.75


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