fund_quotas

Unadjusted B3 cash quotes for fund_quota: listed fund quotas (CI*/FIDC* paper). fund_type splits the family from B3’s published CODBDI board code: etf | fii | fidc | fiagro, NULL when the board carries no signal (odd lot) — filter fund_type=eq.etf for ETFs only. Grain (ticker, trade_date, board, term_days, lot) — lot is standard (tpmerc 010) or odd (020) or block (021), so filter lot=eq.standard for round lots only. Classified from published TPMERC/CODBDI/ESPECI; never inferred.

Paging. A GET view pages normally with limit/offset (and Range). Every response is cut at 1000 rows server-side regardless of tier; read Content-Range to detect it (0-999/* is a truncated page, and Prefer: count=exact turns the * into the total).

GET /fund_quotas

fund_quotas

cURL

curl --request GET \
  --url https://zcjbtpxuhdekpwcxmepn.supabase.co/rest/v1/fund_quotas \
  --header 'apikey: <api-key>'

200

[
  {
    "ticker": "<string>",
    "trade_date": "2023-12-25",
    "board": "<string>",
    "lot": "<string>",
    "term_days": "<string>",
    "short_name": "<string>",
    "spec": "<string>",
    "currency": "<string>",
    "open": 123,
    "high": 123,
    "low": 123,
    "average": 123,
    "close": 123,
    "bid": 123,
    "ask": 123,
    "trades": 123,
    "quantity": 123,
    "volume": 123,
    "isin": "<string>",
    "quotation_factor": 123,
    "adjusted": true,
    "source": "<string>",
    "fetched_at": "2023-11-07T05:31:56Z",
    "fund_type": "<string>",
    "close_unit": 123,
    "market": "<string>",
    "contract_price": 123,
    "contract_expiry": "2023-12-25",
    "contract_correction": "<string>",
    "contract_points": 123,
    "contract_points_raw": "<string>",
    "distribution_number": "<string>"
  }
]

Authorizations

apikey · string · header · required

The publishable key (sb_publishable_…), on every request. It is NOT a JWT — sending it as Authorization: Bearer is rejected as an invalid JWT. It identifies the project, not you, and maps to the Postgres anon role.

Query Parameters

select · string

Columns to return, comma separated. Omit for all of them.

order · string

Sort, e.g. trade_date.desc. Always order a paged read, or limit/offset walk an undefined sequence.

limit · integer

Rows to return. The server cuts every response at 1000 whatever you ask for.

Required range: x <= 1000

offset · integer

Rows to skip. Pairs with limit and order to page.

ticker · string

PostgREST filter on ticker — eq., neq., gt., gte., lt., lte., in., is. (e.g. ticker=eq.<value>).

trade_date · string

PostgREST filter on trade_date — eq., neq., gt., gte., lt., lte., in., is. (e.g. trade_date=eq.<value>).

board · string

PostgREST filter on board — eq., neq., gt., gte., lt., lte., in., is. (e.g. board=eq.<value>).

lot · string

PostgREST filter on lot — eq., neq., gt., gte., lt., lte., in., is. (e.g. lot=eq.<value>).

term_days · string

PostgREST filter on term_days — eq., neq., gt., gte., lt., lte., in., is. (e.g. term_days=eq.<value>).

short_name · string

PostgREST filter on short_name — eq., neq., gt., gte., lt., lte., in., is. (e.g. short_name=eq.<value>).

spec · string

PostgREST filter on spec — eq., neq., gt., gte., lt., lte., in., is. (e.g. spec=eq.<value>).

currency · string

PostgREST filter on currency — eq., neq., gt., gte., lt., lte., in., is. (e.g. currency=eq.<value>).

open · string

PostgREST filter on open — eq., neq., gt., gte., lt., lte., in., is. (e.g. open=eq.<value>).

high · string

PostgREST filter on high — eq., neq., gt., gte., lt., lte., in., is. (e.g. high=eq.<value>).

low · string

PostgREST filter on low — eq., neq., gt., gte., lt., lte., in., is. (e.g. low=eq.<value>).

average · string

PostgREST filter on average — eq., neq., gt., gte., lt., lte., in., is. (e.g. average=eq.<value>).

close · string

PostgREST filter on close — eq., neq., gt., gte., lt., lte., in., is. (e.g. close=eq.<value>).

bid · string

PostgREST filter on bid — eq., neq., gt., gte., lt., lte., in., is. (e.g. bid=eq.<value>).

ask · string

PostgREST filter on ask — eq., neq., gt., gte., lt., lte., in., is. (e.g. ask=eq.<value>).

trades · string

PostgREST filter on trades — eq., neq., gt., gte., lt., lte., in., is. (e.g. trades=eq.<value>).

quantity · string

PostgREST filter on quantity — eq., neq., gt., gte., lt., lte., in., is. (e.g. quantity=eq.<value>).

volume · string

PostgREST filter on volume — eq., neq., gt., gte., lt., lte., in., is. (e.g. volume=eq.<value>).

isin · string

PostgREST filter on isin — eq., neq., gt., gte., lt., lte., in., is. (e.g. isin=eq.<value>).

quotation_factor · string

PostgREST filter on quotation_factor — eq., neq., gt., gte., lt., lte., in., is. (e.g. quotation_factor=eq.<value>).

adjusted · string

PostgREST filter on adjusted — eq., neq., gt., gte., lt., lte., in., is. (e.g. adjusted=eq.<value>).

source · string

PostgREST filter on source — eq., neq., gt., gte., lt., lte., in., is. (e.g. source=eq.<value>).

fetched_at · string

PostgREST filter on fetched_at — eq., neq., gt., gte., lt., lte., in., is. (e.g. fetched_at=eq.<value>).

fund_type · string

PostgREST filter on fund_type — eq., neq., gt., gte., lt., lte., in., is. (e.g. fund_type=eq.<value>).

close_unit · string

PostgREST filter on close_unit — eq., neq., gt., gte., lt., lte., in., is. (e.g. close_unit=eq.<value>).

market · string

PostgREST filter on market — eq., neq., gt., gte., lt., lte., in., is. (e.g. market=eq.<value>).

contract_price · string

PostgREST filter on contract_price — eq., neq., gt., gte., lt., lte., in., is. (e.g. contract_price=eq.<value>).

contract_expiry · string

PostgREST filter on contract_expiry — eq., neq., gt., gte., lt., lte., in., is. (e.g. contract_expiry=eq.<value>).

contract_correction · string

PostgREST filter on contract_correction — eq., neq., gt., gte., lt., lte., in., is. (e.g. contract_correction=eq.<value>).

contract_points · string

PostgREST filter on contract_points — eq., neq., gt., gte., lt., lte., in., is. (e.g. contract_points=eq.<value>).

contract_points_raw · string

PostgREST filter on contract_points_raw — eq., neq., gt., gte., lt., lte., in., is. (e.g. contract_points_raw=eq.<value>).

distribution_number · string

PostgREST filter on distribution_number — eq., neq., gt., gte., lt., lte., in., is. (e.g. distribution_number=eq.<value>).

Response

200

application/json

Matching rows.

ticker · string | null

trade_date · string<date> | null

board · string | null

lot · string | null

term_days · string | null

short_name · string | null

spec · string | null

currency · string | null

open · number | null

high · number | null

low · number | null

average · number | null

close · number | null

bid · number | null

ask · number | null

trades · integer<int32> | null

quantity · number | null

volume · number | null

isin · string | null

quotation_factor · integer<int32> | null

adjusted · boolean | null

source · string | null

fetched_at · string<date-time> | null

fund_type · string | null

close_unit · number | null

market · string | null

contract_price · number | null

contract_expiry · string<date> | null

contract_correction · string | null

contract_points · number | null

contract_points_raw · string | null

distribution_number · string | null