select * from todays_data inner join vw_todays_etf_holdings on todays_data.ticker_symbol = vw_todays_etf_holdings.ticker_symbol where etf_ticker = 'DIA' order by weighting desc

DIA Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
BA Boeing Company 9.3% $362.42 $360.5 $360.5 $345.7 1.5  (-3%) 4
GS Goldman Sachs Group Inc. 6.7% $233.65 $233.1 $233.1 $240.6 2.0  (-6%) -2
UNH UnitedHealth Group Incorporated 6.7% $255.33 $246.9 $246.9 $238.6 2.7  (-1%) 3
MMM 3M Company 5.6% $203.63 $201.2 $201.2 $204.7 2.3  (21%) -1
HD Home Depot Inc. 5.3% $199.67 $191.4 $191.4 $185.1 2.0  (-1%) 3
AAPL Apple Inc. 5.1% $190.80 $189.7 $189.7 $181.3 1.3  (-9%) 2
MCD McDonald's Corporation 4.6% $167.05 $163.0 $163.0 $162.5 2.2  (-10%) 4
CAT Caterpillar Inc. 4.1% $153.14 $155.3 $155.3 $151.6 2.0  (-4%) 1
IBM International Business Machines Corporation 4.1% $145.20 $144.3 $144.3 $146.8 3.4  (13%) -1
TRV Travelers Companies Inc. 3.7% $128.86 $130.0 $130.0 $132.1 2.4  (-9%) -1
V Visa Inc. Class A 3.6% $135.00 $132.4 $132.4 $128.1 4.9  (2%) 4
CVX Chevron Corporation 3.6% $126.51 $125.9 $125.9 $124.4 3.2  (8%) 2
JNJ Johnson & Johnson 3.6% $122.41 $122.3 $122.3 $125.2 3.0  (-3%) -1
UTX United Technologies Corporation 3.4% $126.94 $126.7 $126.7 $124.3 3.9  (-3%) 1
JPM JPMorgan Chase & Co. 3.1% $108.03 $110.0 $110.0 $110.5 2.1  (2%) -3
DIS Walt Disney Company 2.9% $108.75 $102.7 $102.7 $101.7 3.0  (-3%) 3
AXP American Express Company 2.8% $99.76 $100.5 $100.5 $98.6 2.4  (-16%) 3
MSFT Microsoft Corporation 2.7% $101.42 $99.7 $99.7 $96.6 2.0  (-3%) 4
WMT Walmart Inc. 2.5% $83.79 $83.8 $83.8 $85.3 3.6  (0%) -1
XOM Exxon Mobil Corporation 2.2% $81.89 $81.5 $81.5 $79.6 2.6  (27%) 3
PG Procter & Gamble Company 2.0% $75.99 $74.8 $74.8 $74.8 3.5  (-6%) 2
NKE NIKE Inc. Class B 2.0% $74.70 $72.9 $72.9 $69.9 4.1  (-4%) 3
DWDP DowDuPont Inc. 1.8% $68.38 $67.5 $67.5 $66.2 2.6  (16%) 1
MRK Merck & Co. Inc. 1.6% $61.56 $60.5 $60.5 $58.9 2.0  (-2%) 4
INTC Intel Corporation 1.5% $55.54 $55.3 $55.3 $53.6 3.6  (6%) 3
VZ Verizon Communications Inc. 1.4% $47.82 $48.3 $48.3 $48.3 1.8  (-17%) 0
CSCO Cisco Systems Inc. 1.3% $44.69 $43.6 $43.6 $43.9 2.7  (11%) 1
KO Coca-Cola Company 1.2% $43.58 $43.1 $43.1 $43.1 3.3  (-2%) 2
PFE Pfizer Inc. 1.0% $36.16 $36.1 $36.1 $36.0 2.6  (-3%) 1
GE General Electric Company 0.4% $13.64 $14.2 $14.2 $14.1 3.1  (-5%) -1