Skip to main content
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

ColumnTypeDescription
blockchainVARCHARBlockchain name
projectVARCHARLending protocol name
versionVARCHARProtocol contract version
transaction_typeVARCHARTransaction type (borrow, repay, liquidation)
loan_typeVARCHARType of loan
symbolVARCHARToken symbol
token_addressVARBINARYToken contract address
borrowerVARBINARYBorrower wallet address
on_behalf_ofVARBINARYWallet address the tx was executed on behalf of
repayerVARBINARYRepayer wallet address
liquidatorVARBINARYLiquidator wallet address
amountDOUBLEToken amount in display units
amount_rawUINT256Raw token amount
amount_usdDOUBLEToken amount in USD
block_monthTIMESTAMPBlock month (partition key)
block_timeTIMESTAMPBlock timestamp in UTC
block_numberBIGINTBlock number
project_contract_addressVARBINARYProtocol contract address
tx_hashVARBINARYTransaction hash
evt_indexINTEGEREvent 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'