| description |
|---|
Ethereum Aave V2 tables available to query via SQL |
| Name | Description |
|---|---|
eth.aave_v2.loan_updates |
All updates to aave v2 loans |
eth.aave_v2.collateral_updates |
All updates to aave v2 collateral |
eth.aave_v2.loans |
Latest view of all aave v2 loans |
eth.aave_v2.collateral |
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 |