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

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 }}