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	554.7	554.7	542.35	544.05	547.3151290813836	274478	5417	150225962	60480	22.03	12.35	-10.65
8-June-2021	550.8	555.5	549.5	550.5	552.3662338273506	297493	9634	164325088	115998	38.99	6	-0.3
7-June-2021	544	551.15	543	548.3	548.1273229209186	186188	4157	102054730	53232	28.59	8.15	4.3
4-June-2021	544.4	545.7	540.45	541.1	542.7257212225079	224064	4711	121605296	60601	27.05	5.25	-3.3
3-June-2021	546	550	538.35	539	542.2583079179815	284277	8273	154151565	89737	31.57	11.65	-7
2-June-2021	542.7	544.95	533.05	543.05	538.2229055916657	177389	4185	95474823	35714	20.13	11.9	0.35
1-June-2021	539.9	547	539.8	542.7	543.0864294075162	200765	4293	109032747	34577	17.22	7.2	2.8
31-May-2021	539.45	540.35	531.2	538.9	537.1180573455268	193982	3984	104191235	40528	20.89	9.15	-0.55
28-May-2021	540.4	541	532.6	538.65	536.2115755158437	370558	9751	198697489	98015	26.45	8.4	-1.75
27-May-2021	528	545	525.2	541.3	537.4217094488451	478704	9038	257265922	64827	13.54	19.8	13.3


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