Comment on page
Aave V2 Tables
Ethereum Aave V2 tables available to query via SQL
Name | Description |
|---|---|
All updates to aave v2 loans | |
All updates to aave v2 collateral | |
Latest view of all aave v2 loans | |
Latest view of all aave v2 collateral |
The columns and their schema available for each table can be viewed with the
describe <table> command. For example:DESCRIBE eth.aave_v2.loan_updates
DESCRIBE eth.aave_v2.collateral_updates
DESCRIBE eth.aave_v2.loans
DESCRIBE eth.aave_v2.collateral
Improving query performance - indexed columns
Query performance can be significantly improved by adding
WHERE clauses to your query on specific indexed columns.Table Name | Indexed Columns |
|---|---|
eth.aave_v2.loan_updates | block_number |
eth.aave_v2.collateral_updates | block_number |
Last modified 4mo ago