DeFi balance sheets (experimental)

Returns Defi Balance Sheet records for specified DeFi protocols. The data is being updated on an end-of-day frequency. Results are ordered by tuple (defi_protocol, block_height). To fetch the next page of results use the next_page_url JSON response field.

get

Authorizations

api_key

api_keystringRequired

Coin Metrics API key can be specified as ?api_key= query parameter.

Query parameters

defi_protocolsstring[]Required

Comma separated list of DeFi protocols like aave_v2_eth or protocol patterns like aave_v2_* or aave_*_eth or *_eth.

start_timestringOptional

Start of the time interval.
This field refers to the time field in the response.
Multiple formats of ISO 8601 are supported: 2006-01-20T00:00:00Z, 2006-01-20T00:00:00.000Z, 2006-01-20T00:00:00.123456Z, 2006-01-20T00:00:00.123456789Z, 2006-01-20, 20060120.
Inclusive by default. Mutually exclusive with start_height.
UTC timezone by default. Z suffix is optional and timezone parameter has a priority over it.
If start_time is omitted, response will include time series from the earliest time available.

end_timestringOptional

End of the time interval.
This field refers to the time field in the response.
Multiple formats of ISO 8601 are supported: 2006-01-20T00:00:00Z, 2006-01-20T00:00:00.000Z, 2006-01-20T00:00:00.123456Z, 2006-01-20T00:00:00.123456789Z, 2006-01-20, 20060120.
Inclusive by default. Mutually exclusive with end_height.
UTC timezone by default. Z suffix is optional and timezone parameter has a priority over it.
If end_time is omitted, response will include time series up to the latest time available.

start_heightinteger · int64Optional

The start height indicates the beginning block height for the set of data that are returned.
Inclusive by default. Mutually exclusive with start_time.

end_heightinteger · int64Optional

The end height indicates the ending block height for the set of data that are returned.
Inclusive by default. Mutually exclusive with end_time.

start_inclusivebooleanOptional

Inclusive or exclusive corresponding start_* parameters.

Default: true

end_inclusivebooleanOptional

Inclusive or exclusive corresponding end_* parameters.

Default: true

timezonestringOptional

Timezone name for start_time and end_time timestamps.
This parameter does not modify the output times, which are always UTC.
Format is defined by TZ database.

Default: UTCExample: America/New_York

page_sizeinteger · int32 · min: 1 · max: 10000Optional

Number of items per single page of results.
The value of this parameter is ignored if the endpoint supports the format parameter and its value is set to json_stream.

Default: 100

paging_fromstring · enumOptional

Where does the first page start, at the start of the interval or at the end.
The value of this parameter is ignored if the endpoint supports the format parameter and its value is set to json_stream.

Default: endPossible values:

prettybooleanOptional

Human-readable formatting of JSON responses.

Default: false

formatstring · enumOptional

Format of the response.

Default: jsonPossible values:

next_page_tokenstringOptional

Token for receiving the results from the next page of a query.
Should not be used directly. To iterate through pages just use next_page_url response field.

Responses

200

DeFi balance sheets.

application/json

DeFi balance sheets response.

next_page_tokenstringOptional

Token of the next page results for a given request.

next_page_urlstringOptional

URL of the next page results for a given request.

400

DeFi protocol not found.

application/json

401

Requested resource requires authorization.

application/json

403

Requested resource is not available with supplied credentials.

application/json

414

Provided URI is too long. It must not be greater than 10000 symbols.

get/timeseries/defi-balance-sheets

ShellPythonPython Client

curl --compressed "https://api.coinmetrics.io/v4/timeseries/defi-balance-sheets?defi_protocols=aave_v2_eth&api_key=<your_key>"

{
  "data": [
    {
      "defi_protocol": "aave_v2_eth",
      "block_height": 15656731,
      "time": "2022-10-02T00:00:00.000000000Z",
      "assets_total_usd": 5457689622.84,
      "assets_total_count": 34,
      "assets": [
        {
          "asset": "1inch",
          "balance_units": 16674724.15,
          "balance_usd": 9580408.36,
          "share": 0.001755
        },
        {
          "asset": "aave",
          "balance_units": 1743338.27,
          "balance_usd": 129832512.22,
          "share": 0.023789
        }
      ],
      "liabilities_total_usd": 5458419619.21,
      "liabilities_total_count": 34,
      "liabilities": [
        {
          "asset": "1inch",
          "balance_units": 16674705.4,
          "balance_usd": 9580397.58,
          "share": 0.001755
        },
        {
          "asset": "aave",
          "balance_units": 1743338.27,
          "balance_usd": 129832512.22,
          "share": 0.023786
        }
      ],
      "loans_lent_total_usd": 1531826827.01,
      "tvl_total_usd": 3925862795.83,
      "net_working_capital": -1532556823.38,
      "protocol_utilization_ratio": 0.28,
      "liquid_supply_ratio": 0.72,
      "current_ratio": 0.72,
      "debt_to_assets_ratio": 1
    }
  ],
  "next_page_token": "0.MTUwMjYyMzI",
  "next_page_url": "https://api.coinmetrics.io/v4/timeseries/defi-balance-sheets?api_key=<your_key>&defi_protocols=aave_v2_eth&next_page_token=0.MTUwMjYyMzI"
}