Spreadsheet: 784294d1655590502-paneldata-data-transpose-datenbereich1
Sheet: Industry Dummy

Number of Constituents | Identifier (RIC) | Company Name | Market Cap 26.04.22 (USD) (Σ=Avg) | [NAME] (1= Oil and Gas, 0=Oil and Gas Related Equipment and Services)
1 | XOM.N | Exxon Mobil Corp | 347603920700.76 | 1
2 | CVX.N | Chevron Corp | 309446125671.91 | 1 |  |  | Categories | Under categories
3 | COP.N | Conocophillips | 118796058216.62 | 1 |  |  | Oil & Gas | Oild & Gas Refining & marketing
4 | EOG.N | EOG Resources Inc | 65428979385.35 | 1 |  |  |  | Oild & Gas Exploration and Production
5 | EPD.N | Enterprise Products Partners LP | 56368231303.3 | 0 |  |  |  | Integrated Oil & Gas
6 | PXD.N | Pioneer Natural Resources Co | 55926399792.9 | 1
7 | SLB.N | Schlumberger NV | 54674153918.34 | 0 |  |  | Categories | Under categories
8 | OXY.N | Occidental Petroleum Corp | 51455053099.24 | 1 |  |  | Oil & Gas Related Equipment and Services | Oil& Gas Transportation Services
9 | MPC.N | Marathon Petroleum Corp | 47065483915.34 | 1 |  |  |  | Oil Related Services and Equipment
10 | KMI.N | Kinder Morgan Inc | 42197663690.25 | 0 |  |  |  | Oil and Gas Drilling
11 | VLO.N | Valero Energy Corp | 41301958915.36 | 1
12 | WMB.N | Williams Companies Inc | 41266923039.6 | 0
13 | PSX.N | Phillips 66 | 38977614213.54 | 1
14 | DVN.N | Devon Energy Corp | 37145346895.4 | 1
15 | ET.N | Energy Transfer LP | 34250224801.65 | 0
16 | LNG.A | Cheniere Energy Inc | 33357558682.17 | 0
17 | MPLX.N | MPLX LP | 33218910046.76 | 0
18 | HES.N | Hess Corp | 31941762573.14 | 1
19 | HAL.N | [NAME] | 31866808617.66 | 0
20 | BKR.OQ | Baker Hughes Co | 31513632135.22 | 0
21 | OKE.N | ONEOK Inc | 29609026129.8 | 0
22 | CQP.A | Cheniere Energy Partners LP | 25726041587.45 | 0
23 | CTRA.N | Coterra Energy Inc | 23242652236.04 | 1
24 | FANG.OQ | Diamondback Energy Inc | 22322351399.58 | 1
25 | CLR.N | Continental Resources Inc | 20545769056.86 | 1
26 | MRO.N | Marathon Oil Corp | 17346059305.24 | 1
27 | TRGP.N | Targa Resources Corp | 16679473416.57 | 0
28 | IEP.OQ | Icahn Enterprises LP | 15627353522.76 | 1
29 | EQT.N | EQT Corp | 14928123025 | 1
30 | APA.OQ | APA Corp (US) | 13557914702.44 | 1
31 | OVV.N | [NAME] | 12656100782.67 | 1
32 | MMP.N | Magellan Midstream Partners LP | 10713116135.28 | 0
33 | TPL.N | Texas Pacific Land Corp | 10623246535 | 1
34 | AR.N | Antero Resources Corp | 10221672901.44 | 1
35 | CHK.OQ | Chesapeake Energy Corp | 10001599327.055 | 1
36 | WES.N | Western Midstream Partners LP | 9911101524.24 | 1
37 | SWN.N | Southwestern Energy Co | 8292622829.11 | 1
38 | DINO.N | HF Sinclair Corp | 8204887507.6 | 1
39 | RRC.N | Range Resources Corp | 7954209450.99 | 1
40 | HESM.N | Hess Midstream LP | 7871916317.74 | 0
41 | PAA.OQ | Plains All American Pipeline LP | 7399095914.34 | 0
42 | DCP.N | DCP Midstream LP | 7259915266.76 | 0
43 | NOV.N | Nov Inc | 7220120375.4 | 0
44 | PDCE.OQ | PDC Energy Inc | 6822507151.62 | 1
45 | MTDR.N | Matador Resources Co | 6029676078.08 | 1
46 | MUR.N | Murphy Oil Corp | 5902372233.29 | 1
47 | MUSA.N | Murphy Usa Inc | 5896860494.4 | 1
48 | [NAME] | Shell Midstream Partners LP | 5549315367.07 | 0
49 | MGY.N | Magnolia Oil & Gas Corp | 5250009407.6 | 1
50 | DTM.N | DT Midstream Inc | 5245886121.52 | 0
51 | CIVI.N | Civitas Resources Inc | 5091133010.76 | 1
52 | AM.N | Antero Midstream Corp | 4910578670 | 0
53 | VNOM.OQ | Viper Energy Partners LP | 4864285082.49 | 1
54 | ENLC.N | EnLink Midstream LLC | 4689996337.5 | 0
55 | HP.N | Helmerich and Payne Inc | 4590507103.95 | 0
56 | KNTK.OQ | Kinetik Holdings Inc | 4513371319.8 | 0
57 | CHX.OQ | ChampionX Corp | 4399315702 | 0
58 | SM.N | SM Energy Co | 4303024089.87 | 1
59 | CNX.N | CNX Resources Corp | 4179315996.18 | 1
60 | WHD.N | Cactus Inc | 3872491670.08 | 0
61 | CRK.N | Comstock Resources Inc | 3854869361 | 1
62 | SUN.N | Sunoco LP | 3487306878.9 | 1
63 | HPK.OQ | Highpeak Energy Inc | 3462094815.65 | 0
64 | DEN.N | Denbury Inc | 3451792162.5 | 1
65 | PTEN.OQ | Patterson-UTI Energy Inc | 3427400052.16 | 0
66 | [NAME] | Equitrans Midstream Corp | 3405093801.76 | 0
67 | CPE.N | Callon Petroleum Co | 3337265975.31 | 1
68 | CRC.N | California Resources Corp | 3277809948 | 1
69 | PBF.N | PBF Energy Inc | 3108334209.48 | 1
70 | BSM.N | Black Stone Minerals LP | 3065671067.46 | 1
71 | LBRT.N | Liberty Energy Inc | 3035205715.01 | 0
72 | KOS.N | Kosmos Energy Ltd | 2963778183.66 | 1
73 | CEQP.N | Crestwood Equity Partners LP | 2958937834.8 | 0
74 | WLL.N | Whiting Petroleum Corp | 2951359532.64 | 1
75 | CRGY.N | Crescent Energy Co | 2805073534.4 | 1
76 | OAS.OQ | Oasis Petroleum Inc | 2643451221.78 | 1
77 | TELL.A | Tellurian Inc | 2633946461.84 | 1
78 | WFRD.OQ | Weatherford International PLC | 2475747488.88 | 0
79 | CVI.N | CVR Energy Inc | 2460989063.52 | 1
80 | NEX.N | Nextier Oilfield Solutions Inc | 2459882194.56 | 0
81 | RES.N | RPC Inc | 2275349774.94 | 0
82 | DKL.N | Delek Logistics Partners LP | 2271786777.78 | 0
83 | CDEV.OQ | Centennial Resource Development Inc | 2271379465.5 | 1
84 | HEP.N | Holly Energy Partners LP | 2258221989.86 | 0
85 | PAGP.OQ | Plains GP Holdings LP | 2180784885.71 | 0
86 | DK.N | Delek US Holdings Inc | 1959834380.28 | 1
87 | NE.N | Noble Corp (Cayman Island) | 1946394019.84 | 0
88 | NOG.N | Northern Oil and Gas Inc | 1941350324.13 | 1
89 | GPOR.N | Gulfport Energy Corp | 1887183990 | 1
90 | USAC.N | USA Compression Partners LP | 1757661257.75 | 0
91 | NS.N | NuStar Energy LP | 1695136611.98 | 0
92 | INT.N | World Fuel Services Corp | 1681595927.77 | 1
93 | MNRL.N | Brigham Minerals Inc | 1503459121.62 | 1
94 | TALO.N | Talos Energy Inc | 1482866483.91 | 1
95 | ESTE.N | Earthstone Energy Inc | 1453727202.9 | 1
96 | CLNE.OQ | Clean Energy Fuels Corp | 1447635800 | 1
97 | PUMP.N | ProPetro Holding Corp | 1418701048.56 | 0
98 | ROCC.OQ | Ranger Oil Corp | 1412539846.2 | 1
99 | GEL.N | Genesis Energy LP | 1401848688.24 | 0
100 | AROC.N | Archrock Inc | 1386796432.29 | 0
101 | OII.N | Oceaneering International Inc | 1284248475.09 | 0
102 | LPI.N | Laredo Petroleum Inc | 1283313074.4 | 1
103 | DEC.L | Diversified Energy Company PLC | 1242504501.91784 | 1
104 | ARKO.OQ | Arko Corp. | 1187517423.02 | 1
105 | CLMT.OQ | Calumet Specialty Products Partners LP | 1128217597.08 | 1
106 | KRP.N | Kimbell Royalty Partners LP | 1092628198.61 | 1
107 | DRQ.N | Dril-Quip Inc | 1067085576.29 | 0
108 | SPH.N | Suburban Propane Partners LP | 1038296444.82 | 1