lending.borrow

DeFi borrowing events — borrows and repayments across major lending protocols with rates and collateral context.

The lending.borrow table contains all borrow-side transactions across DeFi lending protocols — borrows, repayments, and borrow-side liquidations — across 15+ EVM chains.

Table Schema

Column	Type	Description
blockchain	VARCHAR	Blockchain name
project	VARCHAR	Lending protocol name
version	VARCHAR	Protocol contract version
transaction_type	VARCHAR	Transaction type (borrow, repay, liquidation)
loan_type	VARCHAR	Type of loan
symbol	VARCHAR	Token symbol
token_address	VARBINARY	Token contract address
borrower	VARBINARY	Borrower wallet address
on_behalf_of	VARBINARY	Wallet address the tx was executed on behalf of
repayer	VARBINARY	Repayer wallet address
liquidator	VARBINARY	Liquidator wallet address
amount	DOUBLE	Token amount in display units
amount_raw	UINT256	Raw token amount
amount_usd	DOUBLE	Token amount in USD
block_month	TIMESTAMP	Block month (partition key)
block_time	TIMESTAMP	Block timestamp in UTC
block_number	BIGINT	Block number
project_contract_address	VARBINARY	Protocol contract address
tx_hash	VARBINARY	Transaction hash
evt_index	INTEGER	Event index

Table sample

Query performance

Partition keys: blockchain, project, block_month. Always include blockchain and a time filter.

-- ✅ Good: filters on partition keys
SELECT * FROM lending.borrow
WHERE blockchain = 'ethereum'
  AND block_month >= DATE '2025-01-01'