Hot Table resolver

[vikiival]

query hotNfts(
  $orderBy: [EventOrderByInput!] = timestamp_DESC
  $gte: DateTime!
) {
  result: events(
    where: { interaction_eq: BUY, timestamp_gte: $gte }
    orderBy: $orderBy
  ) {
    timestamp
    interaction
    nft {
      collection {
        name
        id
      }
    }
    meta
  }
}

data we calculate

  const collectionMap = groupBy(data, 'nft.collection.id')
   const sortOrder = [...new Set(data.map((e) => e.nft.collection.id))]
   const result = sortOrder.map((colId, idx) => {
     const collection = collectionMap[colId][0].nft.collection
     const nfts = sortBy(collectionMap[colId], 'timestamp').reverse()
     const totalVolume = toKSM(getVolume(nfts))
     const buys = nfts.length
     const latestSale = nfts[0]
     const medianIdx = Math.floor(buys / 2)
     return {
       id: idx + 1,
       collectionId: colId,
       name: collection.name,
       totalVolume,
       buys,
       latestSoldSize: toKSM(latestSale.meta),
       latestSoldTime: formatDistanceToNow(new Date(latestSale.timestamp)),
       medianDate: formatDistanceToNow(new Date(nfts[medianIdx].timestamp)),
       nfts,
     }