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:etf = SPY×sector = Financial Services×sorted by as_of ↑×

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
SPYWTW2026-09-030.0484451154211.00Financial ServicesUNITED KINGDOMGBEuropeWILLIS TOWERS WATSONstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WTW
SPYWRB2026-09-030.0306423593070.00Financial ServicesUNITED STATESUSNorth AmericaBERKLEY W Rstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WRB
SPYWFC2026-09-030.40861437336635.00Financial ServicesUNITED STATESUSNorth AmericaWELLS FARGOstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27WFC
SPYV2026-09-030.94128920253865.00Financial ServicesUNITED STATESUSNorth AmericaVISAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27V
SPYUSB2026-09-030.14751718923517.00Financial ServicesUNITED STATESUSNorth AmericaUS BANCORPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27USB
SPYTRV2026-09-030.1193342597983.00Financial ServicesUNITED STATESUSNorth AmericaTRAVELERS COMPANIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TRV
SPYTROW2026-09-030.0356172617868.00Financial ServicesUNITED STATESUSNorth AmericaPRICE T ROWE GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TROW
SPYTFC2026-09-030.09640215222702.00Financial ServicesUNITED STATESUSNorth AmericaTRUIST FINANCIALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TFC
SPYSYF2026-09-030.0402694109900.00Financial ServicesUNITED STATESUSNorth AmericaSYNCHRONY FINANCIALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SYF
SPYSTT2026-09-030.0804673381336.00Financial ServicesUNITED STATESUSNorth AmericaSTATE STREETstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27STT
SPYSPGI2026-09-030.2044093697145.00Financial ServicesUNITED STATESUSNorth AmericaS&P GLOBALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SPGI
SPYSCHW2026-09-030.27017719947821.00Financial ServicesUNITED STATESUSNorth AmericaSCHWAB CHARLESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SCHW
SPYRJF2026-09-030.0471012119583.00Financial ServicesUNITED STATESUSNorth AmericaRAYMOND JAMES FINANCIALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27RJF
SPYRF2026-09-030.03894710427067.00Financial ServicesUNITED STATESUSNorth AmericaREGIONS FINANCIALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27RF
SPYPYPL2026-09-030.07495810777667.00Financial ServicesUNITED STATESUSNorth AmericaPAYPALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PYPL
SPYPRU2026-09-030.0640924239662.00Financial ServicesUNITED STATESUSNorth AmericaPRUDENTIAL FINANCIALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PRU
SPYPNC2026-09-030.1472884895748.00Financial ServicesUNITED STATESUSNorth AmericaPNC FINANCIAL SERVICES GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PNC
SPYPGR2026-09-030.1957277125114.00Financial ServicesUNITED STATESUSNorth AmericaPROGRESSIVEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PGR
SPYPFG2026-09-030.0349142400936.00Financial ServicesUNITED STATESUSNorth AmericaPRINCIPAL FINANCIAL GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27PFG
SPYNTRS2026-09-030.0517542260759.00Financial ServicesUNITED STATESUSNorth AmericaNORTHERN TRUSTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NTRS
SPYNDAQ2026-09-030.0661205458961.00Financial ServicesUNITED STATESUSNorth AmericaNASDAQstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NDAQ
SPYMTB2026-09-030.0527101789413.00Financial ServicesUNITED STATESUSNorth AmericaM&T BANKstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MTB
SPYMSCI2026-09-030.062711889358.00Financial ServicesUNITED STATESUSNorth AmericaMSCIstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MSCI
SPYMS2026-09-030.38969214625133.00Financial ServicesUNITED STATESUSNorth AmericaMORGAN STANLEYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MS
SPYMRSH2026-09-030.1361275886566.00Financial Services———Marsh & McLennanstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MRSH
SPYMET2026-09-030.0804066603628.00Financial ServicesUNITED STATESUSNorth AmericaMETLIFEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MET
SPYMCO2026-09-030.1135911835669.00Financial ServicesUNITED STATESUSNorth AmericaMOODYSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MCO
SPYMA2026-09-030.7076629846484.00Financial ServicesUNITED STATESUSNorth AmericaMASTERCARDstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MA
SPYL2026-09-030.0278392061770.00Financial ServicesUNITED STATESUSNorth AmericaLOEWSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27L
SPYKKR2026-09-030.1137738447566.00Financial ServicesUNITED STATESUSNorth AmericaKKR & COstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KKR
SPYKEY2026-09-030.03056311260266.00Financial ServicesUNITED STATESUSNorth AmericaKEYCORPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27KEY
SPYJPM2026-09-031.45291932703819.00Financial ServicesUNITED STATESUSNorth AmericaJPMORGAN CHASEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27JPM
SPYIVZ2026-09-030.0217875428115.00Financial ServicesUNITED STATESUSNorth AmericaINVESCOstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27IVZ
SPYICE2026-09-030.1395556910004.00Financial ServicesUNITED STATESUSNorth AmericaINTERCONTINENTAL EXCHANGEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ICE
SPYIBKR2026-09-030.0620795442908.00Financial ServicesUNITED STATESUSNorth AmericaINTERACTIVE BROKERSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27IBKR
SPYHIG2026-09-030.0575403349525.00Financial ServicesUNITED STATESUSNorth AmericaHARTFORD FINANCIAL SERVICES GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HIG
SPYHBAN2026-09-030.05184924768259.00Financial ServicesUNITED STATESUSNorth AmericaHUNTINGTON BANCSHARESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HBAN
SPYGS2026-09-030.4583963599233.00Financial ServicesUNITED STATESUSNorth AmericaGOLDMAN SACHS GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GS
SPYGL2026-09-030.020549948712.00Financial ServicesUNITED STATESUSNorth AmericaGLOBE LIFEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GL
SPYFITB2026-09-030.07451311046919.00Financial ServicesUNITED STATESUSNorth AmericaFIFTH THIRD BANCORPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27FITB
SPYFDS2026-09-030.017091445055.00Financial ServicesUNITED STATESUSNorth AmericaFACTSET RESEARCH SYSTEMSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27FDS
SPYERIE2026-09-030.009835310235.00Financial ServicesUNITED STATESUSNorth AmericaERIE INDEMNITYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27ERIE
SPYEG2026-09-030.022918483553.00Financial Services———EVEREST GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27EG
SPYCOF2026-09-030.2053997591497.00Financial ServicesUNITED STATESUSNorth AmericaCAPITAL ONE FINANCIALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27COF
SPYCME2026-09-030.1528624416840.00Financial ServicesUNITED STATESUSNorth AmericaCME GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CME
SPYCINF2026-09-030.0405261890299.00Financial ServicesUNITED STATESUSNorth AmericaCINCINNATI FINANCIALstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CINF
SPYCFG2026-09-030.0449065166833.00Financial ServicesUNITED STATESUSNorth AmericaCITIZENS FINANCIAL GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CFG
SPYCBOE2026-09-030.0469281281219.00Financial ServicesUNITED STATESUSNorth AmericaCBOE GLOBAL MARKETSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CBOE
SPYCB2026-09-030.1879484398304.00Financial ServicesSWITZERLANDCHEuropeCHUBBstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27CB
SPYC2026-09-030.35270920808183.00Financial ServicesUNITED STATESUSNorth AmericaCITIGROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27C