13F-HR filed by Transamerica Financial Advisors, LLC
Transamerica Financial Advisors, LLC filed this 13F-HR for the quarter ended 2017-03-31, filed 2017-05-10, with 392 holding rows worth $835,009,000.
- Accession
- 0001140361-17-019216
- Filer
- CIK 1502149
- Filed
- 2017-05-10
- Accepted by EDGAR
- acceptance time not in the bulk data set
- Ingested
- Source
- SEC quarterly data set
13F report for Q1 2017
A combination report, 392 entries on the cover page, a total value of $835,009,000 stated on the cover page (in dollars after the unit check, H1), rows summing to $835,009,000 with VALUE read as thousands by filing date, 13F file number 028-14018. The quarter's positions are built on this report. The resolved quarter.
Other managers
- reports for this filerBetterment LLC028-16706
- included managerTRANSAMERICA CORP028-00136
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 filed | CUSIP | Class | Amount | Value | Value read as | Type |
|---|---|---|---|---|---|---|
| VANGUARD INDEX FDS | 922908637 | LARGE CAP ETF | 594,622 | $64,273,000 | thousands by filing date | |
| Vanguard Total Bond Market ETF | 921937835 | SHS | 508,655 | $41,242,000 | thousands by filing date | |
| SPDR SERIES TRUST BLOOMBERG BR | 78464A417 | BLOOMBERG BRCLYS | 601,999 | $22,232,000 | thousands by filing date | |
| iShares Russell Midcap ETF | 464287499 | SHS | 106,971 | $20,023,000 | thousands by filing date | |
| Vanguard FTSE Developed Markets ETF | 921943858 | SHS | 436,688 | $17,162,000 | thousands by filing date | |
| Vanguard Total International Bond Index Fund ETF | 92203J407 | SHS | 311,964 | $16,887,000 | thousands by filing date | |
| iShares TIPS Bond ETF | 464287176 | SHS | 118,825 | $13,624,000 | thousands by filing date | |
| iShares Core S&P Small-Cap ETF | 464287804 | SHS | 189,639 | $13,116,000 | thousands by filing date | |
| ISHARES TR | 464288513 | IBOXX HI YD ETF | 140,842 | $12,364,000 | thousands by filing date | |
| PIMCO ETF TR | 72201R833 | ENHAN SHRT MA AC | 119,959 | $12,194,000 | thousands by filing date | |
| VWO | 922042858 | SHS | 290,833 | $11,552,000 | thousands by filing date | |
| Walmart Inc. | 931142103 | COM | 147,469 | $10,630,000 | thousands by filing date | |
| POWERSHARES ETF TRUST | 73935X344 | TECH SECT PORT | 228,668 | $10,211,000 | thousands by filing date | |
| Vanguard Real Estate | 922908553 | SHS | 122,987 | $10,158,000 | thousands by filing date | |
| POWERSHARES ETF TRUST INDL SEC | 73935X369 | COM | 187,359 | $9,619,000 | thousands by filing date | |
| Apple Inc | 037833100 | COM | 66,745 | $9,589,000 | thousands by filing date | |
| POWERSHARES ETF TRUST | 73935X377 | FINL SECT PORT | 309,103 | $9,561,000 | thousands by filing date | |
| POWERSHARES ETF TR II S&P500 L | 73937B779 | COM | 219,784 | $9,554,000 | thousands by filing date | |
| VANGUARD WHITEHALL FDS | 921946885 | COM | 118,420 | $9,433,000 | thousands by filing date | |
| C H ROBINSON WORLDWIDE IN COM NEW | 12541W209 | Stock | 117,293 | $9,066,000 | thousands by filing date | |
| Johnson & Johnson | 478160104 | COM | 69,005 | $8,595,000 | thousands by filing date | |
| AT&T Inc | 00206R102 | COM | 203,796 | $8,468,000 | thousands by filing date | |
| International Business Machines Corporation | 459200101 | COM | 48,436 | $8,435,000 | thousands by filing date | |
| SYSCOCORP | 871829107 | COM | 151,961 | $7,890,000 | thousands by filing date | |
| POWERSHARES ETF TRUST | 73935X385 | ENERGY SEC POR | 201,920 | $7,883,000 | thousands by filing date | |
| Verizon Communications Inc | 92343V104 | COM | 161,229 | $7,860,000 | thousands by filing date | |
| VANGUARD SCOTTSDALE FDS | 92206C409 | COM | 96,188 | $7,670,000 | thousands by filing date | |
| EXXON MOBIL CORP | 30231G102 | COM | 88,996 | $7,299,000 | thousands by filing date | |
| CINCINNATI FINL CORP COM | 172062101 | Stock | 100,610 | $7,272,000 | thousands by filing date | |
| GENERAL MILLS INC COM | 370334104 | Stock | 120,971 | $7,139,000 | thousands by filing date | |
| VANGUARD SCOTTSDALE FDS | 92206C771 | SHS | 134,102 | $7,044,000 | thousands by filing date | |
| Microsoft Corp | 594918104 | COM | 105,688 | $6,961,000 | thousands by filing date | |
| American Express Company | 025816109 | COM | 84,994 | $6,724,000 | thousands by filing date | |
| OMNICOM GROUP INC COM | 681919106 | Stock | 77,524 | $6,684,000 | thousands by filing date | |
| SPDR INDEX SHS FDS | 78463X871 | ST INTL CAP ETF | 210,420 | $6,633,000 | thousands by filing date | |
| SPDR SER TR | 78464A359 | BBG CONV SEC ETF | 136,272 | $6,555,000 | thousands by filing date | |
| EDISON INTL COM | 281020107 | Stock | 81,390 | $6,480,000 | thousands by filing date | |
| FISERV INC | 337738108 | COM | 55,994 | $6,457,000 | thousands by filing date | |
| Progressive Corporation | 743315103 | COM | 163,349 | $6,401,000 | thousands by filing date | |
| Procter & Gamble Co | 742718109 | COM | 70,098 | $6,299,000 | thousands by filing date | |
| Pfizer Inc. | 717081103 | COM | 174,414 | $5,967,000 | thousands by filing date | |
| ISHARES TR CORE S&P 500 ETF | 464287200 | SHS | 24,071 | $5,712,000 | thousands by filing date | |
| PATTERSON COS INC | 703395103 | COM | 125,296 | $5,668,000 | thousands by filing date | |
| Vanguard Short-Term Treasury ETF | 92206C102 | SHS | 92,334 | $5,613,000 | thousands by filing date | |
| PAYCHEX INC | 704326107 | COM | 93,773 | $5,524,000 | thousands by filing date | |
| Home Depot, Inc | 437076102 | COM | 37,327 | $5,481,000 | thousands by filing date | |
| REPUBLIC SVCS INC COM | 760759100 | Stock | 86,413 | $5,428,000 | thousands by filing date | |
| FIRST TR EXCHANGE-TRADED FD | 337345102 | SHS | 90,200 | $5,426,000 | thousands by filing date | |
| HORMEL FOODS CORP COM | 440452100 | Stock | 156,239 | $5,411,000 | thousands by filing date | |
| Lockheed Martin Corporation | 539830109 | COM | 20,158 | $5,395,000 | thousands by filing date | |
| GENUINE PARTS CO COM | 372460105 | Stock | 57,432 | $5,308,000 | thousands by filing date | |
| SPDR INDEX SHS FDS | 78463X756 | S&P EMKTSC ETF | 112,567 | $5,109,000 | thousands by filing date | |
| FIRST TR EXCHANGE-TRADED FD | 33733E302 | DJ INTERNT IDX | 57,819 | $5,091,000 | thousands by filing date | |
| VANGUARD MALVERN FDS | 922020805 | SHS | 102,039 | $5,048,000 | thousands by filing date | |
| Elevance Health, Inc. | 036752103 | COM | 30,092 | $4,977,000 | thousands by filing date | |
| Accenture Plc Class A | G1151C101 | COM | 40,642 | $4,873,000 | thousands by filing date | |
| FIRST TR EXCHANGE-TRADED FD | 33734X184 | UTILITIES ALPH | 177,517 | $4,863,000 | thousands by filing date | |
| TJX Companies Inc | 872540109 | COM | 61,427 | $4,858,000 | thousands by filing date | |
| UnitedHealth Group Inc | 91324P102 | COM | 28,532 | $4,680,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78468R408 | ST TERM HIGH ETF | 167,206 | $4,676,000 | thousands by filing date | |
| FIRST TR EXCHANGE TRADED FD | 33734X150 | INDLS PROD DUR | 132,828 | $4,559,000 | thousands by filing date | |
| FIRST TR EXCHANGE TRADED FD | 33738R860 | NASDAQ BK ETF | 169,135 | $4,393,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78468R739 | ST NUVE TERM ETF | 89,519 | $4,337,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78464A375 | ST INTER BD ETF | 126,911 | $4,332,000 | thousands by filing date | |
| Waste Management, Inc. | 94106L109 | COM | 57,170 | $4,169,000 | thousands by filing date | |
| Gilead Sciences,Inc. | 375558103 | COM | 60,004 | $4,076,000 | thousands by filing date | |
| USBANCORPDEL | 902973304 | COM NEW | 73,952 | $3,809,000 | thousands by filing date | |
| Walt Disney Co | 254687106 | COM | 32,024 | $3,632,000 | thousands by filing date | |
| iShares Core US Aggregate Bond ETF | 464287226 | SHS | 33,338 | $3,617,000 | thousands by filing date | |
| DOLLAR GEN CORP COM | 256677105 | Stock | 50,976 | $3,555,000 | thousands by filing date | |
| CLOROX CO DEL | 189054109 | COM | 26,194 | $3,532,000 | thousands by filing date | |
| ISHARES TR | 464288661 | 3 7 YR TREAS BD | 28,641 | $3,525,000 | thousands by filing date | |
| KELLANOVA | 487836108 | COM | 47,649 | $3,460,000 | thousands by filing date | |
| DOMINION ENERGY INC COM | 25746U109 | Stock | 44,201 | $3,429,000 | thousands by filing date | |
| SPDR S&P Midcap 400 ETF Trust | 78467Y107 | SHS | 10,932 | $3,416,000 | thousands by filing date | |
| iShares Global Tech ETF | 464287291 | SHS | 27,463 | $3,413,000 | thousands by filing date | |
| WEC ENERGY GROUP INC COM | 92939U106 | Stock | 55,960 | $3,393,000 | thousands by filing date | |
| AETNA INC NEW | 00817Y108 | COM | 26,027 | $3,320,000 | thousands by filing date | |
| VANECK EMERGING MARKETS HIGH Y | 92189F353 | EMERGING MRKT HI | 130,894 | $3,228,000 | thousands by filing date | |
| PPL CORP COM | 69351T106 | Stock | 83,049 | $3,106,000 | thousands by filing date | |
| TOTAL SYS SVCS INC | 891906109 | COM | 57,792 | $3,090,000 | thousands by filing date | |
| VANGUARD INTL EQUITY INDEX F | 922042676 | COM | 57,794 | $3,079,000 | thousands by filing date | |
| CA INC COM | 12673P105 | COM | 95,814 | $3,040,000 | thousands by filing date | |
| Duke Energy Corporation | 26441C204 | COM | 36,472 | $2,992,000 | thousands by filing date | |
| BAXTER INTL INC | 071813109 | COM | 54,780 | $2,841,000 | thousands by filing date | |
| POWERSHARES GLOBAL ETF TRUST | 73936T474 | INSUR NATL MUN | 113,317 | $2,837,000 | thousands by filing date | |
| FIRST TR MID CAP CORE ALPHAD | 33735B108 | COM SHS | 48,450 | $2,832,000 | thousands by filing date | |
| McDonalds Corporation | 580135101 | COM | 21,794 | $2,825,000 | thousands by filing date | |
| FIRST TR EXCHANGE-TRADED ALP | 33737M300 | SML CP GRW ALP | 74,027 | $2,698,000 | thousands by filing date | |
| FIRST TR EXCHANGE-TRADED ALP | 33735K108 | COM SHS | 51,118 | $2,691,000 | thousands by filing date | |
| OCCIDENTAL PETE CORP | 674599105 | COM | 41,786 | $2,648,000 | thousands by filing date | |
| ISHARES TR | 464287630 | RUS 2000 VAL ETF | 22,149 | $2,618,000 | thousands by filing date | |
| Financial Select Sector SPDR Fund | 81369Y605 | SHS | 110,198 | $2,615,000 | thousands by filing date | |
| ISHARES TR | 464287523 | COM | 19,099 | $2,615,000 | thousands by filing date | |
| Vanguard Intermediate-Term Treasury ETF | 92206C706 | SHS | 39,826 | $2,562,000 | thousands by filing date | |
| SIMON PPTY GROUP INC NEW COM | 828806109 | REIT | 14,376 | $2,473,000 | thousands by filing date | |
| iShares U.S. Financials ETF | 464287788 | SHS | 23,233 | $2,418,000 | thousands by filing date | |
| VANECK VECTORS ETF TR | 92189F718 | OIL SVCS ETF | 77,150 | $2,377,000 | thousands by filing date | |
| FOOT LOCKER INC | 344849104 | COM | 31,663 | $2,369,000 | thousands by filing date | |
| Southern Company | 842587107 | COM | 47,399 | $2,360,000 | thousands by filing date | |
| POWERSHARES ETF TR II | 73937B746 | KBW BK PORT | 49,469 | $2,351,000 | thousands by filing date | |
| iShares U.S. Technology ETF | 464287721 | SHS | 16,930 | $2,289,000 | thousands by filing date | |
| Chubb Limited | H1467J104 | COM | 16,475 | $2,245,000 | thousands by filing date | |
| DTE ENERGY CO COM | 233331107 | Stock | 21,807 | $2,227,000 | thousands by filing date | |
| Salesforce.com, Inc | 79466L302 | COM | 26,493 | $2,186,000 | thousands by filing date | |
| XCELENERGY INC | 98389B100 | COM | 49,053 | $2,181,000 | thousands by filing date | |
| Guggenheim S&P 500 Equal Weighted ETf | 78355W106 | Equity | 23,829 | $2,165,000 | thousands by filing date | |
| SELECT SECTOR SPDR TR | 81369Y308 | STATE STREET CON | 39,552 | $2,159,000 | thousands by filing date | |
| PUBLIC STORAGE COM | 74460D109 | REIT | 9,761 | $2,137,000 | thousands by filing date | |
| ISHARES TR | 464287440 | 7-10 YR TRSY BD | 20,030 | $2,115,000 | thousands by filing date | |
| Cisco Systems,Inc. | 17275R102 | COM | 62,394 | $2,109,000 | thousands by filing date | |
| Vanguard Long-Term Corporate Bond ETF | 92206C813 | SHS | 23,405 | $2,105,000 | thousands by filing date | |
| LABORATORY CORP OF AMERICA | 50540R409 | COM NEW | 14,500 | $2,081,000 | thousands by filing date | |
| Vanguard Intermediate-Term Corporate Bond ETF | 92206C870 | SHS | 24,067 | $2,079,000 | thousands by filing date | |
| UBS Alerian MLP/ MLPI | 902641646 | TR UNIT | 70,665 | $2,062,000 | thousands by filing date | |
| SSGA ACTIVE ETF TR | 78467V848 | ST STR TOTAL ETF | 41,936 | $2,050,000 | thousands by filing date | |
| SPDR CITI INTL GOVT INFLATION- | 78464A490 | FTSE INT GVT ETF | 36,878 | $2,022,000 | thousands by filing date | |
| SELECT SECTOR SPDR TR | 81369Y704 | INDL | 30,959 | $2,015,000 | thousands by filing date | |
| EXPRESS SCRIPTS HLDG CO | 30219G108 | COM | 30,032 | $1,980,000 | thousands by filing date | |
| SWEDISH EXPT CR CORP | 870297801 | ROG TTL ETN 22 | 389,748 | $1,980,000 | thousands by filing date | |
| ISHARES RUSSELL 1000 VALUE ETF | 464287598 | ETF | 17,147 | $1,971,000 | thousands by filing date | |
| VANECK ETF TRUST | 92189F437 | COM | 65,747 | $1,944,000 | thousands by filing date | |
| PIONEER NATURAL RESOURCES CO | 723787107 | COM | 10,412 | $1,939,000 | thousands by filing date | |
| SPDR SER TR | 78464A292 | WELLS FG PFD ETF | 43,663 | $1,920,000 | thousands by filing date | |
| SELECT SECTOR SPDR TR | 81369Y407 | SBI CONS DISCR | 21,241 | $1,869,000 | thousands by filing date | |
| COLGATE PALMOLIVE CO COM | 194162103 | Stock | 25,183 | $1,844,000 | thousands by filing date | |
| POWERSHARES ETF TR II | 73937B654 | PWRSH S&P500HI | 44,500 | $1,803,000 | thousands by filing date | |
| Chevron Corporation | 166764100 | COM | 16,705 | $1,794,000 | thousands by filing date | |
| Schwab US TIPS ETF | 808524870 | SHS | 30,610 | $1,700,000 | thousands by filing date | |
| SPDR GOLD TR | 78463V107 | GOLD SHS | 14,122 | $1,677,000 | thousands by filing date | |
| PIMCO ETF TR | 72201R783 | 0-5 HIGH YIELD | 16,516 | $1,670,000 | thousands by filing date | |
| CLAYMORE EXCHANGE TRD FD TR | 18383M654 | GUGG ENH SHT DUR | 31,650 | $1,591,000 | thousands by filing date | |
| Berkshire Hathaway Inc | 084670702 | COM | 9,497 | $1,583,000 | thousands by filing date | |
| VERISIGN INC COM | 92343E102 | Stock | 17,071 | $1,488,000 | thousands by filing date | |
| BED BATH & BEYOND INC | 075896100 | COM | 37,527 | $1,481,000 | thousands by filing date | |
| HERSHEY CO COM | 427866108 | Stock | 13,056 | $1,427,000 | thousands by filing date | |
| CINTAS CORP COM | 172908105 | Stock | 11,223 | $1,421,000 | thousands by filing date | |
| DENTSPLY SIRONA INC | 24906P109 | COM | 21,652 | $1,352,000 | thousands by filing date | |
| ISHARES RUSSELL MID-CAP VALUE ETF | 464287473 | ETF | 15,890 | $1,319,000 | thousands by filing date | |
| SCHEIN HENRY INC | 806407102 | COM | 7,534 | $1,281,000 | thousands by filing date | |
| V F CORP COM | 918204108 | Stock | 23,076 | $1,269,000 | thousands by filing date | |
| MCCORMICK & CO INC COM NON VTG | 579780206 | Stock | 12,876 | $1,257,000 | thousands by filing date | |
| Energy Select Sector SPDR Fund | 81369Y506 | SHS | 17,661 | $1,235,000 | thousands by filing date | |
| TESORO CORP | 881609101 | COM | 13,768 | $1,116,000 | thousands by filing date | |
| WISDOMTREE TR | 97717W505 | US MIDCAP DIVID | 11,067 | $1,080,000 | thousands by filing date | |
| MCKESSON CORP COM | 58155Q103 | Stock | 7,169 | $1,063,000 | thousands by filing date | |
| ISHARES TR | 464287432 | 20 YR TR BD ETF | 8,568 | $1,035,000 | thousands by filing date | |
| SSGA ACTIVE ETF TR | 78467V608 | BLACKSTONE SENR | 21,529 | $1,024,000 | thousands by filing date | |
| Technology Select Sector SPDR Fund | 81369Y803 | SHS | 18,729 | $999,000 | thousands by filing date | |
| ISHARESRUSSELL1000GROWTHETF | 464287614 | STOK | 8,578 | $977,000 | thousands by filing date | |
| SELECT SECTOR SPDR TR | 81369Y100 | SBI MATERIALS | 18,584 | $974,000 | thousands by filing date | |
| Utilities Select Sector SPDR Fund | 81369Y886 | SHS | 18,914 | $971,000 | thousands by filing date | |
| SPDR Bloomberg Investment Grade Floating Rate ETF | 78468R200 | SHS | 31,101 | $956,000 | thousands by filing date | |
| Health Care Select Sector SPDR Fund | 81369Y209 | SHS | 12,831 | $955,000 | thousands by filing date | |
| Merck & Co.,Inc. | 58933Y105 | COM | 14,507 | $922,000 | thousands by filing date | |
| PRINCIPAL FINANCIAL GROUP INC COM | 74251V102 | Stock | 13,937 | $880,000 | thousands by filing date | |
| POWERSHARES ETF TR II | 73937B662 | EM MRK LOW VOL | 37,345 | $859,000 | thousands by filing date | |
| VANGUARD HEALTH CARE ETF | 92204A504 | ETF | 6,160 | $849,000 | thousands by filing date | |
| Invesco Intl Developed Low Vol | 73937B688 | INTL DEV LOWVL | 27,469 | $846,000 | thousands by filing date | |
| Medtronic Plc | G5960L103 | COM | 9,183 | $740,000 | thousands by filing date | |
| ISHARES INC MSCI EURZONE ETF | 464286608 | MSCI EURZONE ETF | 19,399 | $730,000 | thousands by filing date | |
| ISHARES MSCI EAFE MIN VOL FACTOR ETF | 46429B689 | ETF | 10,963 | $724,000 | thousands by filing date | |
| iShares Silver Trust | 46428Q109 | COM | 41,840 | $722,000 | thousands by filing date | |
| SCRIPPS NETWORKS INTERACT IN | 811065101 | CL A COM | 9,204 | $722,000 | thousands by filing date | |
| VARIAN MED SYS INC | 92220P105 | COM | 7,909 | $721,000 | thousands by filing date | |
| VANGUARD SCOTTSDALE FDS | 92206C847 | COM | 9,422 | $703,000 | thousands by filing date | |
| ISHARES TR | 464287648 | RUS 2000 GRW ETF | 4,146 | $671,000 | thousands by filing date | |
| Intel Corp | 458140100 | COM | 18,335 | $662,000 | thousands by filing date | |
| CMS ENERGY CORP COM | 125896100 | Stock | 14,736 | $660,000 | thousands by filing date | |
| Prologis,Inc. | 74340W103 | COM | 12,611 | $655,000 | thousands by filing date | |
| APARTMENT INVT & MGMT CO | 03748R101 | CL A | 14,744 | $654,000 | thousands by filing date | |
| iShares MBS ETF | 464288588 | SHS | 5,950 | $634,000 | thousands by filing date | |
| CERNER CORP | 156782104 | COM | 10,694 | $630,000 | thousands by filing date | |
| PG&E CORP COM | 69331C108 | Stock | 9,448 | $627,000 | thousands by filing date | |
| FIDELITY NATL INFORMATION SVCS COM | 31620M106 | Stock | 7,838 | $624,000 | thousands by filing date | |
| WESTERN UN CO COM | 959802109 | Stock | 30,481 | $621,000 | thousands by filing date | |
| CURRENCYSHARES SWISS FRANC TRU | 23129V109 | ETF | 6,500 | $618,000 | thousands by filing date | |
| ConocoPhillips | 20825C104 | COM | 12,305 | $614,000 | thousands by filing date | |
| Thermo Fisher Scientific Inc. | 883556102 | COM | 3,943 | $606,000 | thousands by filing date | |
| iShares MSCI Japan ETF | 46434G822 | SHS | 11,713 | $604,000 | thousands by filing date | |
| WISDOMTREE TR | 97717W471 | BLMBG US BULL | 22,152 | $601,000 | thousands by filing date | |
| iShares Gold Trust | 464285105 | ISHARES | 49,107 | $590,000 | thousands by filing date | |
| PIMCO 15 YEAR US TIPS INDEX F | 72201R304 | 15+ YR US TIPS | 8,809 | $586,000 | thousands by filing date | |
| EQUITY RESIDENTIAL | 29476L107 | SH BEN INT | 9,322 | $580,000 | thousands by filing date | |
| WELLTOWER INC COM | 95040Q104 | REIT | 7,964 | $564,000 | thousands by filing date | |
| ISHARES INC MSCI BRAZIL ETF | 464286400 | MSCI BRAZIL ETF | 14,628 | $548,000 | thousands by filing date | |
| ISHARES TR | 464287846 | DOW JONES US ETF | 4,509 | $534,000 | thousands by filing date | |
| HCP INC | 40414L109 | COM | 17,030 | $533,000 | thousands by filing date | |
| ISHARES TR | 464289842 | MSCI PERU GL ETF | 14,543 | $496,000 | thousands by filing date | |
| ISHARES TR | 464288414 | NATIONAL MUN ETF | 4,451 | $485,000 | thousands by filing date | |
| iShares MSCI Russia ETF Special | 46434G798 | Exchange Traded Fund | 15,051 | $484,000 | thousands by filing date | |
| CONAGRA FOODS INC | 205887102 | COM | 11,777 | $476,000 | thousands by filing date | |
| ISHARES TR | 464289123 | NEW ZEALAND ETF | 11,042 | $467,000 | thousands by filing date | |
| ISHARES INC | 464286665 | MSCI PAC JP ETF | 8,660 | $388,000 | thousands by filing date | |
| WISDOMTREE EUROPE HEDGED EQUITY FUND | 97717X701 | ETF | 6,012 | $378,000 | thousands by filing date | |
| ISHARES TR MSCI UK ETF NEW | 46435G334 | MSCI UK ETF NEW | 11,356 | $370,000 | thousands by filing date | |
| FIDELITY COVINGTON TRUST | 316092873 | MSCI COMMNTN SVC | 11,658 | $358,000 | thousands by filing date | |
| ISHARES TR | 464288752 | US HOME CONS ETF | 10,873 | $348,000 | thousands by filing date | |
| BARCLAYS BANK PLC | 06738C778 | DJUBS CMDT ETN36 | 14,550 | $343,000 | thousands by filing date | |
| GLOBAL X FDS | 37950E226 | GLB X MLP ENRG I | 23,095 | $341,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78464A698 | ST STR SP REGBNK | 6,161 | $337,000 | thousands by filing date | |
| DBX ETF TR | 233051507 | XTRACK MSCI JAPN | 8,441 | $317,000 | thousands by filing date | |
| ISHARES TR | 464288836 | U.S. PHARMA ETF | 2,036 | $308,000 | thousands by filing date | |
| FIRST TRUST HIGH YIELD LONG/SH | 33738D408 | FIRST TR TA HIYL | 6,212 | $304,000 | thousands by filing date | |
| ISHARES TR | 464288638 | ISHS 5-10YR INVT | 2,669 | $291,000 | thousands by filing date | |
| ISHARES 10 Y INVE GRADE COR B | 464289511 | 10+ YR INVST GRD | 4,689 | $278,000 | thousands by filing date | |
| CLAYMORE EXCHANGE TRD FD TR | 18383M373 | GUG BUL 2019 HY | 9,929 | $244,000 | thousands by filing date | |
| CLAYMORE EXCHANGE TRD FD TR | 18383M365 | GUG BUL 2020 HY | 9,882 | $244,000 | thousands by filing date | |
| CLAYMORE EXCHANGE TRD FD TR | 18383M381 | GUG BLT2018 HY | 9,505 | $241,000 | thousands by filing date | |
| Real Estate Select Sector SPDR Fund | 81369Y860 | SHS | 7,495 | $237,000 | thousands by filing date | |
| iShares Global Healthcare ETF | 464287325 | SHS | 2,046 | $211,000 | thousands by filing date | |
| ISHARES CMBS ETF | 46429B366 | CMBS ETF | 4,096 | $210,000 | thousands by filing date | |
| POWERSHARES | 73936Q769 | EXCHANGE TRADED | 8,927 | $208,000 | thousands by filing date | |
| NEW YORK LIFE INVESTMENTS ET | 45409B800 | NYLI MERGER ARBI | 6,462 | $194,000 | thousands by filing date | |
| iShares Global 100 ETF | 464287572 | SHS | 2,234 | $183,000 | thousands by filing date | |
| LAMB WESTON HLDGS INC | 513272104 | COM | 3,845 | $162,000 | thousands by filing date | |
| SPDR INDEX SHS FDS | 78463X863 | ST DOW INTL ETF | 3,354 | $126,000 | thousands by filing date | |
| FIRST TRUST LOW DURATION OPPORTUNITIES ETF | 33739Q200 | ETF | 2,296 | $120,000 | thousands by filing date | |
| DBX ETF TR | 233051200 | XTRACK MSCI EAFE | 4,026 | $120,000 | thousands by filing date | |
| ISHARES 1-5 YEAR INVESTMENT GRADE CORPORATE BOND ETF | 464288646 | ETF | 1,066 | $113,000 | thousands by filing date | |
| Vanguard FTSE Pacific ETF | 922042866 | SHS | 1,692 | $108,000 | thousands by filing date | |
| VAREX IMAGING CORP | 92214X106 | COMMON STOCK | 3,191 | $108,000 | thousands by filing date | |
| INVESCO FINANCIAL PREFERRED ETF | 73935X229 | COM | 5,454 | $102,000 | thousands by filing date | |
| iShares Floating Rate Bond ETF | 46429B655 | SHS | 1,983 | $101,000 | thousands by filing date | |
| ISHARES TR | 464288687 | COM | 2,375 | $92,000 | thousands by filing date | |
| POWERSHARES | 73936T573 | EXCHANGE TRADED | 2,847 | $83,000 | thousands by filing date | |
| ISHARES MSCI EAFE SMALL-CAP ETF | 464288273 | ETF | 1,423 | $78,000 | thousands by filing date | |
| SPDR INDEX SHS FDS | 78463X301 | ST STR ASIA ETF | 901 | $78,000 | thousands by filing date | |
| QUALITY CARE PPTYS INC | 747545101 | COM | 3,397 | $65,000 | thousands by filing date | |
| ISHARES TR | 464288729 | GLOB INDSTRL ETF | 738 | $60,000 | thousands by filing date | |
| MANAGED PORTFOLIO SERIES | 56167N720 | TORTOISE NRAM PI | 1,606 | $39,000 | thousands by filing date | |
| PROSHARES TR | 74347X849 | INDX FD | 1,546 | $37,000 | thousands by filing date | |
| ISHARES TR | 46429B663 | CORE HIGH DV ETF | 403 | $34,000 | thousands by filing date | |
| ALPS ETF TR | 00162Q866 | ALERIAN MLP | 2,645 | $34,000 | thousands by filing date | |
| SPDR SER TR | 78468R721 | NUVEEN BLMBRG MU | 682 | $33,000 | thousands by filing date | |
| SPY | 78462F103 | SHS | 120 | $29,000 | thousands by filing date | |
| FIRST TR EXCHANGE-TRADED FD | 33734X101 | CONSUMR DISCRE | 754 | $28,000 | thousands by filing date | |
| FIRST TR EXCHANGE-TRADED FD | 33734X119 | CONSUMR STAPLE | 572 | $27,000 | thousands by filing date | |
| CAMBRIA ETF TR | 132061607 | GLB ASSET ALLO | 1,003 | $26,000 | thousands by filing date | |
| ISHARES TR | 464287457 | COM | 282 | $24,000 | thousands by filing date | |
| ISHARES TR | 464288448 | INTL SEL DIV ETF | 668 | $21,000 | thousands by filing date | |
| ISHARES INC | 464286285 | JP MRGN EM HI BD | 378 | $19,000 | thousands by filing date | |
| FIRST TR EXCHANGE-TRADED FD | 33734X127 | ENERGY ALPHADX | 1,144 | $18,000 | thousands by filing date | |
| SPDR Bloomberg Emerging Markets Local Bond ETF | 78464A391 | SHS | 577 | $17,000 | thousands by filing date | |
| FIRST TR EXCHANGE-TRADED ALP | 33737M102 | MID CP GR ALPH | 490 | $17,000 | thousands by filing date | |
| TARGET CORP COM | 87612E106 | Stock | 287 | $16,000 | thousands by filing date | |
| WISDOMTREE TR | 97717W315 | EMER MKT HIGH FD | 352 | $15,000 | thousands by filing date | |
| POWERSHARES ETF TRUST | 73935X393 | CON STAPLE SEC | 238 | $14,000 | thousands by filing date | |
| ISHARES TR | 464287465 | MSCI EAFE ETF | 202 | $13,000 | thousands by filing date | |
| WISDOMTREE TR | 97717X867 | CMN | 341 | $13,000 | thousands by filing date | |
| SPDR Portfolio Long Term Treasury ETF | 78464A664 | SHS | 172 | $12,000 | thousands by filing date | |
| KAYNE ANDERSON ENERGY | 486606106 | COM | 554 | $12,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78464A516 | ST INTL BBG ETF | 438 | $12,000 | thousands by filing date | |
| POWERSHARES ETF TRUST | 73935X419 | CON DISCRE SEC | 258 | $12,000 | thousands by filing date | |
| FIRST TR EXCHANGE TRADED FD | 33734X143 | HLTH CARE ALPH | 155 | $10,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78464A672 | ST INTER ETF | 157 | $10,000 | thousands by filing date | |
| Costco Wholesale Corporation | 22160K105 | COM | 49 | $9,000 | thousands by filing date | |
| POWERSHARES ETF TRUST | 73935X591 | DYN UTIL PORTF | 299 | $9,000 | thousands by filing date | |
| iShares JP Morgan EM Local Ccy Bd ETF | 464286517 | SHS | 169 | $8,000 | thousands by filing date | |
| FIDELITY COVINGTON TRUST | 316092600 | MSCI HLTH CARE I | 219 | $8,000 | thousands by filing date | |
| ISHARES INC | 464286749 | MSCI SWITZERLAND | 240 | $8,000 | thousands by filing date | |
| FIRST TR EXCHANGE-TRADED FD | 33733E203 | NY ARCA BIOTECH | 59 | $7,000 | thousands by filing date | |
| POWERSHARES ETF TRUST HLTHCR S | 73935X351 | COM | 123 | $7,000 | thousands by filing date | |
| Mkt Vctrs J P Mrgn Em | 92189F494 | COM | 279 | $6,000 | thousands by filing date | |
| POWERSHS DB US DOLLAR INDEX DO | 73936D107 | COM | 126 | $4,000 | thousands by filing date | |
| POWERSHARES ETF TRUST | 73935X427 | BASIC MAT SECT | 50 | $4,000 | thousands by filing date | |
| Eli Lilly and Company | 532457108 | COM | 29 | $3,000 | thousands by filing date | |
| ALASKA AIR GROUP INC COM | 011659109 | Stock | 24 | $3,000 | thousands by filing date | |
| CHURCH & DWIGHT CO INC COM | 171340102 | Stock | 57 | $3,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78464A474 | ST SHOR CORP ETF | 70 | $3,000 | thousands by filing date | |
| ISHARES INC | 464286301 | CMN | 127 | $3,000 | thousands by filing date | |
| SWEDISH EXPT CR CORP | 870297306 | RG ENRGY ETN22 | 960 | $3,000 | thousands by filing date | |
| ETFS PRECIOUS METALSBASKET TR ETFS PHYSICAL PM BASKET SHS | 26922W109 | ETF | 41 | $3,000 | thousands by filing date | |
| POWERSHARES ACTIVE | 73935B805 | MNG ETF T S\&P.* DWNHDGE | 108 | $3,000 | thousands by filing date | |
| Vaneck Vectors AMT-Free Inter | 92189F544 | ETF | 99 | $3,000 | thousands by filing date | |
| iShares Core MSCI EAFE ETF | 46432F842 | SHS | 31 | $2,000 | thousands by filing date | |
| KLA CORP | 482480100 | COM | 11 | $2,000 | thousands by filing date | |
| Marsh & McLennan Companies,Inc. | 571748102 | COM | 20 | $2,000 | thousands by filing date | |
| Wells Fargo & Company | 949746101 | COM | 30 | $2,000 | thousands by filing date | |
| ISHARES TR | 464288281 | JPMORGAN USD EMG | 11 | $2,000 | thousands by filing date | |
| WEYERHAEUSER CO COM NEW | 962166104 | REIT | 45 | $2,000 | thousands by filing date | |
| ISHARES MSCI NETHERLANDSETF | 464286814 | ETF | 47 | $2,000 | thousands by filing date | |
| ISHARES TR | 46429B309 | MSCI INDONIA ETF | 72 | $2,000 | thousands by filing date | |
| ABRDN PHYSICAL SILVER SHARES ETF | 26922X107 | COM | 110 | $2,000 | thousands by filing date | |
| ALPS ETF TR | 00162Q734 | US EQTHIVOLPT WR | 61 | $2,000 | thousands by filing date | |
| DELL TECHNOLOGIES INC CLASS CLASS C | 24703L103 | CLASS C | 16 | $2,000 | thousands by filing date | |
| Abbott Laboratories | 002824100 | COM | 11 | $1,000 | thousands by filing date | |
| Automatic Data Processing,Inc. | 053015103 | COM | 1 | $1,000 | thousands by filing date | |
| Goldman Sachs Group,Inc. | 38141G104 | COM | 4 | $1,000 | thousands by filing date | |
| Honeywell Technologies | 438516106 | COM | 8 | $1,000 | thousands by filing date | |
| Intuit Inc. | 461202103 | COM | 1 | $1,000 | thousands by filing date | |
| iShares Expanded Tech Sector ETF | 464287549 | SHS | 2 | $1,000 | thousands by filing date | |
| iShares Expanded Tech-Software Sector ETF | 464287515 | SHS | 1 | $1,000 | thousands by filing date | |
| iShares iBoxx Inv Grade Corporate Bond ETF | 464287242 | SHS | 1 | $1,000 | thousands by filing date | |
| iShares MSCI USA Min Vol Factor ETF | 46429B697 | SHS | 1 | $1,000 | thousands by filing date | |
| iShares Russell 2000 ETF | 464287655 | SHS | 1 | $1,000 | thousands by filing date | |
| iShares Short Treasury Bond ETF | 464288679 | SHS | 1 | $1,000 | thousands by filing date | |
| iShares U.S. Medical Devices ETF | 464288810 | SHS | 1 | $1,000 | thousands by filing date | |
| NVIDIA Corp | 67066G104 | COM | 9 | $1,000 | thousands by filing date | |
| Schwab Intermediate-Term US Treasury ETF | 808524854 | SHS | 1 | $1,000 | thousands by filing date | |
| SPDR Portfolio Long Term Corporate Bond ETF | 78464A367 | SHS | 3 | $1,000 | thousands by filing date | |
| SPDR S&P Metals & Mining ETF | 78464A755 | SHS | 1 | $1,000 | thousands by filing date | |
| United Parcel Service,Inc. Class B | 911312106 | COM | 3 | $1,000 | thousands by filing date | |
| Vanguard Communication Services ETF | 92204A884 | SHS | 1 | $1,000 | thousands by filing date | |
| Vanguard S&P 500 ETF | 922908363 | COM | 1 | $1,000 | thousands by filing date | |
| Vanguard Short-Term Bond ETF | 921937827 | SHS | 1 | $1,000 | thousands by filing date | |
| Vanguard Value ETF | 922908744 | SHS | 1 | $1,000 | thousands by filing date | |
| Vanguard Intermediate-Term Bond ETF | 921937819 | SHS | 1 | $1,000 | thousands by filing date | |
| PAYPALHLDGSINC | 70450Y103 | STOK | 1 | $1,000 | thousands by filing date | |
| ISHARESAGENCYBONDETF | 464288166 | STOK | 1 | $1,000 | thousands by filing date | |
| ISHARES TR | 464287234 | MSCI EMG MKT ETF | 1 | $1,000 | thousands by filing date | |
| ISHARES TR | 464287184 | CHINA LG-CAP ETF | 8 | $1,000 | thousands by filing date | |
| EMERSON ELEC CO COM | 291011104 | Stock | 15 | $1,000 | thousands by filing date | |
| KIMBERLY-CLARK CORP COM | 494368103 | Stock | 2 | $1,000 | thousands by filing date | |
| EQUIFAX INC COM | 294429105 | Stock | 8 | $1,000 | thousands by filing date | |
| NORTHERN TR CORP COM | 665859104 | Stock | 10 | $1,000 | thousands by filing date | |
| ZOETIS INC CL A | 98978V103 | Stock | 3 | $1,000 | thousands by filing date | |
| MACYS INC COM | 55616P104 | Stock | 7 | $1,000 | thousands by filing date | |
| FASTENAL CO COM | 311900104 | Stock | 18 | $1,000 | thousands by filing date | |
| GENERAL DYNAMICS CORP COM | 369550108 | Stock | 5 | $1,000 | thousands by filing date | |
| QUEST DIAGNOSTICS INC COM | 74834L100 | Stock | 5 | $1,000 | thousands by filing date | |
| KIMCO REALTY CORP COM | 49446R109 | REIT | 34 | $1,000 | thousands by filing date | |
| HARLEY DAVIDSON INC COM | 412822108 | Stock | 15 | $1,000 | thousands by filing date | |
| DOLLAR TREE INC COM | 256746108 | Stock | 11 | $1,000 | thousands by filing date | |
| HUNTINGTON BANCSHARES INC COM | 446150104 | Stock | 63 | $1,000 | thousands by filing date | |
| ISHARES MSCI EAFE GROWTH ETF | 464288885 | ETF | 1 | $1,000 | thousands by filing date | |
| ISHARES RUSSELL MID-CAP GROWTH ETF | 464287481 | ETF | 2 | $1,000 | thousands by filing date | |
| ELECTRONIC ARTS INC COM | 285512109 | Stock | 10 | $1,000 | thousands by filing date | |
| BLOCK H & R INC COM | 093671105 | Stock | 2 | $1,000 | thousands by filing date | |
| CROWN CASTLE INC COM | 22822V101 | REIT | 2 | $1,000 | thousands by filing date | |
| HEWLETT PACKARD ENTERPRISE CO COM | 42824C109 | Stock | 2 | $1,000 | thousands by filing date | |
| EBAY INC. COM | 278642103 | Stock | 29 | $1,000 | thousands by filing date | |
| MOTOROLA SOLUTIONS INC COM NEW | 620076307 | Stock | 1 | $1,000 | thousands by filing date | |
| GAP INC COM | 364760108 | Stock | 33 | $1,000 | thousands by filing date | |
| BIOGEN INC COM | 09062X103 | Stock | 3 | $1,000 | thousands by filing date | |
| VENTAS INC COM | 92276F100 | REIT | 10 | $1,000 | thousands by filing date | |
| ESSEX PPTY TR INC COM | 297178105 | REIT | 4 | $1,000 | thousands by filing date | |
| HUNT J B TRANS SVCS INC COM | 445658107 | Stock | 9 | $1,000 | thousands by filing date | |
| HP INC COM | 40434L105 | Stock | 2 | $1,000 | thousands by filing date | |
| HUMANA INC COM | 444859102 | Stock | 5 | $1,000 | thousands by filing date | |
| ISHARES TR | 464287770 | U.S. FIN SVC ETF | 2 | $1,000 | thousands by filing date | |
| ISHARES TR | 464287739 | U.S. REAL ES ETF | 1 | $1,000 | thousands by filing date | |
| ISHARES TR | 464287762 | US HLTHCARE ETF | 2 | $1,000 | thousands by filing date | |
| ISHARES TR | 464287754 | US INDUSTRIALS | 3 | $1,000 | thousands by filing date | |
| MASCO CORP | 574599106 | COM | 27 | $1,000 | thousands by filing date | |
| NEW YORK LIFE INVESTMENTS ET | 45409B107 | NYLI HEDGE MULTI | 1 | $1,000 | thousands by filing date | |
| PROSHARES TR | 74347R248 | LARGE CAP CRE | 1 | $1,000 | thousands by filing date | |
| VANGUARD BD INDEX FDS | 921937793 | LONG TERM BOND | 1 | $1,000 | thousands by filing date | |
| ISHARES INC MSCI SPAIN ETF | 464286764 | MSCI SPAIN ETF | 1 | $1,000 | thousands by filing date | |
| VANGUARD WORLD FD | 921910709 | EXTENDED DUR | 1 | $1,000 | thousands by filing date | |
| WISDOMTREE TR | 97717W851 | JAPN HEDGE EQT | 1 | $1,000 | thousands by filing date | |
| GAMESTOP CORP | 36467W109 | CL A | 14 | $1,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78464A722 | ST STR SP PHARMA | 1 | $1,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78464A797 | ST STR SP BANK | 1 | $1,000 | thousands by filing date | |
| ISHARES TR | 464288828 | US HLTHCR PR ETF | 1 | $1,000 | thousands by filing date | |
| MOHAWK INDS INC | 608190104 | COM | 5 | $1,000 | thousands by filing date | |
| FEDERAL REALTY INVESTMENT TRUS | 313747206 | SH BEN INT NEW | 6 | $1,000 | thousands by filing date | |
| GOODYEAR TIRE & RUBBER CO | 382550101 | COM | 23 | $1,000 | thousands by filing date | |
| NORDSTROM INC | 655664100 | COM | 5 | $1,000 | thousands by filing date | |
| STERICYCLE INC | 858912108 | COM | 4 | $1,000 | thousands by filing date | |
| JACOBS ENGINEERING GROUP INC | 469814107 | COM | 15 | $1,000 | thousands by filing date | |
| CALIFORNIA RES CORP | 13057Q206 | COM NEW | 1 | $1,000 | thousands by filing date | |
| VANECK ETF TRUST | 92189F528 | VANECK SHRT MUNI | 1 | $1,000 | thousands by filing date | |
| SPDR INDEX SHS FDS | 78463X772 | S&P INTL ETF | 1 | $1,000 | thousands by filing date | |
| PIMCO ETF TR | 72201R882 | 25YR ZERO U S | 1 | $1,000 | thousands by filing date | |
| FIRST TR EXCHANGE-TRADED FD | 33733E807 | NAT GAS ETF | 1 | $1,000 | thousands by filing date | |
| ISHARES TR | 464287531 | US DIGI REAL ETF | 1 | $1,000 | thousands by filing date | |
| ISHARES TR | 464288489 | INTL DEV RE ETF | 1 | $1,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78464A789 | ST STR SP INS | 1 | $1,000 | thousands by filing date | |
| ISHARES MSCI TURKEY ETF | 464286715 | ETF | 16 | $1,000 | thousands by filing date | |
| SPDR SERIES TRUST | 78464A532 | STATE STREET SPD | 3 | $1,000 | thousands by filing date | |
| PROSHARES TR | 74347B201 | PSHS ULTSH 20YRS | 1 | $1,000 | thousands by filing date | |
| ISHARES INDIA 50 ETF | 464289529 | UIT EXCHANGE TRADED | 28 | $1,000 | thousands by filing date | |
| ISHARES TR | 46429B408 | CMN | 15 | $1,000 | thousands by filing date | |
| WISDOMTREE TR | 97717W786 | INTERNTNL AI ENH | 1 | $1,000 | thousands by filing date | |
| SCANA CORP NEW | 80589M102 | COM | 3 | $1,000 | thousands by filing date | |
| Lincoln National Corporat | 524901105 | COM | 28 | $1,000 | thousands by filing date | |
| GGP INC | 36174X101 | COM | 18 | $1,000 | thousands by filing date | |
| MONSANTO CO NEW | 61166W101 | COM | 2 | $1,000 | thousands by filing date | |
| POWERSHARES GLOBAL ETF FD | 73936G308 | S&P 500 BUYWRT | 1 | $1,000 | thousands by filing date | |
| POWERSHARES ETF TR II | 73937B407 | TXBLE MUN PRTFLO | 2 | $1,000 | thousands by filing date | |
| CURRENCYSHARES EURO TRUST | 23130C108 | COMMON STOCK | 1 | $1,000 | thousands by filing date | |
| SHIRE PLC | 82481R106 | COMMON STOCK-FO | 1 | $1,000 | thousands by filing date | |
| HYD | 92189F361 | ETF | 13 | $1,000 | thousands by filing date | |
| SPDR SERIES TRUST OILGAS EQUIP | 78464A748 | COM | 1 | $1,000 | thousands by filing date | |
| BARCLAYS BANK PLC | 06739H206 | ETN DJUBS AGRI37 | 1 | $1,000 | thousands by filing date | |
| BARCLAYS BK PLC | 06741L609 | IPATH DYNM VIX | 1 | $1,000 | thousands by filing date | |
| RYDEX S&P EQ WEIGHT TECHN ETF(RYT) | 78355W817 | ETF | 1 | $1,000 | thousands by filing date | |
| PIMCO GLOBAL ADV INFL LKD BD STRAT(ILB) | 72201R791 | ETF | 14 | $1,000 | thousands by filing date | |
| ETRACS CMCI TOTAL RETURN ETN | 902641778 | CMN | 1 | $1,000 | thousands by filing date | |
| SWEDISH EXPT CR CORP | 870297405 | RG METAL ETN22 | 53 | $1,000 | thousands by filing date | |
| BIOVERATIV INC | 09075E100 | COM | 2 | $1,000 | thousands by filing date |
Amendment chain
| Filing | Role | Filed | Accepted | Ingested |
|---|---|---|---|---|
| 13F-HR 0001140361-17-019216 | this filing | 2017-05-10 | acceptance time not in the bulk data set |