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×country_code = CA×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
XLYLULU2026-06-300.298211590086.00Consumer CyclicalCANADACANorth AmericaLULULEMON ATHLETICAstocktrue——uw_etf_holdings/api/etfs/XLY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LULU
SPYLULU2026-09-030.0191201279662.00Consumer CyclicalCANADACANorth AmericaLULULEMON ATHLETICAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27LULU
QQQTRI2026-09-030.1882578199706.00IndustrialsCANADACANorth AmericaTHOMSON REUTERSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27TRI
QQQSHOP2026-09-030.78183426241730.00TechnologyCANADACANorth AmericaSHOPIFYstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27SHOP
IWMXENE2026-09-050.1900002513213.00HealthcareCANADACANorth AmericaXENON PHARMACEUTICALSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27XENE
IWMNG2026-09-050.0900008913402.00Basic MaterialsCANADACANorth AmericaNOVAGOLD RESOURCESstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27NG
IWMMUX2026-09-050.0300001334362.00Basic MaterialsCANADACANorth AmericaMCEWEN MININGstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27MUX
IWMIMAX2026-09-050.0800001182591.00Communication ServicesCANADACANorth AmericaIMAXstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27IMAX
IWMHUT2026-09-050.2900002653054.00Financial ServicesCANADACANorth AmericaHUT 8 MININGstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27HUT
IWMGOLD2026-09-050.030000516580.00Basic MaterialsCANADACANorth AmericaBARRICK GOLDstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27GOLD
IWMAUPH2026-09-050.0600003058487.00HealthcareCANADACANorth AmericaAURINIA PHARMACEUTICALSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-062026-09-06 23:272026-09-06 23:27AUPH
QQQTRI2026-09-070.1776828120374.00IndustrialsCANADACANorth AmericaTHOMSON REUTERSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57TRI
QQQSHOP2026-09-070.77583925987894.00TechnologyCANADACANorth AmericaSHOPIFYstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57SHOP
IWMXENE2026-09-080.1900002509979.00HealthcareCANADACANorth AmericaXENON PHARMACEUTICALSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57XENE
IWMNG2026-09-080.0900008901929.00Basic MaterialsCANADACANorth AmericaNOVAGOLD RESOURCESstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57NG
IWMMUX2026-09-080.0300001332647.00Basic MaterialsCANADACANorth AmericaMCEWEN MININGstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57MUX
IWMIMAX2026-09-080.0800001181072.00Communication ServicesCANADACANorth AmericaIMAXstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57IMAX
IWMHUT2026-09-080.3100002649638.00Financial ServicesCANADACANorth AmericaHUT 8 MININGstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57HUT
IWMGOLD2026-09-080.030000515915.00Basic MaterialsCANADACANorth AmericaBARRICK GOLDstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57GOLD
IWMAUPH2026-09-080.0600003054553.00HealthcareCANADACANorth AmericaAURINIA PHARMACEUTICALSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-082026-09-08 08:572026-09-08 08:57AUPH
SPYLULU2026-09-040.0158551277771.00Consumer CyclicalCANADACANorth AmericaLULULEMON ATHLETICAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30LULU
IWMXENE2026-09-090.1900002509979.00HealthcareCANADACANorth AmericaXENON PHARMACEUTICALSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30XENE
IWMNG2026-09-090.0900008901929.00Basic MaterialsCANADACANorth AmericaNOVAGOLD RESOURCESstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30NG
IWMMUX2026-09-090.0300001332647.00Basic MaterialsCANADACANorth AmericaMCEWEN MININGstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30MUX
IWMIMAX2026-09-090.0800001181072.00Communication ServicesCANADACANorth AmericaIMAXstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30IMAX
IWMHUT2026-09-090.3100002649638.00Financial ServicesCANADACANorth AmericaHUT 8 MININGstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30HUT
IWMGOLD2026-09-090.030000515915.00Basic MaterialsCANADACANorth AmericaBARRICK GOLDstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30GOLD
IWMAUPH2026-09-090.0600003054553.00HealthcareCANADACANorth AmericaAURINIA PHARMACEUTICALSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-092026-09-09 16:302026-09-09 16:30AUPH
SPYLULU2026-09-080.0163561279784.00Consumer CyclicalCANADACANorth AmericaLULULEMON ATHLETICAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30LULU
QQQTRI2026-09-080.1664188038037.00IndustrialsCANADACANorth AmericaTHOMSON REUTERSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30TRI
QQQSHOP2026-09-080.71795025724443.00TechnologyCANADACANorth AmericaSHOPIFYstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30SHOP
IWMXENE2026-09-100.1900002493809.00HealthcareCANADACANorth AmericaXENON PHARMACEUTICALSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30XENE
IWMNG2026-09-100.0900008844564.00Basic MaterialsCANADACANorth AmericaNOVAGOLD RESOURCESstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30NG
IWMMUX2026-09-100.0300001324072.00Basic MaterialsCANADACANorth AmericaMCEWEN MININGstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30MUX
IWMIMAX2026-09-100.0800001173477.00Communication ServicesCANADACANorth AmericaIMAXstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30IMAX
IWMHUT2026-09-100.3300002632558.00Financial ServicesCANADACANorth AmericaHUT 8 MININGstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30HUT
IWMGOLD2026-09-100.030000512590.00Basic MaterialsCANADACANorth AmericaBARRICK GOLDstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30GOLD
IWMAUPH2026-09-100.0600003034883.00HealthcareCANADACANorth AmericaAURINIA PHARMACEUTICALSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-102026-09-10 16:302026-09-10 16:30AUPH
SPYLULU2026-09-090.0158831280516.00Consumer CyclicalCANADACANorth AmericaLULULEMON ATHLETICAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30LULU
QQQTRI2026-09-090.1638288083713.00IndustrialsCANADACANorth AmericaTHOMSON REUTERSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30TRI
QQQSHOP2026-09-090.68079825870591.00TechnologyCANADACANorth AmericaSHOPIFYstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30SHOP
IWMXENE2026-09-110.1900002491037.00HealthcareCANADACANorth AmericaXENON PHARMACEUTICALSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30XENE
IWMNG2026-09-110.0900008834730.00Basic MaterialsCANADACANorth AmericaNOVAGOLD RESOURCESstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30NG
IWMMUX2026-09-110.0300001322602.00Basic MaterialsCANADACANorth AmericaMCEWEN MININGstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30MUX
IWMIMAX2026-09-110.0800001172175.00Communication ServicesCANADACANorth AmericaIMAXstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30IMAX
IWMHUT2026-09-110.3200002629630.00Financial ServicesCANADACANorth AmericaHUT 8 MININGstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30HUT
IWMGOLD2026-09-110.030000512020.00Basic MaterialsCANADACANorth AmericaBARRICK GOLDstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30GOLD
IWMAUPH2026-09-110.0600003031511.00HealthcareCANADACANorth AmericaAURINIA PHARMACEUTICALSstocktrue——uw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-112026-09-11 16:302026-09-11 16:30AUPH
SPYLULU2026-09-100.0155201286921.00Consumer CyclicalCANADACANorth AmericaLULULEMON ATHLETICAstocktrue——uw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30LULU
QQQTRI2026-09-100.1623188105950.00IndustrialsCANADACANorth AmericaTHOMSON REUTERSstocktrue——uw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30TRI