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	4250	4316.1	4230	4265.1	4268.668291374145	22363	2857	95460229	7563	33.82	86.1	15.1
8-June-2021	4234.45	4258.8	4200.75	4241.35	4235.648166339227	12216	2491	51742678	6411	52.48	58.05	6.9
7-June-2021	4270	4300	4218.6	4231.6	4258.185784658691	8526	1161	36305292	2325	27.27	81.4	-38.4
4-June-2021	4234	4275	4219.8	4258.75	4251.424760224892	9071	1079	38564674	2914	32.12	55.2	24.75
3-June-2021	4225.35	4241.45	4208	4231.05	4226.4866303833405	8452	989	35722265	1750	20.71	33.45	5.7
2-June-2021	4235	4255.05	4202.35	4214.1	4224.219566425792	21588	3067	91192452	9880	45.77	52.7	-20.9
1-June-2021	4213.6	4230.1	4156	4222.85	4195.183629191321	20280	2187	85078324	3841	18.94	74.1	9.25
31-May-2021	4194	4284.05	4114	4193.6	4201.043160286925	106927	11120	449204942	11319	10.59	170.05	-0.4
28-May-2021	4100	4146.75	4076.2	4116.5	4123.763576944026	31211	3653	128706785	14021	44.92	70.55	16.5
27-May-2021	4117	4126.45	4057.5	4088.4	4087.672294843864	11016	1313	45029798	4476	40.63	68.95	-28.6


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