short_interest

Short interest per (ticker, trade_date) from B3’s securities-lending book: balance, % of float (read float_basis — index_free_float and shares_outstanding are different denominators), days to cover vs 21-session ADTV, and lending rates in percentage points a.a. History starts when SILO began capturing: B3 retains only ~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 /short_interest

short_interest

cURL

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

200

[
  {
    "trade_date": "2023-12-25",
    "ticker": "<string>",
    "asset_name": "<string>",
    "isin": "<string>",
    "sector": "<string>",
    "sector_top": "<string>",
    "instrument_category": "<string>",
    "short_quantity": 123,
    "short_value": 123,
    "pct_float": 123,
    "float_basis": "<string>",
    "float_denominator": 123,
    "days_to_cover": 123,
    "adtv_value_21": 123,
    "adtv_sessions": 123,
    "lender_rate_pct": 123,
    "borrower_rate_pct": 123,
    "contracts": 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>).

asset_name · string

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

isin · string

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

sector · string

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

sector_top · string

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

instrument_category · string

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

short_quantity · string

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

short_value · string

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

pct_float · string

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

float_basis · string

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

float_denominator · string

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

days_to_cover · string

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

adtv_value_21 · string

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

adtv_sessions · string

PostgREST filter on adtv_sessions — eq., neq., gt., gte., lt., lte., in., is. (e.g. adtv_sessions=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>).

contracts · string

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

Response

200

application/json

Matching rows.

trade_date · string<date> | null

ticker · string | null

asset_name · string | null

isin · string | null

sector · string | null

sector_top · string | null

instrument_category · string | null

short_quantity · number | null

short_value · number | null

pct_float · number | null

float_basis · string | null

float_denominator · number | null

days_to_cover · number | null

adtv_value_21 · number | null

adtv_sessions · integer<int64> | null

lender_rate_pct · number | null

borrower_rate_pct · number | null

contracts · integer<int64> | null