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	5289	5310	5207.9	5221.85	5250.01168911917	24125	2276	126656532	12374	51.29	102.1	-67.15
8-June-2021	5220	5296.55	5151	5274.6	5210.738486842105	23712	3627	123557031	9114	38.44	145.55	54.6
7-June-2021	5279	5279	5213	5218.85	5230.250748804149	22369	2912	116995479	13399	59.9	66	-60.15
4-June-2021	5280	5295.65	5242	5253.35	5259.317055499203	20703	2803	108883641	7270	35.12	53.65	-26.65
3-June-2021	5310	5340	5270.3	5286.1	5299.919525344892	37838	4332	200538355	18399	48.63	69.7	-23.9
2-June-2021	5314.95	5351	5281.15	5312.45	5315.322670874273	27886	4108	148223088	10964	39.32	69.85	-2.5
1-June-2021	5305	5338.9	5265.5	5318.15	5307.295198675497	54360	5472	288504567	22012	40.49	73.4	13.15
31-May-2021	5202	5332	5170.55	5308	5260.129294522973	62114	7791	326727671	29416	47.36	161.45	106
28-May-2021	5288	5288	5150.6	5199.65	5201.415086039591	77290	8873	402017372	42489	54.97	137.4	-88.35
27-May-2021	5297.8	5297.8	5230.5	5268.7	5254.799445150849	17302	2146	90918540	4373	25.27	67.3	-29.1


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