lending_participants

Per (ticker, session, brokerage) securities-lending flow: quantity lent, borrowed and net, with rates. broker_* identifies the B3 PARTICIPANT intermediating, not the beneficial owner; internal_legs / internal_qty measure how much is that broker crossing its own clients. Do not read a large borrow as the broker being short.

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

lending_participants

cURL

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

200

[
  {
    "trade_date": "2023-12-25",
    "ticker": "<string>",
    "broker_code": "<string>",
    "broker_name": "<string>",
    "quantity_lent": 123,
    "quantity_borrowed": 123,
    "quantity_net": 123,
    "lender_rate_pct": 123,
    "borrower_rate_pct": 123,
    "internal_legs": 123,
    "internal_qty": 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>).

broker_code · string

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

broker_name · string

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

quantity_lent · string

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

quantity_borrowed · string

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

quantity_net · string

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

lender_rate_pct · string

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

borrower_rate_pct · string

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

internal_legs · string

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

internal_qty · string

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

Response

200

application/json

Matching rows.

trade_date · string<date> | null

ticker · string | null

broker_code · string | null

broker_name · string | null

quantity_lent · number | null

quantity_borrowed · number | null

quantity_net · number | null

lender_rate_pct · number | null

borrower_rate_pct · number | null

internal_legs · integer<int64> | null

internal_qty · number | null