lending_trades

Daily securities-lending activity per ticker, computed from B3’s individual trades: count, quantity, quantity-weighted and min/max annualized rate (percentage points), and how many distinct brokers stood on each leg. History starts at first capture — B3 retains ~21 business days.

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_trades

lending_trades

cURL

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

200

[
  {
    "trade_date": "2023-12-25",
    "ticker": "<string>",
    "trades": 123,
    "quantity": 123,
    "rate_pct": 123,
    "rate_min_pct": 123,
    "rate_max_pct": 123,
    "borrower_brokers": 123,
    "lender_brokers": 123,
    "internal_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>).

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>).

rate_pct · string

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

rate_min_pct · string

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

rate_max_pct · string

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

borrower_brokers · string

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

lender_brokers · string

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

internal_trades · string

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

Response

200

application/json

Matching rows.

trade_date · string<date> | null

ticker · string | null

trades · integer<int64> | null

quantity · number | null

rate_pct · number | null

rate_min_pct · number | null

rate_max_pct · number | null

borrower_brokers · integer<int64> | null

lender_brokers · integer<int64> | null

internal_trades · integer<int64> | null