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	127.25	128	123.1	124	125.76601630056653	2012200	10862	253066378	377021	18.74	4.9	-3.25
8-June-2021	126.2	126.2	122.7	124.7	123.9793186961413	1384874	7669	171695735	487239	35.18	3.5	-1.5
7-June-2021	127	127.5	124.9	125.1	126.29779352092064	1503300	9225	189863473	566848	37.71	2.6	-1.9
4-June-2021	124.3	126.7	123.35	125.4	125.08925172779372	4877463	33300	610118197	1162699	23.84	3.35	1.1
3-June-2021	118.55	123.9	118.45	122.65	121.15680458920514	5138319	40830	622542311	2260626	44	5.45	4.1
2-June-2021	118	119.25	116	117.75	117.2084543599254	2442645	23887	286298645	854765	34.99	3.25	-0.25
1-June-2021	114.3	118.4	114.25	117.65	117.18280082556304	3603359	23687	422251700	950711	26.38	4.15	3.35
31-May-2021	113	114.3	111.35	113.65	113.05809889458698	1522146	11296	172090933	484335	31.82	2.95	0.65
28-May-2021	112.8	115.5	111.85	112.4	113.42283335110125	1022443	6221	115968382	206841	20.23	3.65	-0.4
27-May-2021	113.25	113.65	111.1	111.8	112.5769722312022	992949	7949	111783192	383143	38.59	2.55	-1.45


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