Aave V2 Tables

Ethereum Aave V2 tables available to query via SQL

Tables available to query


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 NameIndexed Columns





Last updated