Fruit StandFruit Stand
  • Pricing
  • Documentation
  • API Reference
  • Pricing
Getting Started
The Data
    MethodologyCoverage & limitationsField referenceFreshness & updates
Using the API
Policies
Links
    Fruit Stand homeSnowflake Marketplace (bulk)
powered by Zuplo
The Data

Field Reference

A human-readable companion to the API Reference schemas. All return values are decimal fractions (0.0523 = +5.23%) with up to 6 decimal places, and are null when the fund lacks enough history for that period.

Fund

Returned by GET /v1/funds (as a list) and GET /v1/funds/{code}.

FieldTypeNotes
codestringBare ticker, e.g. SPY. Primary key.
marketstringAlways US today. Reserved for future multi-market support.
namestring | nullFund name.
countrystring | nullDomicile country.
exchangestring | nullListing exchange.
currencystring | nullReporting currency.
typestring | nullSecurity type, e.g. ETF or FUND.
isinstring | nullISIN identifier, when available.
is_inactivebool | nulltrue if the fund is delisted/closed.
inactive_datedate | nullDate the fund went inactive.
min_return_datedate | nullEarliest date with return data (≈ inception).
max_return_datedate | nullLatest date with return data.

Trailing returns

Returned by GET /v1/funds/{code}/trailing-returns (one row) and POST /v1/trailing-returns/batch (one row per found code).

FieldTypeNotes
codestringBare ticker.
marketstringAlways US.
as_of_datedateThe trading day this row is for (after any snap-back).
return_1ddecimal | nullTrailing 1-day total return (cumulative).
return_1wdecimal | null1-week (cumulative).
return_1mdecimal | null1-month (cumulative).
return_3mdecimal | null3-month (cumulative).
return_6mdecimal | null6-month (cumulative).
return_ytddecimal | nullYear-to-date (cumulative).
return_1ydecimal | null1-year (cumulative).
return_2ydecimal | null2-year (annualized / CAGR).
return_3ydecimal | null3-year (annualized).
return_4ydecimal | null4-year (annualized).
return_5ydecimal | null5-year (annualized).
return_7ydecimal | null7-year (annualized).
return_10ydecimal | null10-year (annualized).
return_15ydecimal | null15-year (annualized).
return_20ydecimal | null20-year (annualized).
return_earliest_availabledecimal | nullSince inception (annualized).
extra_returnsobjectAny newer, seed-driven return_* period not yet a first-class field above. Usually empty. Forward-compatibility: new periods appear here without a breaking change.

Why extra_returns? The set of return periods is data-driven upstream. If a new period is added, it surfaces under extra_returns (as { "return_x": 0.123 }) rather than breaking your client. Read known periods from their named fields and treat extra_returns as optional extras.

Calendar-year returns

Returned by GET /v1/funds/{code}/calendar-returns (one row) and POST /v1/calendar-returns/batch (one row per found code).

FieldTypeNotes
codestringBare ticker.
marketstringAlways US.
calendar_yearintegerThe calendar year, e.g. 2024.
base_datedate | nullLast trading day of the prior year (or inception for the first year).
end_datedate | nullLast trading day of the year (or latest available for the current year).
calendar_year_returndecimal | nullTotal return over the year (always cumulative).

Pagination

GET /v1/funds returns a FundList:

FieldTypeNotes
dataFund[]The page of funds.
next_cursorstring | nullPass back as ?cursor= for the next page. null when there are no more.

See Errors, rate limits & quotas for pagination limits and error shapes, and Methodology for how each return is computed.

Last modified on September 8, 2026
Coverage & limitationsFreshness & updates
On this page
  • Fund
  • Trailing returns
  • Calendar-year returns
  • Pagination