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 = Real Estate×

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
SPYWY2026-09-160.0239888558098.00Real EstateUNITED STATESUSNorth AmericaWEYERHAEUSERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WY
SPYWELL2026-09-160.2540858430749.00Real EstateUNITED STATESUSNorth AmericaWELLTOWERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30WELL
SPYVTR2026-09-160.0659295815515.00Real EstateUNITED STATESUSNorth AmericaVENTASstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VTR
SPYVMRK2026-09-160.0704928707649.00Real Estate———Vivmark Residentialstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VMRK
SPYVICI2026-09-160.04039113056882.00Real EstateUNITED STATESUSNorth AmericaVICI PROPERTIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30VICI
SPYUDR2026-09-160.0156343536238.00Real EstateUNITED STATESUSNorth AmericaUDRstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30UDR
SPYSPG2026-09-160.1011593878544.00Real EstateUNITED STATESUSNorth AmericaSIMON PROPERTY GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SPG
SPYSBAC2026-09-160.0293451268383.00Real EstateUNITED STATESUSNorth AmericaSBA COMMUNICATIONSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SBAC
SPYREG2026-09-160.0185601971200.00Real EstateUNITED STATESUSNorth AmericaREGENCY CENTERSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30REG
SPYPSA2026-09-160.0759722006023.00Real EstateUNITED STATESUSNorth AmericaPUBLIC STORAGEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PSA
SPYPLD2026-09-160.19451911317023.00Real EstateUNITED STATESUSNorth AmericaPROLOGISstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30PLD
SPYO2026-09-160.08191711152872.00Real EstateUNITED STATESUSNorth AmericaREALTY INCOMEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30O
SPYMAA2026-09-160.0218051391830.00Real EstateUNITED STATESUSNorth AmericaMID AMERICA APARTMENT COMMUNITIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MAA
SPYKIM2026-09-160.0234208066703.00Real EstateUNITED STATESUSNorth AmericaKIMCO REALTYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30KIM
SPYIRM2026-09-160.0512893558398.00Real EstateUNITED STATESUSNorth AmericaIRON MOUNTAINstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30IRM
SPYINVH2026-09-160.0228616537315.00Real EstateUNITED STATESUSNorth AmericaINVITATION HOMESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30INVH
SPYHST2026-09-160.0213047618026.00Real EstateUNITED STATESUSNorth AmericaHOST HOTELS & RESORTSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HST
SPYFRT2026-09-160.013629943312.00Real EstateUNITED STATESUSNorth AmericaFEDERAL REALTY INVESTMENT TRUSTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30FRT
SPYEXR2026-09-160.0443032526679.00Real EstateUNITED STATESUSNorth AmericaEXTRA SPACE STORAGEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30EXR
SPYESS2026-09-160.026796768403.00Real EstateUNITED STATESUSNorth AmericaESSEX PROPERTY TRUSTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ESS
SPYEQIX2026-09-160.1539051178478.00Real EstateUNITED STATESUSNorth AmericaEQUINIXstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30EQIX
SPYDOC2026-09-160.0216528278914.00Real EstateUNITED STATESUSNorth AmericaPHYSICIANS REALTY TRUSTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30DOC
SPYDLR2026-09-160.0967434157224.00Real EstateUNITED STATESUSNorth AmericaDIGITAL REALTY TRUSTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30DLR
SPYCSGP2026-09-160.0190604884875.00Real EstateUNITED STATESUSNorth AmericaCOSTAR GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CSGP
SPYCPT2026-09-160.0156511202147.00Real EstateUNITED STATESUSNorth AmericaCAMDEN PROPERTY TRUSTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CPT
SPYCCI2026-09-160.0492095229369.00Real EstateUNITED STATESUSNorth AmericaCROWN CASTLEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CCI
SPYCBRE2026-09-160.0623673502270.00Real EstateUNITED STATESUSNorth AmericaCBRE GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30CBRE
SPYBXP2026-09-160.0145471767494.00Real EstateUNITED STATESUSNorth AmericaBOSTON PROPERTIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30BXP
SPYARE2026-09-160.0128541868811.00Real EstateUNITED STATESUSNorth AmericaALEXANDRIA REAL ESTATE EQUITIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30ARE
SPYAMT2026-09-160.1263225572329.00Real EstateUNITED STATESUSNorth AmericaAMERICAN TOWERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30AMT
SPYWY2026-09-150.0244098613142.00Real EstateUNITED STATESUSNorth AmericaWEYERHAEUSERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30WY
SPYWELL2026-09-150.2510858484737.00Real EstateUNITED STATESUSNorth AmericaWELLTOWERstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30WELL
SPYVTR2026-09-150.0658965852607.00Real EstateUNITED STATESUSNorth AmericaVENTASstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30VTR
SPYVMRK2026-09-150.0731248763617.00Real Estate———Vivmark Residentialstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30VMRK
SPYVICI2026-09-150.04136513140438.00Real EstateUNITED STATESUSNorth AmericaVICI PROPERTIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30VICI
SPYUDR2026-09-150.0157953558810.00Real EstateUNITED STATESUSNorth AmericaUDRstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30UDR
SPYSPG2026-09-150.1012873903360.00Real EstateUNITED STATESUSNorth AmericaSIMON PROPERTY GROUPstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30SPG
SPYSBAC2026-09-150.0297201276435.00Real EstateUNITED STATESUSNorth AmericaSBA COMMUNICATIONSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30SBAC
SPYREG2026-09-150.0186761983740.00Real EstateUNITED STATESUSNorth AmericaREGENCY CENTERSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30REG
SPYPSA2026-09-150.0761482018827.00Real EstateUNITED STATESUSNorth AmericaPUBLIC STORAGEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30PSA
SPYPLD2026-09-150.19515111389491.00Real EstateUNITED STATESUSNorth AmericaPROLOGISstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30PLD
SPYO2026-09-150.08378011224152.00Real EstateUNITED STATESUSNorth AmericaREALTY INCOMEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30O
SPYMAA2026-09-150.0221691400674.00Real EstateUNITED STATESUSNorth AmericaMID AMERICA APARTMENT COMMUNITIESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30MAA
SPYKIM2026-09-150.0237298118183.00Real EstateUNITED STATESUSNorth AmericaKIMCO REALTYstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30KIM
SPYIRM2026-09-150.0510113581102.00Real EstateUNITED STATESUSNorth AmericaIRON MOUNTAINstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30IRM
SPYINVH2026-09-150.0231196579027.00Real EstateUNITED STATESUSNorth AmericaINVITATION HOMESstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30INVH
SPYHST2026-09-150.0215717666734.00Real EstateUNITED STATESUSNorth AmericaHOST HOTELS & RESORTSstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30HST
SPYFRT2026-09-150.013752949384.00Real EstateUNITED STATESUSNorth AmericaFEDERAL REALTY INVESTMENT TRUSTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30FRT
SPYEXR2026-09-150.0443872542783.00Real EstateUNITED STATESUSNorth AmericaEXTRA SPACE STORAGEstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30EXR
SPYESS2026-09-150.027140773287.00Real EstateUNITED STATESUSNorth AmericaESSEX PROPERTY TRUSTstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30ESS