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	2219.9	2221.6	2158.25	2174.75	2189.9937967437777	359005	26529	786218723	115305	32.12	63.35	-45.15
8-June-2021	2224.65	2227	2198.4	2214.7	2213.1838653343666	152318	9441	337107740	42207	27.71	28.6	-9.95
7-June-2021	2205.9	2241.8	2184.6	2227.3	2215.9618731976766	615525	36724	1363979932	233667	37.96	57.2	21.4
4-June-2021	2219	2219	2183.8	2190.6	2198.4564025241957	261311	16610	574480841	75458	28.88	35.2	-28.4
3-June-2021	2222	2250	2196.1	2209.25	2220.9008620406144	760173	44276	1688268871	228310	30.03	53.9	-12.75
2-June-2021	2159.9	2209.9	2158.55	2201.3	2180.076084702873	400317	23345	872721518	109300	27.3	51.35	41.4
1-June-2021	2164.1	2201.7	2147.35	2168.25	2176.4693345786886	916472	56064	1994673204	290019	31.65	54.35	4.15
31-May-2021	2101	2191.5	2082	2160.45	2153.0315908476487	2034450	97782	4380235120	709688	34.88	109.5	59.45
28-May-2021	1990	2105	1985.1	2094.9	2065.3678504097857	2158323	113895	4457730935	958435	44.41	119.9	104.9
27-May-2021	1970.9	1992.2	1963.1	1978.2	1981.3925383257729	274228	13119	543353313	112076	40.87	29.1	7.3


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