lending.supply

DeFi lending supply events — deposits and withdrawals across Aave, Compound, and other lending protocols.

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'