{"uid":"cap_4gqzJy_YH3Pa7FQpnn3B3","slug":"stablefinance-index-fund-holdings-lookup-7fae65ed","name":"StableFinance Index Fund Holdings Lookup","description":"ETF / index-fund holdings by fund ticker, or the funds holding a given security.","url":"https://stablefinance.dev/api/index-funds","method":"GET","headers":{},"bodySchema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["input"],"properties":{"input":{"type":"object","required":["type","method"],"properties":{"type":{"type":"string","const":"http"},"method":{"enum":["GET","HEAD","DELETE"],"type":"string"},"queryParams":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","properties":{"as_of":{"type":"string","pattern":"^\\d{4}-\\d{2}-\\d{2}$"},"limit":{"type":"integer","maximum":1000,"minimum":1},"offset":{"type":"integer","maximum":9007199254740991,"minimum":0},"ticker":{"type":"string","minLength":1},"holding":{"type":"string","minLength":1},"asset_class":{"enum":["equity","bond"],"type":"string"}},"additionalProperties":false}},"additionalProperties":false},"output":{"type":"object","required":["type"],"properties":{"type":{"type":"string"},"example":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","properties":{"fund":{"type":"object","propertyNames":{"type":"string"},"additionalProperties":{}},"funds":{"type":"array","items":{}},"ticker":{"type":"string"},"holding":{"type":"string"},"holdings":{"type":"array","items":{}},"security":{"type":"object","propertyNames":{"type":"string"},"additionalProperties":{}}},"additionalProperties":false}}}}},"responseSchema":{"type":"json","example":{"fund":{"name":"SPDR S&P 500 ETF Trust","as_of":"2026-05-28","ticker":"SPY","asset_class":"equity","total_assets":615000000000},"ticker":"SPY","holdings":[{"name":"Apple Inc","shares":178500000,"ticker":"AAPL","weight":0.071,"market_value":55700000000}]}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.02","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"settled","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.02/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.02","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.02","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_OYdx2ETDPQQK5RSxjGC2c","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.02","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Retrieves ETF/index-fund holdings by fund ticker, or finds which funds hold a given security, with optional date and asset class filtering.","exampleAgentPrompt":"What are the current equity holdings of QQQ — I want to see every stock it holds, up to 100 results?","exampleUseCases":[{"title":"Build a portfolio overlap analysis tool","prompt":"Can you show me which stocks are held by both SPY and QQQ? I want to find the common positions so I can understand where our index funds overlap."},{"title":"Identify funds holding a specific security","prompt":"My client wants exposure to NVDA but prefers low-cost index funds. Which ETFs or index funds hold NVIDIA stock, and can you list a few of the biggest ones?"},{"title":"Compare fund compositions across asset classes","prompt":"I'm deciding between BND and other bond index funds for the fixed income portion of a portfolio. Show me the bond holdings of BND and tell me what types of bonds make up that fund."}],"resultDescription":"Returns a fund object with its metadata and a holdings array listing each security the fund holds (or, when querying by holding, a list of funds that contain that security), including details like security identifiers and allocation data.","failureModes":["Invalid or unknown ticker returns empty results or 404","Invalid date format for as_of (must be YYYY-MM-DD) returns 400","Exceeding limit maximum of 1000 returns validation error","No matching funds for the given holding ticker returns empty list","Payment not completed or insufficient USDC balance returns 402"],"whenToPreferThis":"Use this endpoint when you need to look up what securities a specific ETF or index fund holds, or to identify which funds contain a particular stock or bond. It is ideal for portfolio transparency, overlap analysis, or fund comparison tasks. Prefer this over general market data APIs when you specifically need fund composition and holdings data.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-13T12:49:40.182Z","isFirstParty":false}