future_series

One DI1 futures contract through time, oldest session first, with the same columns as api.future_curve (B3 Price Report, b3_futures_settlement, from 2018-01-02): settlement rate and PU, open interest, volume and the session’s quotes, which for DI1 are RATES (% a.a., 252 business days). p_ticker is an outright code such as DI1F27 — root, B3 month letter (F = January … Z = December), two-digit year — and anything else raises 22023; future_curve lists the contracts of a session. A contract is listed years before it matures and stops at maturity, so a window outside its life returns no rows. Nothing is rolled, spliced or made continuous: a constant-maturity rate is B3’s own curve (api.curve, api.curve_history). Default window the 12 months before p_to or today. More than 1000 rows RAISES 22023 (never trimmed): narrow p_from/p_to.

Row cap. A window producing more than 1000 rows raises SQLSTATE 22023 naming this function. Nothing is trimmed to fit — PostgREST would silently cut the response at 1000 and a cut-short series is indistinguishable from one that simply ends. This function does not page — narrow the window instead.

POST /rpc/future_series

future_series

cURL

curl --request POST \
  --url https://zcjbtpxuhdekpwcxmepn.supabase.co/rest/v1/rpc/future_series \
  --header 'Content-Type: application/json' \
  --header 'apikey: <api-key>' \
  --data '
{
  "p_ticker": "<string>",
  "p_from": null,
  "p_to": null
}
'

200

[
  {
    "trade_date": "2023-12-25",
    "ticker": "<string>",
    "contract_month": "2023-12-25",
    "settlement_rate": 123,
    "settlement_price": 123,
    "prev_settlement_rate": 123,
    "open_interest": 123,
    "contracts": 123,
    "trades": 123,
    "notional_brl": 123,
    "open_px": 123,
    "low_px": 123,
    "high_px": 123,
    "avg_px": 123,
    "close_px": 123,
    "settlement_status": "<string>",
    "source": "<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.

Body

application/json

p_ticker · string | null · required

p_from · string<date> | null

Defaults to NULL::date.

p_to · string<date> | null

Defaults to NULL::date.

Response

200

application/json

The result set, oldest first. An unknown id is an empty array, not a 404 and never a guessed value.

trade_date · string<date> | null

ticker · string | null

contract_month · string<date> | null

settlement_rate · number | null

settlement_price · number | null

prev_settlement_rate · number | null

open_interest · integer<int64> | null

contracts · integer<int64> | null

trades · integer<int32> | null

notional_brl · number | null

open_px · number | null

low_px · number | null

high_px · number | null

avg_px · number | null

close_px · number | null

settlement_status · string | null

source · string | null