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:country_code = CA×

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_ofdatevintage_tstimestamp with time zoneretrieved_attimestamp with time zonevendor_tickertext
SPYLULU2026-09-160.0154501252517.00Consumer CyclicalCANADACANorth AmericaLULULEMON ATHLETICAstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30LULU
QQQTRI2026-09-160.1727678105880.00IndustrialsCANADACANorth AmericaTHOMSON REUTERSstocktrueuw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30TRI
QQQSHOP2026-09-160.71021925976132.00TechnologyCANADACANorth AmericaSHOPIFYstocktrueuw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30SHOP
IWMXENE2026-09-180.1800002533541.00HealthcareCANADACANorth AmericaXENON PHARMACEUTICALSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30XENE
IWMNG2026-09-180.0800008985518.00Basic MaterialsCANADACANorth AmericaNOVAGOLD RESOURCESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30NG
IWMMUX2026-09-180.0300001345142.00Basic MaterialsCANADACANorth AmericaMCEWEN MININGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30MUX
IWMIMAX2026-09-180.0800001192139.00Communication ServicesCANADACANorth AmericaIMAXstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30IMAX
IWMHUT2026-09-180.3100002674526.00Financial ServicesCANADACANorth AmericaHUT 8 MININGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30HUT
IWMGOLD2026-09-180.030000520760.00Basic MaterialsCANADACANorth AmericaBARRICK GOLDstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30GOLD
IWMAUPH2026-09-180.0700003083215.00HealthcareCANADACANorth AmericaAURINIA PHARMACEUTICALSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-182026-09-18 16:302026-09-18 16:30AUPH
SPYLULU2026-09-150.0157651260569.00Consumer CyclicalCANADACANorth AmericaLULULEMON ATHLETICAstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30LULU
QQQTRI2026-09-150.1750298089052.00IndustrialsCANADACANorth AmericaTHOMSON REUTERSstocktrueuw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30TRI
QQQSHOP2026-09-150.70985725922204.00TechnologyCANADACANorth AmericaSHOPIFYstocktrueuw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30SHOP
IWMXENE2026-09-170.1800002587133.00HealthcareCANADACANorth AmericaXENON PHARMACEUTICALSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30XENE
IWMNG2026-09-170.0800009175642.00Basic MaterialsCANADACANorth AmericaNOVAGOLD RESOURCESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30NG
IWMMUX2026-09-170.0300001373562.00Basic MaterialsCANADACANorth AmericaMCEWEN MININGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30MUX
IWMIMAX2026-09-170.0800001217311.00Communication ServicesCANADACANorth AmericaIMAXstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30IMAX
IWMHUT2026-09-170.3000002731134.00Financial ServicesCANADACANorth AmericaHUT 8 MININGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30HUT
IWMGOLD2026-09-170.030000531780.00Basic MaterialsCANADACANorth AmericaBARRICK GOLDstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30GOLD
IWMAUPH2026-09-170.0600003148407.00HealthcareCANADACANorth AmericaAURINIA PHARMACEUTICALSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-172026-09-17 16:302026-09-17 16:30AUPH
SPYLULU2026-09-140.0160061277588.00Consumer CyclicalCANADACANorth AmericaLULULEMON ATHLETICAstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30LULU
QQQTRI2026-09-140.1793088089653.00IndustrialsCANADACANorth AmericaTHOMSON REUTERSstocktrueuw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30TRI
QQQSHOP2026-09-140.72706725924130.00TechnologyCANADACANorth AmericaSHOPIFYstocktrueuw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30SHOP
IWMXENE2026-09-160.1900002555255.00HealthcareCANADACANorth AmericaXENON PHARMACEUTICALSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30XENE
IWMNG2026-09-160.0800009062551.00Basic MaterialsCANADACANorth AmericaNOVAGOLD RESOURCESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30NG
IWMMUX2026-09-160.0300001356657.00Basic MaterialsCANADACANorth AmericaMCEWEN MININGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30MUX
IWMIMAX2026-09-160.0800001202338.00Communication ServicesCANADACANorth AmericaIMAXstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30IMAX
IWMHUT2026-09-160.3100002697462.00Financial ServicesCANADACANorth AmericaHUT 8 MININGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30HUT
IWMGOLD2026-09-160.030000525225.00Basic MaterialsCANADACANorth AmericaBARRICK GOLDstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30GOLD
IWMAUPH2026-09-160.0600003109629.00HealthcareCANADACANorth AmericaAURINIA PHARMACEUTICALSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-162026-09-16 16:302026-09-16 16:30AUPH
SPYLULU2026-09-110.0157191281370.00Consumer CyclicalCANADACANorth AmericaLULULEMON ATHLETICAstocktrueuw_etf_holdings/api/etfs/SPY/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30LULU
QQQTRI2026-09-130.1636058110758.00IndustrialsCANADACANorth AmericaTHOMSON REUTERSstocktrueuw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30TRI
QQQSHOP2026-09-130.69268925957126.00TechnologyCANADACANorth AmericaSHOPIFYstocktrueuw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30SHOP
IWMXENE2026-09-150.1900002564957.00HealthcareCANADACANorth AmericaXENON PHARMACEUTICALSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30XENE
IWMNG2026-09-150.0900009096970.00Basic MaterialsCANADACANorth AmericaNOVAGOLD RESOURCESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30NG
IWMMUX2026-09-150.0300001361802.00Basic MaterialsCANADACANorth AmericaMCEWEN MININGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30MUX
IWMIMAX2026-09-150.0800001206895.00Communication ServicesCANADACANorth AmericaIMAXstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30IMAX
IWMHUT2026-09-150.3300002707710.00Financial ServicesCANADACANorth AmericaHUT 8 MININGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30HUT
IWMGOLD2026-09-150.030000527220.00Basic MaterialsCANADACANorth AmericaBARRICK GOLDstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30GOLD
IWMAUPH2026-09-150.0600003121431.00HealthcareCANADACANorth AmericaAURINIA PHARMACEUTICALSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-152026-09-15 16:302026-09-15 16:30AUPH
SPYLULU2026-09-100.0155201286921.00Consumer CyclicalCANADACANorth AmericaLULULEMON ATHLETICAstocktrueuw_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 REUTERSstocktrueuw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30TRI
QQQSHOP2026-09-100.68712825941742.00TechnologyCANADACANorth AmericaSHOPIFYstocktrueuw_etf_holdings/api/etfs/QQQ/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30SHOP
IWMXENE2026-09-120.1900002506283.00HealthcareCANADACANorth AmericaXENON PHARMACEUTICALSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30XENE
IWMNG2026-09-120.0900008888817.00Basic MaterialsCANADACANorth AmericaNOVAGOLD RESOURCESstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30NG
IWMMUX2026-09-120.0300001330687.00Basic MaterialsCANADACANorth AmericaMCEWEN MININGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30MUX
IWMIMAX2026-09-120.0800001179336.00Communication ServicesCANADACANorth AmericaIMAXstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30IMAX
IWMHUT2026-09-120.3100002645734.00Financial ServicesCANADACANorth AmericaHUT 8 MININGstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30HUT
IWMGOLD2026-09-120.030000515155.00Basic MaterialsCANADACANorth AmericaBARRICK GOLDstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30GOLD
IWMAUPH2026-09-120.0600003050057.00HealthcareCANADACANorth AmericaAURINIA PHARMACEUTICALSstocktrueuw_etf_holdings/api/etfs/IWM/holdings{"limit":1000}2026-09-142026-09-14 16:302026-09-14 16:30AUPH