spitko / pwn-subgraph Goto Github PK

query Loans {
  loans(orderBy: createdDate, orderDirection: desc) {
    id
    borrower {
      id
    }
    lender {
      id
    }
    expiration
    status
    collateral {
      id
      category
      token {
        name
        symbol
        decimals
      }
    }
    collateralAmount
    collateralTokenId
    borrowAsset {
      id
      category
      token {
        name
        symbol
        decimals
      }
    }
    loanPaidBackEvents {
      transactionHash
    }
    borrowAmount
    repayAmount
    createdDate
    repaidDate
  }
}

{
  accounts(orderBy:totalBorrowedLoans, orderDirection:desc) {
    id
    totalLendedLoans
    totalBorrowedLoans
  }
}

{
  accounts(block: {number:19999284} where:{borrowed_: {status: RUNNING}}) {
    id
    borrowed {
      id
      expiration
      status
      collateral {
        id
      }
      collateralAmount
      collateralTokenId
      borrowAsset {
        id
      }
    }
    totalBorrowedLoans
  }
}