lending.supply

The lending.supply table contains all supply-side transactions across DeFi lending protocols — deposits, withdrawals, and supply-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 (deposit, withdraw, liquidation)
`symbol`	`VARCHAR`	Token symbol
`token_address`	`VARBINARY`	Token contract address
`depositor`	`VARBINARY`	Depositor wallet address
`on_behalf_of`	`VARBINARY`	Wallet address the tx was executed on behalf of
`withdrawn_to`	`VARBINARY`	Withdrawal recipient 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.supply
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