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% $343.72 $352.9 $352.9 $350.5 1.6  (6%) 0
GS Goldman Sachs Group Inc. 6.7% $233.78 $233.8 $233.8 $230.0 1.3  (15%) 1
UNH UnitedHealth Group Incorporated 6.7% $261.59 $255.6 $255.6 $252.3 2.2  (-7%) 2
MMM 3M Company 5.6% $204.78 $204.0 $204.0 $201.5 2.5  (-5%) 2
HD Home Depot Inc. 5.3% $198.08 $198.9 $198.9 $197.1 2.0  (-16%) 2
AAPL Apple Inc. 5.1% $208.88 $197.1 $197.1 $191.8 1.8  (-13%) 3
MCD McDonald's Corporation 4.6% $159.30 $157.8 $157.8 $160.2 1.8  (-4%) -1
CAT Caterpillar Inc. 4.1% $138.52 $139.5 $139.5 $143.0 1.1  (-12%) -1
IBM International Business Machines Corporation 4.1% $144.77 $145.8 $145.8 $144.0 3.1  (12%) 1
TRV Travelers Companies Inc. 3.7% $129.56 $128.1 $128.1 $127.1 2.1  (28%) 2
V Visa Inc. Class A 3.6% $140.01 $140.0 $140.0 $136.3 3.9  (10%) 3
CVX Chevron Corporation 3.6% $122.53 $123.8 $123.8 $124.5 3.4  (-3%) -1
JNJ Johnson & Johnson 3.6% $131.20 $129.4 $129.4 $125.4 2.0  (-11%) 3
UTX United Technologies Corporation 3.4% $134.24 $132.5 $132.5 $128.6 3.9  (23%) 4
JPM JPMorgan Chase & Co. 3.1% $116.88 $113.8 $113.8 $109.8 1.5  (17%) 2
DIS Walt Disney Company 2.9% $114.16 $112.3 $112.3 $107.6 3.8  (19%) 4
AXP American Express Company 2.8% $102.99 $101.4 $101.4 $99.9 1.4  (-3%) 1
MSFT Microsoft Corporation 2.7% $109.67 $107.2 $107.2 $103.2 1.4  (-2%) 4
WMT Walmart Inc. 2.5% $89.01 $88.4 $88.4 $86.2 5.3  (-1%) 4
XOM Exxon Mobil Corporation 2.2% $80.32 $81.8 $81.8 $81.7 2.9  (-4%) -1
PG Procter & Gamble Company 2.0% $81.40 $80.3 $80.3 $78.2 2.8  (4%) 3
NKE NIKE Inc. Class B 2.0% $81.26 $77.9 $77.9 $76.0 1.9  (-10%) 3
DWDP DowDuPont Inc. 1.8% $69.02 $67.1 $67.1 $67.0 2.5  (-17%) 2
MRK Merck & Co. Inc. 1.6% $66.00 $64.2 $64.2 $62.5 2.2  (4%) 4
INTC Intel Corporation 1.5% $50.14 $50.8 $50.8 $52.2 3.3  (-0%) -2
VZ Verizon Communications Inc. 1.4% $53.01 $51.7 $51.7 $50.2 2.6  (-3%) 4
CSCO Cisco Systems Inc. 1.3% $43.78 $42.7 $42.7 $43.1 2.0  (-5%) -1
KO Coca-Cola Company 1.2% $46.35 $45.7 $45.7 $44.5 2.8  (9%) 4
PFE Pfizer Inc. 1.0% $41.00 $38.8 $38.8 $37.4 2.6  (-5%) 4
GE General Electric Company 0.4% $12.94 $13.3 $13.3 $13.5 1.7  (2%) -2