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

PID Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
VOD Vodafone Group PLC ADR 3.5% $24.98 $26.0 $26.0 $27.8 2.7  (-12%) -2
NGG National Grid PLC ADR 3.5% $55.59 $57.1 $57.1 $57.5 0.9  (-14%) -1
BT BT Group PLC ADR 3.4% $14.20 $13.8 $13.8 $15.4 2.1  (150%) -1
ENB Enbridge Inc 3.2% $32.60 $31.6 $31.6 $31.6 8.8  (10%) 2
PAC Grupo Aeroportuario del Pacifico SAB de CV ADR 2.9% $87.25 $85.1 $85.1 $94.9 2.9  (17%) -1
PBA Pembina Pipeline Corp 2.7% $34.56 $34.4 $34.4 $33.3 3.6  (13%) 2
BCE BCE Inc 2.7% $41.48 $42.1 $42.1 $42.3 3.9  (3%) -1
AQN Algonquin Power & Utilities Corp 2.6% $9.59 $9.7 $9.7 $9.8 4.5  (5%) -2
TRP TransCanada Corp 2.4% $41.65 $42.0 $42.0 $42.5 6.6  (6%) -1
BTI British American Tobacco PLC ADR 2.4% $49.60 $50.3 $50.3 $53.1 1.7  (1%) -2
BIP Brookfield Infrastructure Partners LP 2.4% $38.90 $38.1 $38.1 $39.5 5.5  (15%) -1
TU TELUS Corp 2.3% $35.30 $35.4 $35.4 $35.5 10.1  (-14%) 0
CM Canadian Imperial Bank of Commerce 2.3% $88.00 $88.7 $88.7 $88.3 36.3  (-8%) -1
SNY Sanofi ADR 2.3% $38.98 $38.7 $38.7 $39.3 1.8  (8%) -1
FTS Fortis Inc/Canada 2.2% $31.02 $31.9 $31.9 $32.8 46.5  (-2%) -1
BNS Bank of Nova Scotia/The 2.1% $58.06 $60.2 $60.2 $60.9 8.8  (-5%) -1
BMO Bank of Montreal 2.0% $77.73 $78.2 $78.2 $77.1 14.9  (-7%) 2
WPP WPP PLC ADR 2.0% $81.80 $84.6 $84.6 $83.8 6.3  (-12%) 0
TRI Thomson Reuters Corp 1.9% $41.08 $39.5 $39.5 $39.5 2.3  (-8%) 3
SU Suncor Energy Inc 1.9% $39.84 $40.3 $40.3 $39.0 2.0  (30%) 2
RY Royal Bank of Canada 1.9% $76.31 $76.9 $76.9 $76.8 10.3  (1%) -1
CIB Bancolombia SA ADR 1.9% $46.99 $46.4 $46.4 $47.5 1.8  (102%) 1
UN Unilever NV 1.8% $54.04 $56.0 $56.0 $56.2 1.6  (-9%) -2
TD Toronto-Dominion Bank/The 1.7% $58.19 $58.4 $58.4 $57.3 5.5  (-2%) 2
CNQ Canadian Natural Resources Ltd 1.7% $32.07 $34.7 $34.7 $35.0 0.7  (-30%) -1
ABB ABB Ltd ADR 1.7% $23.47 $23.5 $23.5 $23.4 3.2  (-11%) 1
NVS Novartis AG ADR 1.6% $75.98 $75.9 $75.9 $77.5 0.8  (-23%) -1
DEO Diageo PLC ADR 1.4% $147.98 $146.4 $146.4 $143.4 3.3  (93%) 3
RENX RELX NV ADR 1.4% $21.28 $21.8 $21.8 $21.5 1.0  (-42%) 1
INFY Infosys Ltd ADR 1.3% $18.16 $18.2 $18.2 $17.7 22.4  (-2%) 4
RELX RELX PLC ADR 1.3% $21.83 $22.4 $22.4 $22.0 0.3  (-50%) 1
PUK Prudential PLC ADR 1.3% $49.68 $50.1 $50.1 $51.0 1.6  (19%) -2
MEOH Methanex Corp 1.3% $68.40 $69.6 $69.6 $66.9 6.3  (-7%) 3
TSM Taiwan Semiconductor Manufacturing Co Ltd ADR 1.3% $38.60 $39.1 $39.1 $39.9 3.5  (6%) -2
MGA Magna International Inc 1.2% $65.51 $65.4 $65.4 $62.4 3.4  (8%) 3
RBA Ritchie Bros Auctioneers Inc 1.2% $35.43 $34.4 $34.4 $33.5 12.4  (-9%) 5
IMO Imperial Oil Ltd 1.1% $32.92 $32.6 $32.6 $31.2 40.8  (1%) 4
AMX America Movil SAB de CV ADR 1.0% $15.98 $15.8 $15.8 $17.4 5.4  (-17%) 0
UGP Ultrapar Participacoes SA ADR 0.9% $12.84 $13.5 $13.5 $15.9 3.1  (-2%) -2
CNI Canadian National Railway Co 0.9% $83.57 $83.4 $83.4 $79.5 7.9  (10%) 4
IHG InterContinental Hotels Group PLC ADR 0.8% $66.55 $65.7 $65.7 $63.9 3.4  (32%) 3
BAM Brookfield Asset Management Inc 0.8% $42.03 $40.7 $40.7 $39.9 8.5  (-7%) 4
CAE CAE Inc 0.8% $21.01 $20.6 $20.6 $19.7 0.9  (-20%) 4
SAP SAP SE ADR 0.8% $121.38 $115.5 $115.5 $112.5 4.4  (26%) 4
STE STERIS PLC 0.8% $106.63 $104.9 $104.9 $99.9 4.9  (-4%) 4
DOX Amdocs Ltd 0.7% $69.91 $67.7 $67.7 $67.1 2.8  (13%) 3
PNR Pentair PLC 0.7% $43.78 $44.7 $44.7 $53.6 0.8  (14%) -1
FNV Franco-Nevada Corp 0.7% $69.73 $70.7 $70.7 $71.1 4.9  (1%) -1
GIL Gildan Activewear Inc 0.7% $28.90 $29.0 $29.0 $29.1 17.3  (2%) -1
WLTW Willis Towers Watson PLC 0.7% $156.04 $154.9 $154.9 $152.2 1.9  (10%) 1
AON Aon PLC 0.6% $140.21 $141.4 $141.4 $141.6 2.9  (-9%) 0
FMS Fresenius Medical Care AG & Co KGaA ADR 0.5% $51.45 $50.8 $50.8 $50.7 4.7  (-11%) 2
SHPG Shire PLC ADR 0.5% $162.77 $163.8 $163.8 $161.5 0.8  (-11%) 2
MFGP Micro Focus International PLC ADR 0.4% $18.17 $17.9 $17.9 $17.5 1.4  (35%) 1
ASML ASML Holding NV 0.4% $215.89 $204.5 $204.5 $200.7 4.3  (-15%) 4
HDB HDFC Bank Ltd ADR 0.3% $101.57 $101.1 $101.1 $98.9 0.7  (-27%) 2
GGAL Grupo Financiero Galicia SA ADR 0.1% $40.49 $45.2 $45.2 $53.6 0.9  (41%) -1