v1 checklist

[GopherJ]

• [x] scan Staked event. Insert

  Stakes Table
  {
  _id,
  account
  amount
  timestamp
  height
  blockHash
  }

• [x] Scan every Block. Update staking ledgers to latest. Update in every block Maybe should be in liquid-staking-service

  SakingLedgers Table.
  {
  id: DerivativeIndex,
  total
  active
  unlocking
  validators => fetch identity & stakes & commisionRate from relaychain. Include our portion like a percentage
  timestamp
  height
  blockHash
  }

• [x] Scan every block. Key stats. Insert in every block

SystemKeyStats Table
{
  exchangeRate
  reserveFactor
  marketCap
  totalReserves
  timestamp
  height
  blockHash
  totalLocked => may need relaychain & parachain connection
  totalStakers => uniq(Stakes.map(s => s.who))
}

[GopherJ]

Architecture

SubQL offers a GraphQL index service, then liquid-staking-service can send graphql request for offering http services