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

PBJ Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
SYY Sysco Corp 5.4% $70.03 $70.0 $70.0 $68.4 6.0  (3%) 4
STZ Constellation Brands Inc 5.4% $214.78 $213.9 $213.9 $220.8 2.7  (-6%) -2
MCD McDonald's Corp 5.1% $159.30 $157.8 $157.8 $160.2 1.8  (-4%) -1
TSN Tyson Foods Inc 4.6% $59.70 $62.2 $62.2 $66.4 2.4  (5%) -2
KR Kroger Co/The 4.6% $29.82 $28.9 $28.9 $27.7 5.8  (-1%) 5
MDLZ Mondelez International Inc 4.4% $42.16 $42.6 $42.6 $41.4 1.3  (-11%) 3
MNST Monster Beverage Corp 4.1% $60.98 $60.6 $60.6 $57.7 3.3  (-16%) 3
GIS General Mills Inc 3.9% $45.27 $44.7 $44.7 $44.4 6.4  (1%) 4
SAM Boston Beer Co Inc/The 3.8% $277.85 $298.8 $298.8 $290.1 8.4  (1%) 3
WMK Weis Markets Inc 3.3% $48.81 $51.2 $51.2 $53.0 20.0  (2%) 1
LW Lamb Weston Holdings Inc 3.3% $71.63 $70.6 $70.6 $68.4 2.7  (-9%) 3
CALM Cal-Maine Foods Inc 3.0% $46.90 $45.4 $45.4 $47.5 13.7  (4%) 1
CVGW Calavo Growers Inc 3.0% $96.45 $94.3 $94.3 $93.0 39.0  (-1%) 1
FLO Flowers Foods Inc 3.0% $19.46 $20.4 $20.4 $20.5 9.1  (11%) 0
HRL Hormel Foods Corp 3.0% $37.12 $36.9 $36.9 $36.6 16.8  (9%) 3
ADM Archer-Daniels-Midland Co 2.9% $50.24 $48.2 $48.2 $46.7 2.7  (6%) 4
PFGC Performance Food Group Co 2.9% $36.90 $37.5 $37.5 $36.9 1.1  (1%) 1
USFD US Foods Holding Corp 2.9% $33.20 $37.2 $37.2 $37.4 1.9  (-1%) -1
UNFI United Natural Foods Inc 2.9% $34.34 $38.3 $38.3 $41.0 3.7  (-13%) -1
DNKN Dunkin' Brands Group Inc 2.8% $71.64 $71.1 $71.1 $69.3 7.0  (-12%) 4
CAG Conagra Brands Inc 2.8% $36.78 $36.5 $36.5 $36.9 5.3  (20%) 2
SEB Seaboard Corp 2.7% $3,664.83 $3,744.2 $3,744.2 $3,880.6 11.5  (2%) -1
NOMD Nomad Foods Ltd 2.7% $19.84 $19.0 $19.0 $18.8 0.3  (-1%) 3
SFM Sprouts Farmers Market Inc 2.6% $23.08 $22.3 $22.3 $22.0 11.4  (3%) 4
SAFM Sanderson Farms Inc 2.6% $102.05 $100.8 $100.8 $102.0 10.5  (-3%) 1
SJM JM Smucker Co/The 2.6% $110.70 $110.6 $110.6 $108.4 11.6  (1%) 3
ANDE Andersons Inc/The 2.6% $40.35 $35.5 $35.5 $34.8 12.9  (4%) 5
SMPL Simply Good Foods Co/The 2.5% $17.35 $16.9 $16.9 $15.2 14.0  (1%) 4
CPB Campbell Soup Co 2.5% $42.28 $41.2 $41.2 $39.1 11.7  (-12%) 3
PPC Pilgrim's Pride Corp 2.4% $17.45 $18.2 $18.2 $19.3 5.5  (-2%) -1