lending.borrow

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'

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index

Table Schema

Table sample

Query performance

​Table Schema

​Table sample

​Query performance

Table Schema

Table sample

Query performance