di_settlement

DI1 futures settlement per B3 session and contract (b3_futures_settlement, B3 Price Report, from 2018-01-02): rate_pct and prev_rate_pct are B3’s settlement rate today and the session before, % a.a. on 252 business days, with open interest, contracts and trades. DI1 only; the dollar futures are api.future_curve / api.future_series. Nothing is derived. A GET returns at most 1000 rows, the OLDEST first: filter on trade_date or ticker and read Content-Range.

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 /di_settlement

di_settlement

cURL

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

200

[
  {
    "trade_date": "2023-12-25",
    "ticker": "<string>",
    "rate_pct": 123,
    "prev_rate_pct": 123,
    "open_interest": 123,
    "contracts": 123,
    "trades": 123
  }
]

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.

trade_date · string

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

ticker · string

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

rate_pct · string

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

prev_rate_pct · string

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

open_interest · string

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

contracts · string

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

trades · string

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

Response

200

application/json

Matching rows.

trade_date · string<date> | null

ticker · string | null

rate_pct · number | null

prev_rate_pct · number | null

open_interest · integer<int64> | null

contracts · integer<int64> | null

trades · integer<int32> | null