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.23 $24.0 $24.0 $24.6 0.4  (-31%) -2
NGG National Grid PLC ADR 3.5% $52.84 $54.6 $54.6 $55.4 0.7  (-29%) -1
BT BT Group PLC ADR 3.4% $14.88 $15.0 $15.0 $14.5 3.7  (12%) 1
ENB Enbridge Inc 3.2% $36.19 $35.3 $35.3 $33.7 11.4  (-4%) 4
PAC Grupo Aeroportuario del Pacifico SAB de CV ADR 2.9% $95.65 $99.0 $99.0 $93.9 2.5  (-40%) 1
PBA Pembina Pipeline Corp 2.7% $35.45 $35.4 $35.4 $35.0 4.5  (-1%) 1
BCE BCE Inc 2.7% $41.01 $42.0 $42.0 $41.6 4.6  (-10%) -1
AQN Algonquin Power & Utilities Corp 2.6% $10.23 $9.8 $9.8 $9.7 9.1  (33%) 3
TRP TransCanada Corp 2.4% $44.58 $44.3 $44.3 $43.2 10.0  (-8%) 4
BTI British American Tobacco PLC ADR 2.4% $54.08 $52.7 $52.7 $51.3 0.7  (-4%) 2
BIP Brookfield Infrastructure Partners LP 2.4% $41.00 $40.5 $40.5 $39.4 8.1  (11%) 3
TU TELUS Corp 2.3% $36.55 $36.3 $36.3 $35.7 10.2  (-5%) 4
CM Canadian Imperial Bank of Commerce 2.3% $91.64 $89.9 $89.9 $88.5 32.1  (-2%) 5
SNY Sanofi ADR 2.3% $41.92 $42.6 $42.6 $40.9 2.9  (3%) 3
FTS Fortis Inc/Canada 2.2% $32.85 $32.6 $32.6 $32.0 23.3  (1%) 3
BNS Bank of Nova Scotia/The 2.1% $59.02 $58.4 $58.4 $58.1 11.3  (-5%) 2
BMO Bank of Montreal 2.0% $79.87 $79.1 $79.1 $78.2 15.9  (15%) 4
WPP WPP PLC ADR 2.0% $78.00 $77.8 $77.8 $79.6 3.7  (7%) -2
TRI Thomson Reuters Corp 1.9% $42.41 $41.9 $41.9 $41.0 10.7  (-5%) 4
SU Suncor Energy Inc 1.9% $41.14 $41.3 $41.3 $40.6 2.2  (-10%) 1
RY Royal Bank of Canada 1.9% $78.14 $77.5 $77.5 $76.6 6.7  (-12%) 1
CIB Bancolombia SA ADR 1.9% $45.94 $47.4 $47.4 $47.5 2.3  (-37%) 0
UN Unilever NV 1.8% $57.28 $56.9 $56.9 $56.0 1.3  (34%) 2
TD Toronto-Dominion Bank/The 1.7% $59.59 $58.5 $58.5 $58.1 3.4  (-22%) 3
CNQ Canadian Natural Resources Ltd 1.7% $34.77 $35.7 $35.7 $34.7 2.4  (-12%) 1
ABB ABB Ltd ADR 1.7% $22.90 $22.5 $22.5 $22.5 1.6  (-9%) 2
NVS Novartis AG ADR 1.6% $83.30 $82.1 $82.1 $78.0 1.1  (45%) 3
DEO Diageo PLC ADR 1.4% $143.94 $147.7 $147.7 $146.4 1.1  (-5%) -1
RENX RELX NV ADR 1.4% $21.84 $22.2 $22.2 $21.8 2.1  (-3%) -0
INFY Infosys Ltd ADR 1.3% $20.90 $20.2 $20.2 $19.4 12.4  (3%) 5
RELX RELX PLC ADR 1.3% $21.95 $22.3 $22.3 $22.2 11.9  (14%) 1
PUK Prudential PLC ADR 1.3% $46.83 $46.3 $46.3 $47.3 0.9  (-31%) -1
MEOH Methanex Corp 1.3% $71.95 $70.5 $70.5 $70.1 6.5  (3%) 1
TSM Taiwan Semiconductor Manufacturing Co Ltd ADR 1.3% $41.84 $40.3 $40.3 $38.9 2.3  (9%) 3
MGA Magna International Inc 1.2% $53.87 $58.9 $58.9 $61.2 2.7  (-0%) -0
RBA Ritchie Bros Auctioneers Inc 1.2% $34.80 $33.2 $33.2 $34.2 8.7  (-18%) 4
IMO Imperial Oil Ltd 1.1% $32.47 $33.2 $33.2 $32.9 39.3  (3%) 2
AMX America Movil SAB de CV ADR 1.0% $17.02 $17.2 $17.2 $16.6 2.6  (-26%) 1
UGP Ultrapar Participacoes SA ADR 0.9% $11.56 $11.5 $11.5 $12.1 2.8  (-11%) -2
CNI Canadian National Railway Co 0.9% $89.19 $87.5 $87.5 $84.4 3.8  (-16%) 4
IHG InterContinental Hotels Group PLC ADR 0.8% $61.24 $63.1 $63.1 $64.0 3.3  (-37%) 0
BAM Brookfield Asset Management Inc 0.8% $43.67 $42.0 $42.0 $41.3 10.5  (-6%) 4
CAE CAE Inc 0.8% $20.83 $20.8 $20.8 $20.9 1.4  (-25%) 0
SAP SAP SE ADR 0.8% $115.69 $117.8 $117.8 $117.4 2.7  (14%) 0
STE STERIS PLC 0.8% $114.74 $113.0 $113.0 $108.9 5.8  (13%) 5
DOX Amdocs Ltd 0.7% $64.58 $67.1 $67.1 $67.7 5.3  (26%) 0
PNR Pentair PLC 0.7% $43.68 $43.5 $43.5 $43.4 2.4  (31%) 1
FNV Franco-Nevada Corp 0.7% $72.18 $73.1 $73.1 $72.0 5.7  (20%) 3
GIL Gildan Activewear Inc 0.7% $30.73 $28.5 $28.5 $28.5 8.8  (-7%) 2
WLTW Willis Towers Watson PLC 0.7% $151.61 $156.6 $156.6 $155.2 3.0  (-13%) -1
AON Aon PLC 0.6% $142.98 $144.9 $144.9 $141.7 2.4  (8%) 2
FMS Fresenius Medical Care AG & Co KGaA ADR 0.5% $48.72 $49.6 $49.6 $50.0 4.2  (-22%) -1
SHPG Shire PLC ADR 0.5% $173.78 $172.5 $172.5 $167.3 1.8  (-36%) 2
MFGP Micro Focus International PLC ADR 0.4% $16.12 $16.4 $16.4 $17.1 0.7  (-26%) -1
ASML ASML Holding NV 0.4% $209.17 $212.4 $212.4 $206.7 2.4  (10%) 3
HDB HDFC Bank Ltd ADR 0.3% $104.22 $107.8 $107.8 $106.1 2.4  (-7%) 0
GGAL Grupo Financiero Galicia SA ADR 0.1% $33.95 $35.6 $35.6 $38.4 0.8  (-37%) -1