Links
Comment on page

Aave V2 Tables

Ethereum Aave V2 tables available to query via SQL

Tables available to query

Name
Description
All updates to aave v2 loans
All updates to aave v2 collateral
​eth.aave_v2.loans​
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