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	356.5	358.8	339.6	343.25	350.73729946046694	4480912	59698	1571622974	1345349	30.02	19.2	-13.25
8-June-2021	346.75	356.5	337.35	352.85	345.857260026879	3488224	48363	1206427595	1422250	40.77	19.15	6.1
7-June-2021	338.55	351	338.55	345.5	346.27017182950306	5575585	77740	1930658776	2202934	39.51	12.45	6.95
4-June-2021	325.45	336.9	324.5	334.95	329.7073361523759	1897098	17556	625487128	552896	29.14	12.4	9.5
3-June-2021	324.15	327.5	323.65	325.45	325.8679795712029	2157151	27066	702946438	970169	44.97	3.85	1.3
2-June-2021	316.2	324.25	315.5	323	321.1319892725176	2196974	27530	705518631	1043750	47.51	8.75	6.8
1-June-2021	319.65	325.7	317.4	318.1	320.6528309412584	1479190	15161	474306461	218106	14.74	8.3	-1.55
31-May-2021	319.4	319.5	312.1	318.7	316.437381560442	2185714	29241	691641615	586127	26.82	7.4	-0.7
28-May-2021	322.85	324.4	316.55	318.95	320.799587214651	1491332	13260	478418690	213823	14.34	7.85	-3.9
27-May-2021	316.9	323.35	316.9	318.6	320.7760437261286	2040885	19745	654667016	282322	13.83	6.45	1.7


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