Simplify Analytics
← Data Explorer

ETF holdings

core.etf_holdings

Class E accrual. Cash rows are sentinel-tickered; see the ck_etf_holdings_cash_is_sentinel constraint.

16,657 rowsCSV — whole table, not this view

Sources in this table

as_ofto
column equals (exact text)
sort
chart against as_of
reset
active:continent = North America×endpoint = /api/etfs/SPY/holdings×sector = Financial Services×

as_of leads no index, so this sort reads every matching row and keeps only the top 50 in a heap (the page LIMIT), under a 5s statement timeout.

etftexttickertextvintage_datedateweightnumericsharesnumericsectortextcountry_nametextcountry_codetextcontinenttextshort_nametextsecurity_typetexthas_optionsbooleancusiptextisintextsourcetextendpointtextrequest_paramsjsonbas_of ↓datevintage_tstimestamp with time zoneretrieved_attimestamp with time zonevendor_tickertext
SPYWRB2026-09-160.0316213517420.00Financial ServicesUNITED STATESUSNorth AmericaBERKLEY W Rstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WRB
SPYWFC2026-09-160.40888736548095.00Financial ServicesUNITED STATESUSNorth AmericaWELLS FARGOstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WFC
SPYV2026-09-160.94515219826220.00Financial ServicesUNITED STATESUSNorth AmericaVISAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30V
SPYUSB2026-09-160.14219518523462.00Financial ServicesUNITED STATESUSNorth AmericaUS BANCORPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30USB
SPYTRV2026-09-160.1238532543248.00Financial ServicesUNITED STATESUSNorth AmericaTRAVELERS COMPANIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TRV
SPYTROW2026-09-160.0337262562688.00Financial ServicesUNITED STATESUSNorth AmericaPRICE T ROWE GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TROW
SPYTFC2026-09-160.09277114901857.00Financial ServicesUNITED STATESUSNorth AmericaTRUIST FINANCIALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TFC
SPYSYF2026-09-160.0387174023125.00Financial ServicesUNITED STATESUSNorth AmericaSYNCHRONY FINANCIALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SYF
SPYSTT2026-09-160.0778093310136.00Financial ServicesUNITED STATESUSNorth AmericaSTATE STREETstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30STT
SPYSPGI2026-09-160.1891803618825.00Financial ServicesUNITED STATESUSNorth AmericaS&P GLOBALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SPGI
SPYSCHW2026-09-160.26390819526851.00Financial ServicesUNITED STATESUSNorth AmericaSCHWAB CHARLESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SCHW
SPYRJF2026-09-160.0438892075083.00Financial ServicesUNITED STATESUSNorth AmericaRAYMOND JAMES FINANCIALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30RJF
SPYRF2026-09-160.03734810207237.00Financial ServicesUNITED STATESUSNorth AmericaREGIONS FINANCIALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30RF
SPYPYPL2026-09-160.07147010550272.00Financial ServicesUNITED STATESUSNorth AmericaPAYPALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PYPL
SPYPRU2026-09-160.0624274150217.00Financial ServicesUNITED STATESUSNorth AmericaPRUDENTIAL FINANCIALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PRU
SPYPNC2026-09-160.1425824792508.00Financial ServicesUNITED STATESUSNorth AmericaPNC FINANCIAL SERVICES GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PNC
SPYPGR2026-09-160.1945076974704.00Financial ServicesUNITED STATESUSNorth AmericaPROGRESSIVEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PGR
SPYPFG2026-09-160.0352312350206.00Financial ServicesUNITED STATESUSNorth AmericaPRINCIPAL FINANCIAL GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PFG
SPYNTRS2026-09-160.0502422213144.00Financial ServicesUNITED STATESUSNorth AmericaNORTHERN TRUSTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NTRS
SPYNDAQ2026-09-160.0609585343706.00Financial ServicesUNITED STATESUSNorth AmericaNASDAQstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NDAQ
SPYMTB2026-09-160.0508781751588.00Financial ServicesUNITED STATESUSNorth AmericaM&T BANKstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MTB
SPYMSCI2026-09-160.060493870668.00Financial ServicesUNITED STATESUSNorth AmericaMSCIstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MSCI
SPYMS2026-09-160.37243814316303.00Financial ServicesUNITED STATESUSNorth AmericaMORGAN STANLEYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MS
SPYMET2026-09-160.0807786464343.00Financial ServicesUNITED STATESUSNorth AmericaMETLIFEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MET
SPYMCO2026-09-160.1074581796954.00Financial ServicesUNITED STATESUSNorth AmericaMOODYSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MCO
SPYMA2026-09-160.7033059638669.00Financial ServicesUNITED STATESUSNorth AmericaMASTERCARDstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MA
SPYL2026-09-160.0282172018160.00Financial ServicesUNITED STATESUSNorth AmericaLOEWSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30L
SPYKKR2026-09-160.1029228269566.00Financial ServicesUNITED STATESUSNorth AmericaKKR & COstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KKR
SPYKEY2026-09-160.02935211022636.00Financial ServicesUNITED STATESUSNorth AmericaKEYCORPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KEY
SPYJPM2026-09-161.43559032013624.00Financial ServicesUNITED STATESUSNorth AmericaJPMORGAN CHASEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30JPM
SPYIVZ2026-09-160.0205425313750.00Financial ServicesUNITED STATESUSNorth AmericaINVESCOstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30IVZ
SPYICE2026-09-160.1339706764489.00Financial ServicesUNITED STATESUSNorth AmericaINTERCONTINENTAL EXCHANGEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ICE
SPYIBKR2026-09-160.0593975328098.00Financial ServicesUNITED STATESUSNorth AmericaINTERACTIVE BROKERSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30IBKR
SPYHIG2026-09-160.0568623278770.00Financial ServicesUNITED STATESUSNorth AmericaHARTFORD FINANCIAL SERVICES GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HIG
SPYHBAN2026-09-160.04881324245829.00Financial ServicesUNITED STATESUSNorth AmericaHUNTINGTON BANCSHARESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HBAN
SPYGS2026-09-160.4247103523138.00Financial ServicesUNITED STATESUSNorth AmericaGOLDMAN SACHS GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30GS
SPYGL2026-09-160.020646928687.00Financial ServicesUNITED STATESUSNorth AmericaGLOBE LIFEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30GL
SPYFITB2026-09-160.07283510813294.00Financial ServicesUNITED STATESUSNorth AmericaFIFTH THIRD BANCORPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30FITB
SPYFDS2026-09-160.015478435710.00Financial ServicesUNITED STATESUSNorth AmericaFACTSET RESEARCH SYSTEMSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30FDS
SPYERIE2026-09-160.009581303560.00Financial ServicesUNITED STATESUSNorth AmericaERIE INDEMNITYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ERIE
SPYCOF2026-09-160.1940607431297.00Financial ServicesUNITED STATESUSNorth AmericaCAPITAL ONE FINANCIALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30COF
SPYCME2026-09-160.1513904323390.00Financial ServicesUNITED STATESUSNorth AmericaCME GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CME
SPYCINF2026-09-160.0406081850249.00Financial ServicesUNITED STATESUSNorth AmericaCINCINNATI FINANCIALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CINF
SPYCFG2026-09-160.0434485057808.00Financial ServicesUNITED STATESUSNorth AmericaCITIZENS FINANCIAL GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CFG
SPYCBOE2026-09-160.0435861254074.00Financial ServicesUNITED STATESUSNorth AmericaCBOE GLOBAL MARKETSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CBOE
SPYC2026-09-160.34803820368968.00Financial ServicesUNITED STATESUSNorth AmericaCITIGROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30C
SPYBX2026-09-160.1406578865462.00Financial ServicesUNITED STATESUSNorth AmericaBLACKSTONEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30BX
SPYBRO2026-09-160.0295193486387.00Financial ServicesUNITED STATESUSNorth AmericaBROWN & BROWNstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30BRO
SPYBLK2026-09-160.2298311724092.00Financial ServicesUNITED STATESUSNorth AmericaBLACKROCKstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30BLK
SPYBEN2026-09-160.0154233667723.00Financial ServicesUNITED STATESUSNorth AmericaFRANKLIN RESOURCESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30BEN