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

Question

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

Answer

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](https://docs.aave.com/developers/v/2.0/guides/apy-and-apr), 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 }}

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

Answers 1