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% $66.48 $65.2 $65.2 $63.3 4.9  (12%) 4
STZ Constellation Brands Inc 5.4% $232.18 $223.1 $223.1 $224.9 2.6  (11%) 3
MCD McDonald's Corp 5.1% $167.05 $163.0 $163.0 $162.5 2.2  (-10%) 4
TSN Tyson Foods Inc 4.6% $70.99 $69.4 $69.4 $69.4 3.1  (-11%) 0
KR Kroger Co/The 4.6% $26.16 $25.0 $25.0 $24.6 7.3  (-18%) 4
MDLZ Mondelez International Inc 4.4% $40.40 $39.7 $39.7 $40.0 1.6  (25%) 1
MNST Monster Beverage Corp 4.1% $56.05 $52.0 $52.0 $53.4 1.6  (-10%) 1
GIS General Mills Inc 3.9% $44.51 $42.9 $42.9 $43.4 5.8  (4%) 2
SAM Boston Beer Co Inc/The 3.8% $285.75 $254.9 $254.9 $235.0 17.2  (2%) 5
WMK Weis Markets Inc 3.3% $53.10 $53.6 $53.6 $48.7 13.3  (-3%) 5
LW Lamb Weston Holdings Inc 3.3% $65.85 $65.4 $65.4 $65.2 4.8  (3%) 2
CALM Cal-Maine Foods Inc 3.0% $50.65 $48.2 $48.2 $48.0 16.2  (5%) 5
CVGW Calavo Growers Inc 3.0% $91.45 $89.4 $89.4 $92.6 32.3  (-1%) 1
FLO Flowers Foods Inc 3.0% $20.28 $20.2 $20.2 $21.5 4.1  (2%) 0
HRL Hormel Foods Corp 3.0% $36.11 $36.1 $36.1 $35.9 17.5  (-1%) 3
ADM Archer-Daniels-Midland Co 2.9% $45.24 $44.7 $44.7 $44.7 1.5  (-23%) 2
PFGC Performance Food Group Co 2.9% $35.65 $35.4 $35.4 $33.4 1.3  (22%) 2
USFD US Foods Holding Corp 2.9% $37.28 $36.4 $36.4 $35.0 4.0  (26%) 4
UNFI United Natural Foods Inc 2.9% $40.92 $44.5 $44.5 $44.7 17.0  (-6%) 0
DNKN Dunkin' Brands Group Inc 2.8% $68.47 $65.9 $65.9 $63.6 10.5  (-4%) 5
CAG Conagra Brands Inc 2.8% $38.20 $37.4 $37.4 $37.2 3.7  (15%) 2
SEB Seaboard Corp 2.7% $3,945.00 $3,990.3 $3,990.3 $4,028.3 13.0  (-9%) -1
NOMD Nomad Foods Ltd 2.7% $18.07 $17.9 $17.9 $17.0 0.4  (-41%) 2
SFM Sprouts Farmers Market Inc 2.6% $21.41 $21.7 $21.7 $22.7 5.2  (-0%) -1
SAFM Sanderson Farms Inc 2.6% $103.14 $102.9 $102.9 $109.3 14.9  (9%) 0
SJM JM Smucker Co/The 2.6% $103.75 $107.0 $107.0 $113.1 10.2  (13%) 0
ANDE Andersons Inc/The 2.6% $34.45 $33.1 $33.1 $32.7 8.0  (-4%) 3
SMPL Simply Good Foods Co/The 2.5% $13.59 $13.6 $13.6 $13.3 6.1  (5%) 2
CPB Campbell Soup Co 2.5% $36.51 $34.5 $34.5 $38.7 9.9  (14%) 0
PPC Pilgrim's Pride Corp 2.4% $20.66 $20.4 $20.4 $21.6 5.8  (-24%) -1