investor_flow

Daily net flow by investor type (R$ thousands), differenced from B3’s month-to-date participation snapshots, T+2. Rows with flow_basis = unknown_opening_snapshot carry NULL flows on purpose — see fact_investor_flow_daily.

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

investor_flow

cURL

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

200

[
  {
    "reference_date": "2023-12-25",
    "investor_type": "<string>",
    "flow_basis": "<string>",
    "buy_value_thousands": 123,
    "sell_value_thousands": 123,
    "net_value_thousands": 123,
    "mtd_buy_value_thousands": 123,
    "mtd_sell_value_thousands": 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.

reference_date · string

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

investor_type · string

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

flow_basis · string

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

buy_value_thousands · string

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

sell_value_thousands · string

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

net_value_thousands · string

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

mtd_buy_value_thousands · string

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

mtd_sell_value_thousands · string

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

Response

200

application/json

Matching rows.

reference_date · string<date> | null

investor_type · string | null

flow_basis · string | null

buy_value_thousands · number | null

sell_value_thousands · number | null

net_value_thousands · number | null

mtd_buy_value_thousands · number | null

mtd_sell_value_thousands · number | null