> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# lending.supply

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

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

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

<TableSample tableSchema="lending" tableName="supply" />

## Query performance

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

```sql theme={null}
-- ✅ Good: filters on partition keys
SELECT * FROM lending.supply
WHERE blockchain = 'ethereum'
  AND block_month >= DATE '2025-01-01'
```


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.