Aave.

Post

Share your knowledge.

Aaveator.
Feb 06, 2023
Expert Q&A

Does anyone know how to get the historical APY from Aave v3 subgraph?

Hey guys! Does anyone know how to get the historical APY from Aave v3 subgraph?
I am querying ReserveParamsHistoryItem: https://api.thegraph.com/subgraphs/name/aave/protocol-v3-polygon/graphql?query=query+MyQuery+%7B%0A++reserveParamsHistoryItems+%7B%0A++++id%0A++%7D%0A%7D

  • Aave Protocol
  • Aave v3
0
1
Share
Comments
.

Answers

1
Aaveator.
Feb 16 2023, 12:46

Here is a query to fetch the most recent updates for USDC:

{
reserveParamsHistoryItems(where:{reserve_: { symbol: "USDC" }}, orderBy: timestamp, orderDirection: desc){
  timestamp
  liquidityRate
  variableBorrowRate
  stableBorrowRate
    }
}

Some notes: liquidityRate = supply rate, all rates will be APR which you can convert using this guide, and if you want to query further in the past you can change the where clause to where:{reserve_: { symbol: "USDC", timestamp_lt: INSERT_TIMESTAMP_IN_THE_PAST }}

0
Comments
.

Do you know the answer?

Please log in and share it.

We use cookies to ensure you get the best experience on our website.
More info