Skip to content

13F-HR filed by First PREMIER Bank

First PREMIER Bank filed this 13F-HR for the quarter ended 2023-06-30, filed 2023-07-13, with 372 holding rows worth $350,175,000.

Accession
0001653926-23-000003
Filed
2023-07-13
Accepted by EDGAR
acceptance time not in the bulk data set
Ingested
Source
SEC quarterly data set

Original filing

13F report for Q2 2023

A holdings report, 659 entries on the cover page, a total value of $350,175,000 stated on the cover page (in dollars after the unit check, H1), rows summing to $350,175,000 with VALUE read as thousands, detected and multiplied, 13F file number 028-17067. The quarter's positions are built on this report. The resolved quarter.

The information table after summing rows of one CUSIP and put or call (H4), with the CUSIP and issuer name as filed. Values in dollars after the unit check (method).

Issuer as filedCUSIPClassAmountValueValue read asType
VTI922908769COM119,746$26,377,000thousands, detected and multiplied
Apple Inc037833100COM93,986$18,230,000thousands, detected and multiplied
Vanguard Value ETF922908744SHS125,409$17,821,000thousands, detected and multiplied
INVESCO ACTIVELY MANAGED EXC46090A705S&P500 DOWNSID424,020$14,124,000thousands, detected and multiplied
Procter & Gamble Co742718109COM58,199$8,830,000thousands, detected and multiplied
Microsoft Corp594918104COM23,248$7,917,000thousands, detected and multiplied
VGT92204A702SHS17,734$7,841,000thousands, detected and multiplied
Johnson & Johnson478160104COM46,297$7,662,000thousands, detected and multiplied
INVESCO EXCH TRADED FD TR II46138E354S&P500 LOW VOL115,505$7,255,000thousands, detected and multiplied
Union Pacific Corporation907818108COM33,031$6,758,000thousands, detected and multiplied
Southern Company842587107COM93,685$6,581,000thousands, detected and multiplied
NORTHWESTERN ENERGY GROUP INC COM NEW668074305Stock110,612$6,278,000thousands, detected and multiplied
Duke Energy Corporation26441C204COM68,566$6,153,000thousands, detected and multiplied
Vanguard FTSE All-World ex-US ETF922042775SHS110,841$6,030,000thousands, detected and multiplied
Vanguard Small-Cap ETF922908751SHS28,946$5,757,000thousands, detected and multiplied
MasterCard, Inc57636Q104COM14,597$5,741,000thousands, detected and multiplied
Vanguard High Dividend Yield ETF921946406SHS52,250$5,541,000thousands, detected and multiplied
Berkshire Hathaway Inc084670702COM15,362$5,238,000thousands, detected and multiplied
VANGUARD HEALTH CARE ETF92204A504ETF21,121$5,171,000thousands, detected and multiplied
XCELENERGY INC98389B100COM82,964$5,158,000thousands, detected and multiplied
McDonalds Corporation580135101COM17,120$5,109,000thousands, detected and multiplied
PepsiCo,Inc.713448108COM27,103$5,020,000thousands, detected and multiplied
Vanguard Mid-Cap ETF922908629SHS22,346$4,920,000thousands, detected and multiplied
Vanguard FTSE Developed Markets ETF921943858SHS104,452$4,824,000thousands, detected and multiplied
PUBLIC SVC ENTERPRISE GROUP COM744573106Stock63,251$3,960,000thousands, detected and multiplied
SPDR Portfolio S&P 500 High Dividend ETF78468R788SHS102,117$3,787,000thousands, detected and multiplied
INVESCO EXCH TRADED FD TR II46138E511PFD ETF332,545$3,781,000thousands, detected and multiplied
Vanguard Real Estate922908553SHS42,660$3,565,000thousands, detected and multiplied
AMPLIFY ETF TR032108888BLACKSWAN GRWT137,285$3,533,000thousands, detected and multiplied
Raytheon Technologies Corporation75513E101COM35,615$3,489,000thousands, detected and multiplied
Merck & Co.,Inc.58933Y105COM29,061$3,354,000thousands, detected and multiplied
Pfizer Inc.717081103COM88,849$3,259,000thousands, detected and multiplied
SPY78462F103SHS6,970$3,089,000thousands, detected and multiplied
Coca-Cola Company191216100COM51,283$3,088,000thousands, detected and multiplied
JPMorgan Chase & Co46625H100COM20,711$3,012,000thousands, detected and multiplied
EMERSON ELEC CO COM291011104Stock32,864$2,971,000thousands, detected and multiplied
FIRST TRUST TCW OPPORTUNISTIC33740F805TCW OPPORTUNIS67,185$2,968,000thousands, detected and multiplied
Mondelez International,Inc. Class A609207105COM40,116$2,926,000thousands, detected and multiplied
Automatic Data Processing,Inc.053015103COM13,125$2,885,000thousands, detected and multiplied
CSX Corporation126408103COM84,002$2,865,000thousands, detected and multiplied
USBANCORPDEL902973304COM NEW72,676$2,401,000thousands, detected and multiplied
Amgen Inc.031162100COM10,041$2,230,000thousands, detected and multiplied
Vanguard Growth922908736COM7,876$2,228,000thousands, detected and multiplied
EVERGY INC COM30034W106Stock38,045$2,223,000thousands, detected and multiplied
Vanguard Dividend Appreciation ETF921908844SHS13,383$2,173,000thousands, detected and multiplied
VWO922042858SHS52,835$2,149,000thousands, detected and multiplied
Vanguard S&P 500 ETF922908363COM5,136$2,092,000thousands, detected and multiplied
Waste Management, Inc.94106L109COM11,750$2,038,000thousands, detected and multiplied
FIRST TR EXCHANGE-TRADED FD33737K205INDXX NEXTG ETF26,547$1,905,000thousands, detected and multiplied
Vanguard Total Bond Market ETF921937835SHS26,075$1,895,000thousands, detected and multiplied
INVESCO EXCHANGE-TRADED FD TR S&P 500 EQUAL WEIGHT ETF46137V357COM12,530$1,875,000thousands, detected and multiplied
Amazon.com, Inc023135106COM14,131$1,842,000thousands, detected and multiplied
EVERSOURCE ENERGY COM30040W108Stock25,259$1,792,000thousands, detected and multiplied
BLACK HILLS CORP COM092113109Stock27,863$1,679,000thousands, detected and multiplied
BERKSHIRE HATHAWAY INC DEL084670108CL A3$1,553,000thousands, detected and multiplied
Walmart Inc.931142103COM9,867$1,551,000thousands, detected and multiplied
JPMORGAN EQUITY PREMIUM INCOME ETF46641Q332ETF24,943$1,380,000thousands, detected and multiplied
Chevron Corporation166764100COM7,369$1,160,000thousands, detected and multiplied
CVS Health Corporation126650100COM16,501$1,141,000thousands, detected and multiplied
FIRST TR EXCHANGE-TRADED FD33733E104CAP STRENGTH ETF15,073$1,132,000thousands, detected and multiplied
INVESCO QQQ TR46090E103COM2,955$1,091,000thousands, detected and multiplied
Vanguard Short-Term Bond ETF921937827SHS14,444$1,091,000thousands, detected and multiplied
AbbVie,Inc.00287Y109COM7,990$1,076,000thousands, detected and multiplied
ALPS ETF TR00162Q452ALERIAN MLP27,052$1,061,000thousands, detected and multiplied
Starbucks Corporation855244109COM10,677$1,059,000thousands, detected and multiplied
WISDOMTREE TR97717Y527FLOATNG RAT TREA20,988$1,056,000thousands, detected and multiplied
LAMAR ADVERTISING CO CL A512816109REIT10,637$1,055,000thousands, detected and multiplied
ISHARES TR46432F859CORE 1 5 YR USD22,448$1,047,000thousands, detected and multiplied
iShares 0-5 Year TIPS Bond ETF46429B747SHS10,717$1,046,000thousands, detected and multiplied
Vanguard International High Dividend Yield ETF921946794SHS16,380$1,035,000thousands, detected and multiplied
INVESCO HIGH YIELD EQUITY DIVIDEND ACHIEVERS ETF46137V563ETF53,052$1,020,000thousands, detected and multiplied
Qualcomm Incorporated747525103COM8,096$964,000thousands, detected and multiplied
STATE STR SPDR DOW JONES IND78467X109UT SER 12,800$963,000thousands, detected and multiplied
Abbott Laboratories002824100COM8,647$943,000thousands, detected and multiplied
Technology Select Sector SPDR Fund81369Y803SHS5,408$940,000thousands, detected and multiplied
Lockheed Martin Corporation539830109COM2,013$927,000thousands, detected and multiplied
Verizon Communications Inc92343V104COM24,761$921,000thousands, detected and multiplied
LATTICE STRATEGIES TR518416409HARTFORD US EQTY21,560$893,000thousands, detected and multiplied
Bank of America Corp060505104COM30,847$885,000thousands, detected and multiplied
Intel Corp458140100COM26,099$873,000thousands, detected and multiplied
Gilead Sciences,Inc.375558103COM11,278$868,000thousands, detected and multiplied
VANGUARD WORLD FD92204A405FINANCIALS ETF10,414$846,000thousands, detected and multiplied
Cisco Systems,Inc.17275R102COM15,920$824,000thousands, detected and multiplied
LATTICE STRATEGIES TR518416102HARTFORD MLT ETF30,700$808,000thousands, detected and multiplied
MDU RES GROUP INC552690109COM38,417$805,000thousands, detected and multiplied
NVIDIA Corp67066G104COM1,892$801,000thousands, detected and multiplied
Bristol-Myers Squibb Company110122108COM11,708$749,000thousands, detected and multiplied
ENBRIDGE INC COM29250N105Stock19,057$708,000thousands, detected and multiplied
Vanguard Total World Stock ETF922042742SHS7,250$703,000thousands, detected and multiplied
SAB BIOTHERAPEUTICS INC78397T103COM807,535$670,000thousands, detected and multiplied
iShares Core S&P Small-Cap ETF464287804SHS6,525$651,000thousands, detected and multiplied
CAPITAL ONE FINL CORP14040H105COM5,557$608,000thousands, detected and multiplied
KRAFT HEINZ CO COM500754106Stock16,941$601,000thousands, detected and multiplied
ISHARES TR CORE S&P 500 ETF464287200SHS1,343$599,000thousands, detected and multiplied
SYSCOCORP871829107COM7,542$560,000thousands, detected and multiplied
BLACKSTONE INC09260D107COM6,000$558,000thousands, detected and multiplied
PAYCHEX INC704326107COM4,937$552,000thousands, detected and multiplied
VANECK ETF TRUST92189F411BDC INCOME ETF35,712$549,000thousands, detected and multiplied
Citigroup Inc.172967424COM11,624$535,000thousands, detected and multiplied
Visa Inc92826C839COM2,193$521,000thousands, detected and multiplied
Vanguard Intermediate-Term Treasury ETF92206C706SHS8,358$490,000thousands, detected and multiplied
EXXON MOBIL CORP30231G102COM4,543$487,000thousands, detected and multiplied
NORFOLK SOUTHN CORP COM655844108Stock2,133$483,000thousands, detected and multiplied
General Electric Company369604301COM4,273$469,000thousands, detected and multiplied
ALPS ETF TR00162Q858SECTR DIV DOGS9,230$461,000thousands, detected and multiplied
TRI CONTL CORP895436103COM16,574$454,000thousands, detected and multiplied
OCCIDENTAL PETE CORP674599105COM7,443$438,000thousands, detected and multiplied
CLOROX CO DEL189054109COM2,703$430,000thousands, detected and multiplied
Thermo Fisher Scientific Inc.883556102COM816$426,000thousands, detected and multiplied
Medtronic PlcG5960L103COM4,829$425,000thousands, detected and multiplied
KNIFE RIVER CORP COMMON STOCK498894104Stock9,603$419,000thousands, detected and multiplied
Honeywell Technologies438516106COM1,978$411,000thousands, detected and multiplied
Vanguard Intermediate-Term Corporate Bond ETF92206C870SHS5,119$405,000thousands, detected and multiplied
iShares Russell Midcap ETF464287499SHS5,482$401,000thousands, detected and multiplied
IJH464287507COM1,511$395,000thousands, detected and multiplied
ON SEMICONDUCTOR CORP COM682189105Stock4,000$378,000thousands, detected and multiplied
Vanguard Consumer Staples ETF92204A207SHS1,936$376,000thousands, detected and multiplied
Health Care Select Sector SPDR Fund81369Y209SHS2,768$368,000thousands, detected and multiplied
CME Group Inc. Class A12572Q105COM1,974$365,000thousands, detected and multiplied
Wells Fargo & Company949746101COM8,340$356,000thousands, detected and multiplied
VANGUARD INDEX FDS922908637LARGE CAP ETF1,734$352,000thousands, detected and multiplied
FIRST TR EXCHANGE-TRADED FD33733E500NAS CLNEDG GREEN6,112$313,000thousands, detected and multiplied
DAKTRONICS INC234264109COM48,117$308,000thousands, detected and multiplied
Financial Select Sector SPDR Fund81369Y605SHS9,100$307,000thousands, detected and multiplied
ALERUS FINL CORP01446U103COM17,036$306,000thousands, detected and multiplied
Boeing Company097023105COM1,411$298,000thousands, detected and multiplied
CUMMINS INC COM231021106Stock1,211$297,000thousands, detected and multiplied
iShares Gold Trust464285204COM8,100$295,000thousands, detected and multiplied
WEYERHAEUSER CO COM NEW962166104REIT8,793$295,000thousands, detected and multiplied
META PLATFORMS INC CL A30303M102COM1,000$287,000thousands, detected and multiplied
Vanguard Utilities ETF92204A876SHS2,011$286,000thousands, detected and multiplied
ISHARES RUSSELL 1000 VALUE ETF464287598ETF1,780$281,000thousands, detected and multiplied
LISTED FDS TR53656F847CORE ALT FD10,060$281,000thousands, detected and multiplied
BROOKFIELD INFRASTRUCTURE PAG16252101LP INT UNIT7,582$277,000thousands, detected and multiplied
Vanguard Energy ETF92204A306SHS2,431$274,000thousands, detected and multiplied
DNP SELECT INCOME FD INC23325P104COM25,298$265,000thousands, detected and multiplied
SELECT SECTOR SPDR TR81369Y704INDL2,424$260,000thousands, detected and multiplied
Caterpillar Inc.149123101COM1,049$259,000thousands, detected and multiplied
DUPONT DE NEMOURS INC COM26614N102Stock3,524$252,000thousands, detected and multiplied
Eli Lilly and Company532457108COM532$249,000thousands, detected and multiplied
Vanguard Consumer Discretionary ETF92204A108SHS799$226,000thousands, detected and multiplied
SELECT SECTOR SPDR TR81369Y407SBI CONS DISCR1,327$226,000thousands, detected and multiplied
GSK PLC SPONSORED ADR37733W204ADR6,348$225,000thousands, detected and multiplied
Home Depot, Inc437076102COM719$223,000thousands, detected and multiplied
Costco Wholesale Corporation22160K105COM409$220,000thousands, detected and multiplied
VANGUARD STAR FDS921909768COM3,873$217,000thousands, detected and multiplied
ASMLHLDGNVFSPONSOREDADR1ADRREPS1ORDSHSN07059210STOK297$215,000thousands, detected and multiplied
BLACKSTONE MORTGAGE TRUST INC COM CL A09257W100REIT10,315$215,000thousands, detected and multiplied
J P MORGAN EXCHANGE TRADED F BETABULDRS JAPAN46641Q217BETABULDRS JAPAN4,181$215,000thousands, detected and multiplied
FORD MTR CO COM345370860Stock14,006$212,000thousands, detected and multiplied
United Parcel Service,Inc. Class B911312106COM1,173$210,000thousands, detected and multiplied
International Business Machines Corporation459200101COM1,562$209,000thousands, detected and multiplied
ENERGY TRANSFER L P29273V100COM UT LTD PTN15,288$195,000thousands, detected and multiplied
DOW HLDGS INC COM260557103Stock3,628$194,000thousands, detected and multiplied
Communication Services Select Sector SPDR Fund81369Y852SHS2,964$193,000thousands, detected and multiplied
VANGUARD WORLD FD92204A603INDUSTRIAL ETF941$193,000thousands, detected and multiplied
NIKE,Inc. Class B654106103COM1,690$187,000thousands, detected and multiplied
FREEPORT MCMORAN INC CL B35671D857Stock4,500$180,000thousands, detected and multiplied
PRUDENTIAL FINL INC COM744320102Stock2,024$179,000thousands, detected and multiplied
CARDINAL HEALTH INC14149Y108COM1,855$175,000thousands, detected and multiplied
Energy Select Sector SPDR Fund81369Y506SHS2,133$174,000thousands, detected and multiplied
ISHARESRUSSELL1000GROWTHETF464287614STOK633$174,000thousands, detected and multiplied
COMPASS MINERALS INTL INC20451N101COM4,770$162,000thousands, detected and multiplied
ISHARES TR46428743220 YR TR BD ETF1,519$156,000thousands, detected and multiplied
Vanguard Small-Cap Value ETF922908611SHS910$151,000thousands, detected and multiplied
SHELL PLC SPON ADS780259305ADR2,500$151,000thousands, detected and multiplied
AT&T Inc00206R102COM9,343$149,000thousands, detected and multiplied
Lowes Companies,Inc.548661107COM615$139,000thousands, detected and multiplied
Vanguard Mid-Cap Value ETF922908512SHS981$136,000thousands, detected and multiplied
Avantis US Small Cap Value ETF025072877SHS1,707$133,000thousands, detected and multiplied
iShares iBoxx Inv Grade Corporate Bond ETF464287242SHS1,229$133,000thousands, detected and multiplied
Schlumberger Limited806857108COM2,700$132,000thousands, detected and multiplied
iShares S&P 500 Value ETF464287408SHS817$132,000thousands, detected and multiplied
GLOBAL X FDS37954Y830GLOBAL X COPPER3,500$132,000thousands, detected and multiplied
iShares S&P 500 Growth ETF464287309SHS1,864$131,000thousands, detected and multiplied
iShares Core MSCI EAFE ETF46432F842SHS1,898$128,000thousands, detected and multiplied
ConocoPhillips20825C104COM1,222$127,000thousands, detected and multiplied
FISERV INC337738108COM1,000$126,000thousands, detected and multiplied
SELECT SECTOR SPDR TR81369Y308STATE STREET CON1,634$121,000thousands, detected and multiplied
GLOBAL X FDS37954Y442CLOUD COMPUTNG6,120$121,000thousands, detected and multiplied
iShares MSCI USA Momentum Factor ETF46432F396SHS834$120,000thousands, detected and multiplied
NOVARTIS AG SPONSORED ADR66987V109ADR1,190$120,000thousands, detected and multiplied
TEREX CORP NEW COM880779103Stock2,000$120,000thousands, detected and multiplied
UnitedHealth Group Inc91324P102COM240$115,000thousands, detected and multiplied
ISHARES TR46429B333GNMA BOND ETF2,592$114,000thousands, detected and multiplied
SHOCKWAVE MED INC82489T104COM400$114,000thousands, detected and multiplied
AMPLIFY ETF TR032108607BLOCK TECHN ETF4,983$113,000thousands, detected and multiplied
SSGA ACTIVE ETF TR78467V848ST STR TOTAL ETF2,633$107,000thousands, detected and multiplied
Vanguard Communication Services ETF92204A884SHS949$101,000thousands, detected and multiplied
FIRSTENERGY CORP337932107COM2,510$98,000thousands, detected and multiplied
GENERAL MTRS CO COM37045V100Stock2,500$96,000thousands, detected and multiplied
iShares U.S. Treasury Bond ETF46429B267SHS4,045$93,000thousands, detected and multiplied
GE HEALTHCARE TECHNOLOGIES INC COMMON STOCK36266G107Stock1,119$91,000thousands, detected and multiplied
Alphabet Inc. Reg. Shares C02079K107COM740$89,000thousands, detected and multiplied
BHP BILLITON LIMITED SPONSORED ADS088606108ADR1,462$87,000thousands, detected and multiplied
APA CORPORATION COM03743Q108Stock2,457$84,000thousands, detected and multiplied
SELECT SECTOR SPDR TR81369Y100SBI MATERIALS1,000$83,000thousands, detected and multiplied
Vanguard Mid-Cap Growth ETF922908538SHS395$82,000thousands, detected and multiplied
AUTODESK INC COM052769106Stock400$82,000thousands, detected and multiplied
CELANESE CORP DEL COM150870103Stock700$81,000thousands, detected and multiplied
iShares Core S&P Total U.S. Stock Market ETF464287150SHS822$80,000thousands, detected and multiplied
VANGUARD S&P SMALL-CAP 600 ETF921932828ETF858$79,000thousands, detected and multiplied
USA COMPRESSION PARTNERS LP90290N109COM UNIT LTDPAR4,000$79,000thousands, detected and multiplied
EXELON CORP COM30161N101Stock1,883$77,000thousands, detected and multiplied
Alphabet Inc. Reg. Shares A02079K305COM620$74,000thousands, detected and multiplied
WISDOMTREE TR97717W315EMER MKT HIGH FD1,891$72,000thousands, detected and multiplied
CHIPOTLEMEXICANGRILLI169656105STOK33$71,000thousands, detected and multiplied
JOHNSON CTLS INTL PLC SHSG51502105Stock1,035$71,000thousands, detected and multiplied
SPDR INDEX SHS FDS78463X855ST STR INFRA ETF1,312$70,000thousands, detected and multiplied
DORCHESTER MINERALS L P25820R105COM UNIT2,210$66,000thousands, detected and multiplied
Vanguard Materials ETF92204A801SHS356$65,000thousands, detected and multiplied
BP PLC SPONSORED ADR055622104ADR1,738$62,000thousands, detected and multiplied
DISCOVER FINL SVCS254709108COM528$62,000thousands, detected and multiplied
SPDR INDEX SHS FDS78463X541ST STR NAT ETF1,088$59,000thousands, detected and multiplied
CONSTELLATION ENERGY CORP COM21037T109Stock627$57,000thousands, detected and multiplied
iShares Global REIT ETF46434V647SHS2,426$56,000thousands, detected and multiplied
NextEra Energy,Inc.65339F101COM740$55,000thousands, detected and multiplied
Altria Group Inc02209S103COM1,190$54,000thousands, detected and multiplied
ISHARES TR464287168COM447$51,000thousands, detected and multiplied
ISHARES TR464287234MSCI EMG MKT ETF1,300$51,000thousands, detected and multiplied
ALLIANCE NATIONAL MUNICIPAL IN01864U106COM4,700$50,000thousands, detected and multiplied
TARGET CORP COM87612E106Stock365$49,000thousands, detected and multiplied
FIRST TR EXCHANGE-TRADED FD33733E203NY ARCA BIOTECH320$49,000thousands, detected and multiplied
ISHARES TR464288778US REGNL BKS ETF1,440$49,000thousands, detected and multiplied
VANGUARD INTL EQUITY INDEX F922042676COM1,171$47,000thousands, detected and multiplied
Walt Disney Co254687106COM527$47,000thousands, detected and multiplied
TRUIST FINL CORP COM89832Q109Stock1,540$47,000thousands, detected and multiplied
3M CO COM88579Y101Stock450$45,000thousands, detected and multiplied
Oracle Corporation68389X105COM370$44,000thousands, detected and multiplied
Tesla Motors, Inc88160R101COM169$44,000thousands, detected and multiplied
ENTERGY CORP NEW COM29364G103Stock450$44,000thousands, detected and multiplied
ISHARES TR46435G326CORE MSCI INTL719$44,000thousands, detected and multiplied
iShares U.S. Medical Devices ETF464288810SHS750$42,000thousands, detected and multiplied
FREYR BATTERYL4135L100SHS4,500$42,000thousands, detected and multiplied
Charles Schwab Corp808513105COM715$41,000thousands, detected and multiplied
Deere & Company244199105COM100$41,000thousands, detected and multiplied
INVESCO EXCHANGE TRADED FD T46137V787BIOTECHNOLOGY670$41,000thousands, detected and multiplied
Advanced Micro Devices,Inc.007903107COM350$40,000thousands, detected and multiplied
Vanguard Extended Market ETF922908652SHS270$40,000thousands, detected and multiplied
BROOKFIELD INFRASTRUCT FCLASS A11275Q107FOREIGN CANADIAN841$38,000thousands, detected and multiplied
Adobe Inc00724F101COM75$37,000thousands, detected and multiplied
ECOLAB INC COM278865100Stock200$37,000thousands, detected and multiplied
INVESCO MUNI OPPORTUNITY TRUST46132C107COM3,964$37,000thousands, detected and multiplied
WISDOMTREE TR97717Y691CMN1,175$37,000thousands, detected and multiplied
Texas Instruments Incorporated882508104COM200$36,000thousands, detected and multiplied
MICROCHIP TECHNOLOGY INC. COM595017104Stock400$36,000thousands, detected and multiplied
iShares S&P Small-Cap 600 Value ETF464287879SHS370$35,000thousands, detected and multiplied
PAYPALHLDGSINC70450Y103STOK508$34,000thousands, detected and multiplied
SPDR SER TR78464A359BBG CONV SEC ETF475$33,000thousands, detected and multiplied
GENERAL DYNAMICS CORP COM369550108Stock150$32,000thousands, detected and multiplied
BROADRIDGE FINL SOLUTIONS INC COM11133T103Stock195$32,000thousands, detected and multiplied
ADVANCE AUTO PARTS INC00751Y106COM450$32,000thousands, detected and multiplied
GLOBAL X FDS37954Y855LITHIUM BTRY ETF499$32,000thousands, detected and multiplied
PIMCO MUN INCOME FD II72200W106COM3,500$32,000thousands, detected and multiplied
ASPEN AEROGELS INC04523Y105COMMON STOCK4,000$32,000thousands, detected and multiplied
VANGUARD SCOTTSDALE FDS92206C409COM405$31,000thousands, detected and multiplied
SPDW78463X889COM909$30,000thousands, detected and multiplied
TRAVELERS COMPANIES INC COM89417E109Stock170$30,000thousands, detected and multiplied
BANK OF NY MELLON CORP COM064058100Stock664$29,000thousands, detected and multiplied
ISHARES TR464288414NATIONAL MUN ETF275$29,000thousands, detected and multiplied
American Tower Corporation03027X100COM147$28,000thousands, detected and multiplied
CRISPR THERAPEUTICS AG NAMEN AKTH17182108Stock500$28,000thousands, detected and multiplied
EXACT SCIENCES CORP COM30063P105Stock300$28,000thousands, detected and multiplied
PLAINS ALL AMERN PIPELINE L726503105UNIT LTD PARTN2,000$28,000thousands, detected and multiplied
DRIL-QUIP INC262037104COM1,200$28,000thousands, detected and multiplied
CRANE COMPANY COMMON STOCK224408104Stock301$27,000thousands, detected and multiplied
CULLEN FROST BANKERS INC COM229899109Stock250$27,000thousands, detected and multiplied
STANDARD LITHIUM CORP COM853606101Stock6,000$27,000thousands, detected and multiplied
DIAGEO PLC SPON ADR NEW25243Q205ADR150$26,000thousands, detected and multiplied
ESSENTIAL UTILS INC COM29670G102Stock650$26,000thousands, detected and multiplied
NUVEEN MINN QUALITY MUN INM670734102SHS2,300$26,000thousands, detected and multiplied
Vanguard Ultra-Short Bond ETF92203C303SHS500$25,000thousands, detected and multiplied
CROWN CASTLE INC COM22822V101REIT215$25,000thousands, detected and multiplied
CONSOLIDATED EDISON INC209115104COM267$24,000thousands, detected and multiplied
AFLAC INC COM001055102Stock340$24,000thousands, detected and multiplied
INVESCO EXCH TRADED FD TR II46138E537NATL AMT MUNI1,000$24,000thousands, detected and multiplied
HALLIBURTON CO COM406216101Stock700$23,000thousands, detected and multiplied
REPUBLIC SVCS INC COM760759100Stock150$23,000thousands, detected and multiplied
SCHWAB STRATEGIC TR808524409US LCAP VA ETF345$23,000thousands, detected and multiplied
WISDOMTREE TR97717W760INTL SMCAP DIV382$23,000thousands, detected and multiplied
VANGUARD SCOTTSDALE FDS92206C771SHS470$22,000thousands, detected and multiplied
MARATHON PETE CORP COM56585A102Stock190$22,000thousands, detected and multiplied
UNITED THERAPEUTICS CORP DEL COM91307C102Stock100$22,000thousands, detected and multiplied
ISHARES TR464287606S&P MC 400GR ETF296$22,000thousands, detected and multiplied
iShares S&P Mid-Cap 400 Value ETF464287705SHS192$21,000thousands, detected and multiplied
SPDR GOLD TR78463V107GOLD SHS120$21,000thousands, detected and multiplied
KIMBERLY-CLARK CORP COM494368103Stock150$21,000thousands, detected and multiplied
DELTA AIR LINES INC COM NEW247361702Stock435$21,000thousands, detected and multiplied
AMERICAN WTR WKS CO INC NEW COM030420103Stock150$21,000thousands, detected and multiplied
iShares Core MSCI Emerging Markets ETF46434G103SHS414$20,000thousands, detected and multiplied
TAIWAN SEMICONDUCTOR MFG874039100SPONSORED ADS200$20,000thousands, detected and multiplied
ALLSTATE CORP COM020002101Stock184$20,000thousands, detected and multiplied
ENTERPRISE PRODS PARTNERS L293792107COM772$20,000thousands, detected and multiplied
FIRST INTERSTATE BANCSYSTEM IN32055Y201COM CL A842$20,000thousands, detected and multiplied
WD 40 CO COM929236107Stock100$19,000thousands, detected and multiplied
STEPAN CO858586100COM200$19,000thousands, detected and multiplied
GLOBAL X FDS37954Y624AUTONMOUS EV ETF740$19,000thousands, detected and multiplied
WESTERN ASSET HIGH YIELD DEF95768B107COM1,500$18,000thousands, detected and multiplied
PHILLIPS 66 COM718546104Stock176$17,000thousands, detected and multiplied
KINDER MORGAN INC DEL COM49456B101Stock1,000$17,000thousands, detected and multiplied
QUIDELORTHO CORP COM219798105Stock200$17,000thousands, detected and multiplied
VANECK ETF TRUST92189F791JUNIOR GOLD MINE463$17,000thousands, detected and multiplied
CRANE NXT CO224441105COM301$17,000thousands, detected and multiplied
BLACKROCK CREDIT ALLOCATION IN092508100COM1,700$17,000thousands, detected and multiplied
HANCOCK JOHN PREM DIVID FD41013T105COM SH BEN INT1,402$17,000thousands, detected and multiplied
PIMCO CORPORATE & INCM STRG72200U100COM1,187$16,000thousands, detected and multiplied
COLGATE PALMOLIVE CO COM194162103Stock200$15,000thousands, detected and multiplied
NIO INC SPON ADS62914V106ADR1,500$15,000thousands, detected and multiplied
Applied Materials,Inc.038222105COM100$14,000thousands, detected and multiplied
VALERO ENERGY CORP COM91913Y100Stock121$14,000thousands, detected and multiplied
YUM BRANDS INC COM988498101Stock100$14,000thousands, detected and multiplied
ISHARES TR464287523COM25$13,000thousands, detected and multiplied
Morgan Stanley617446448COM156$13,000thousands, detected and multiplied
SOUTHWEST GAS HLDGS INC COM844895102Stock200$13,000thousands, detected and multiplied
PIPER SANDLER COMPANIES724078100COM104$13,000thousands, detected and multiplied
INTEGRA LIFESCIENCES HLDGS C457985208COM NEW300$12,000thousands, detected and multiplied
ISHARES TR46436E866IBONDS 25 TRM TS500$12,000thousands, detected and multiplied
ISHARES TR46436E874IBONDS 24 TRM TS500$12,000thousands, detected and multiplied
ISHARES TR46436E841IBONDS 27 TRM TS500$11,000thousands, detected and multiplied
ISHARES TR46436E858IBONDS 26 TRM TS500$11,000thousands, detected and multiplied
ISHARES TR46436E825IBONDS 29 TRM TS500$11,000thousands, detected and multiplied
ISHARES TR46436E833IBONDS 28 TRM TS500$11,000thousands, detected and multiplied
iShares Core US Aggregate Bond ETF464287226SHS106$10,000thousands, detected and multiplied
Philip Morris International Inc.718172109COM100$10,000thousands, detected and multiplied
CONAGRA FOODS INC205887102COM296$10,000thousands, detected and multiplied
FIDELITY NATL INFORMATION SVCS COM31620M106Stock190$10,000thousands, detected and multiplied
CARRIER GLOBAL CORPORATION COM14448C104Stock200$10,000thousands, detected and multiplied
DOMINION ENERGY INC COM25746U109Stock200$10,000thousands, detected and multiplied
AMEREN CORP COM023608102Stock126$10,000thousands, detected and multiplied
ISHARES TR46436E593IBOND DEC 2030500$10,000thousands, detected and multiplied
KEYCORP COM493267108Stock1,000$9,000thousands, detected and multiplied
OTIS WORLDWIDE CORP COM68902V107Stock100$9,000thousands, detected and multiplied
NUVEEN REAL ASSET INCOME AND G67074Y105COM825$9,000thousands, detected and multiplied
NUVEEN AMT-FREE MUN VALUE FD670695105COM650$9,000thousands, detected and multiplied
RIVIAN AUTOMOTIVE INC COM CL A76954A103Stock500$8,000thousands, detected and multiplied
HEALTHPEAK PROPERTIES INC COM42250P103REIT400$8,000thousands, detected and multiplied
REAVES UTIL INCOME FD756158101COM SH BEN INT300$8,000thousands, detected and multiplied
BLACKROCK MUNIVEST FUND II09253T101COM750$8,000thousands, detected and multiplied
BAXTER INTL INC071813109COM150$7,000thousands, detected and multiplied
Utilities Select Sector SPDR Fund81369Y886SHS90$6,000thousands, detected and multiplied
YUM CHINA HLDGS INC98850P109COM100$6,000thousands, detected and multiplied
3D SYSTEMS CORP88554D205COMMON STOCK600$6,000thousands, detected and multiplied
PACER FDS TR69374H105TRENDP US LAR CP144$6,000thousands, detected and multiplied
ETFMG26924G508EXCHANGE TRADED2,000$6,000thousands, detected and multiplied
Goldman Sachs Group,Inc.38141G104COM15$5,000thousands, detected and multiplied
TELADOC HEALTH INC87918A105COM200$5,000thousands, detected and multiplied
COHEN & STEERS INFRASTRUCTUR19248A109COM200$5,000thousands, detected and multiplied
iShares Russell 2000 ETF464287655SHS19$4,000thousands, detected and multiplied
Vanguard Total International Bond Index Fund ETF92203J407SHS75$4,000thousands, detected and multiplied
ISHARES TR464288281JPMORGAN USD EMG44$4,000thousands, detected and multiplied
CARNIVAL CORP COMMON STOCK143658300Stock200$4,000thousands, detected and multiplied
TORTOISE ENERGY INFRA CORP89147L886COM151$4,000thousands, detected and multiplied
SPDR Portfolio Long Term Treasury ETF78464A664SHS104$3,000thousands, detected and multiplied
GERON CORP374163103COM1,000$3,000thousands, detected and multiplied
PILGRIMS PRIDE CORP COM72147K108Stock138$3,000thousands, detected and multiplied
AMERICAN EAGLE OUTFITTERS INC COM02553E106Stock200$2,000thousands, detected and multiplied
DELL TECHNOLOGIES INC CL C24703L202Stock39$2,000thousands, detected and multiplied
VMWARE, INC.928563402CL A COM17$2,000thousands, detected and multiplied
CHARTER COMMUNICATIONS INC N16119P108COM4$1,000thousands, detected and multiplied
VIATRIS INC COM92556V106Stock78$1,000thousands, detected and multiplied
DOLLAR GEN CORP COM256677105Stock5$1,000thousands, detected and multiplied
SANOFI SA SPONSORED ADR80105N105ADR20$1,000thousands, detected and multiplied
LUCID GROUP INC549498103COM85$1,000thousands, detected and multiplied
SPDR SER TR78468R622BLOOMBERG HIGH Y14$1,000thousands, detected and multiplied
ISHARES TR464287630RUS 2000 VAL ETF9$1,000thousands, detected and multiplied
NOKIA CORP654902204SPONSORED ADR21$0thousands, detected and multipliedValue filed as zero, left out of ratios.
WARNER BROS DISCOVERY INC COM SER A934423104Stock18$0thousands, detected and multipliedValue filed as zero, left out of ratios.
KELLANOVA487836108COM5$0thousands, detected and multipliedValue filed as zero, left out of ratios.
PATHWARD FINANCIAL INC59100U108COM10$0thousands, detected and multipliedValue filed as zero, left out of ratios.
KYNDRYL HLDGS INC50155Q100COMMON STOCK2$0thousands, detected and multipliedValue filed as zero, left out of ratios.
MOMENTUS INC60879E101COM500$0thousands, detected and multipliedValue filed as zero, left out of ratios.
MIDWEST HLDG INC59833J206COM NEW5$0thousands, detected and multipliedValue filed as zero, left out of ratios.

Amendment chain

FilingRoleFiledAcceptedIngested
13F-HR 0001653926-23-000003this filing2023-07-13acceptance time not in the bulk data set