Overview

In this Notion document, we'll walk through the steps involved in querying, fetching, and displaying information about subgraphs that have significant activity—those with over 1 million queries in a day. This process involves querying The Graph's network subgraphs, retrieving subgraph names, and building a curation dashboard to display the results.

The steps below explain the entire process, including the necessary GraphQL queries and code implementation in page.tsx.

Step 1: Query the QoS Subgraph

The first step is to find subgraphs that have a high level of activity—specifically, those with over 1 million queries in the past day. These queries go into the queries.js file.

• Subgraph: QoS Subgraph on Arbitrum
• Query: Use the following GraphQL query to fetch subgraph deployments that have over 1 million queries in the past 24 hours:

<aside> 💡

Data is updated daily starting 8 PM EST. If no results, check back later.

</aside>

graphql
Copy code
const now = BigInt(Math.floor(Date.now() / 1000))
const past24 = now - BigInt(86400)

export const QUERY_SUBGRAPHS = `
  query($past24: BigInt!) {
    queryDailyDataPoints(
      where: {
        dayStart_gte: $past24,
        query_count_gte: 1000000
      },
      orderBy: total_query_fees,
      orderDirection: desc
    ) {
      total_query_fees
      query_count
      subgraphDeployment {
        id
      }
    }
  }
`

• Results: This query will return the subgraph deployments with the highest number of queries. The response will include:
  • The id of the subgraph deployment (which is an IPFS hash).
  • The query_count and total_query_fees.

Example JSON Response:

json
Copy code
{
  "data": {
    "queryDailyDataPoints": [
      {
        "query_count": "96811667",
        "subgraphDeployment": {
          "id": "Qmc9sKbQk6wKMTDA9Wkw2E8w4C199gaYk6xmZei5ZeGKjH"
        },
        "total_query_fees": "8982.3888311147"
      },
      {
        "query_count": "97793235",
        "subgraphDeployment": {
          "id": "Qmc9sKbQk6wKMTDA9Wkw2E8w4C199gaYk6xmZei5ZeGKjH"
        },
        "total_query_fees": "8890.9755680753"
      }
    ]
  }
}

Note: The subgraph IDs returned are IPFS hashes, which we will use in the next step to retrieve the corresponding subgraph names.

Alternative possible query

{
  QOS__queryDailyDataPoints: queryDailyDataPoints(
    where: {
      dayStart_gt: "1731974400"  # Replace with a dynamic value for the timestamp 24 hours ago
      subgraphDeployment: "QmUzRg2HHMpbgf6Q4VHKNDbtBEJnyp5JWCh2gUX9AV6jXv"
    },
    first: 100,
    subgraphError: allow
  ) {
    id
    query_count
    dayStart
    subgraphDeployment {
      id
      __typename
    }
    __typename
  }
}