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	854.6	864.7	842.65	853.1	854.9185580774365	51681	2701	44183046	13652	26.42	22.05	-1.5
8-June-2021	845.55	858.85	845.55	855.75	853.9018847506537	33267	1641	28406754	9166	27.55	13.3	10.2
7-June-2021	859	859	847.2	849.05	852.2086776859504	21780	1390	18561105	4902	22.51	11.8	-9.95
4-June-2021	865	869.9	843.4	851.7	856.4279337865798	67660	3001	57945914	9737	14.39	26.5	-13.3
3-June-2021	857.9	865.7	850.6	864.3	860.1932135590881	57998	2706	49889486	21233	36.61	15.1	6.4
2-June-2021	845.15	855.35	836.45	851.15	848.2321196683648	40044	2202	33966607	10926	27.28	18.9	6
1-June-2021	852.9	865.55	845.2	848.3	854.5465021309456	67341	4652	57546016	31046	46.1	20.35	-4.6
31-May-2021	848.9	861.95	838	857.15	857.8330577310969	110062	3238	94414822	12785	11.62	23.95	8.25
28-May-2021	839.9	851.95	832.05	844.4	844.149294486709	78737	4414	66465783	42331	53.76	19.9	4.5
27-May-2021	828.65	838	819.85	832.75	831.3547713841722	88161	4423	73293068	32466	36.83	18.15	4.1


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