# Querying All Seasons

You can build your own queries using a [GraphQL Explorer](https://graphiql-online.com/graphiql) and enter your endpoint to limit the data to exactly what you need.

Each entity has a plural version and a singular version. When querying for a single record response (e.g. account), you will need to supply the id for the entity. When querying for a list of responses (e.g. accounts), you may add filters using the 'where' clause.

## Sample Queries

Below are some sample queries you can use to gather information from the HOPR contracts.

### GET STAKING AND BOOST INFO

Retrieve information about staking participations and boosts, including their IDs, associated accounts or owners, staking seasons, actual locked token amounts, boost type indexes, and URIs.

{
  stakingParticipations(first: 5) {
    id
    account {
      id
    }
    stakingSeason {
      id
    }
    actualLockedTokenAmount
  }
  boosts(first: 5) {
    id
    owner {
      id
    }
    boostTypeIndex
    uri
  }
}

### Returns

<div style="height: 300px; overflow: auto;">

{
  "data": {
    "stakingParticipations": [
      {
        "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e0x0057bd83a142da84b6404616c683e21e7dd6fa5f",
        "account": {
          "id": "0x0057bd83a142da84b6404616c683e21e7dd6fa5f"
        },
        "stakingSeason": {
          "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e"
        },
        "actualLockedTokenAmount": "0"
      },
      {
        "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e0x00622116402f303f22d38f3ec202774f183f6468",
        "account": {
          "id": "0x00622116402f303f22d38f3ec202774f183f6468"
        },
        "stakingSeason": {
          "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e"
        },
        "actualLockedTokenAmount": "0"
      },
      {
        "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e0x00a0e299241c264209b52ece9649ed577f077853",
        "account": {
          "id": "0x00a0e299241c264209b52ece9649ed577f077853"
        },
        "stakingSeason": {
          "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e"
        },
        "actualLockedTokenAmount": "0"
      },
      {
        "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e0x02baffe241637db991f5d46818a3eb73f39683df",
        "account": {
          "id": "0x02baffe241637db991f5d46818a3eb73f39683df"
        },
        "stakingSeason": {
          "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e"
        },
        "actualLockedTokenAmount": "3425676800000000000000"
      },
      {
        "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e0x034e1f7a66b582b68e511b325ed0ccb71bb4bc12",
        "account": {
          "id": "0x034e1f7a66b582b68e511b325ed0ccb71bb4bc12"
        },
        "stakingSeason": {
          "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e"
        },
        "actualLockedTokenAmount": "0"
      }
    ],
    "boosts": [
      {
        "id": "0",
        "owner": {
          "id": "0x43d13d7b83607f14335cf2cb75e87da369d056c7"
        },
        "boostTypeIndex": "1",
        "uri": "https://stake.hoprnet.org/demo/gold"
      },
      {
        "id": "1",
        "owner": {
          "id": "0x912f4d6607160256787a2ad40da098ac2afe57ac"
        },
        "boostTypeIndex": "2",
        "uri": "https://stake.hoprnet.org/HODLr/gold"
      },
      {
        "id": "10",
        "owner": {
          "id": "0x5b584922b2df2467a54c19084f83ebaccab21f64"
        },
        "boostTypeIndex": "2",
        "uri": "https://stake.hoprnet.org/HODLr/diamond"
      },
      {
        "id": "100",
        "owner": {
          "id": "0x1bd5de5e78977b200822a30a4d16714d3a1dbd35"
        },
        "boostTypeIndex": "2",
        "uri": "https://stake.hoprnet.org/HODLr/diamond"
      },
      {
        "id": "1000",
        "owner": {
          "id": "0x21368a0e3410a6253662d7b4562f4b0cdc0d276a"
        },
        "boostTypeIndex": "2",
        "uri": "https://stake.hoprnet.org/HODLr/diamond"
      }
    ]
  }
}

</div>

### STAKING PARTICIPANTS

Where the cumulatedRewards field is greater than 1 ETH (which is represented in wei). It returns the id and cumulatedRewards fields for each staking participation, as well as the associated staking season information, including the id, seasonNumber, and various totals related to the staking season.

{
  stakingParticipations(
    first: 10
    where: { cumulatedRewards_gt: 1000000000000000000 }
  ) {
    id
    cumulatedRewards
    stakingSeason {
      id
      seasonNumber
      totalLocked
      totalVirtual
      totalAirdrop
      totalCumulatedRewards
      totalClaimedRewards
      totalUnclaimedRewards
    }
  }
}

### Return

<div style="height: 300px; overflow: auto;">

{
  "data": {
    "stakingParticipations": [
      {
        "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e0x0057bd83a142da84b6404616c683e21e7dd6fa5f",
        "cumulatedRewards": "3158406031263105402000",
        "stakingSeason": {
          "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e",
          "seasonNumber": "2",
          "totalLocked": "384327755700000000000000",
          "totalVirtual": "0",
          "totalAirdrop": "0",
          "totalCumulatedRewards": "2323030315587122824983653",
          "totalClaimedRewards": "2320574564123151223305153",
          "totalUnclaimedRewards": "2455751463971601678500"
        }
      },
      {
        "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e0x00622116402f303f22d38f3ec202774f183f6468",
        "cumulatedRewards": "983878158045000928000",
        "stakingSeason": {
          "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e",
          "seasonNumber": "2",
          "totalLocked": "384327755700000000000000",
          "totalVirtual": "0",
          "totalAirdrop": "0",
          "totalCumulatedRewards": "2323030315587122824983653",
          "totalClaimedRewards": "2320574564123151223305153",
          "totalUnclaimedRewards": "2455751463971601678500"
        }
      },
      {
        "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e0x00a0e299241c264209b52ece9649ed577f077853",
        "cumulatedRewards": "268624744882065000000",
        "stakingSeason": {
          "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e",
          "seasonNumber": "2",
          "totalLocked": "384327755700000000000000",
          "totalVirtual": "0",
          "totalAirdrop": "0",
          "totalCumulatedRewards": "2323030315587122824983653",
          "totalClaimedRewards": "2320574564123151223305153",
          "totalUnclaimedRewards": "2455751463971601678500"
        }
      },
      {
        "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e0x034e1f7a66b582b68e511b325ed0ccb71bb4bc12",
        "cumulatedRewards": "1402683635427173963500",
        "stakingSeason": {
          "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e",
          "seasonNumber": "2",
          "totalLocked": "384327755700000000000000",
          "totalVirtual": "0",
          "totalAirdrop": "0",
          "totalCumulatedRewards": "2323030315587122824983653",
          "totalClaimedRewards": "2320574564123151223305153",
          "totalUnclaimedRewards": "2455751463971601678500"
        }
      },
      {
        "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e0x03f182ec7474877ec8d830a5fcb804fd132755c1",
        "cumulatedRewards": "8591412596327120000000",
        "stakingSeason": {
          "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e",
          "seasonNumber": "2",
          "totalLocked": "384327755700000000000000",
          "totalVirtual": "0",
          "totalAirdrop": "0",
          "totalCumulatedRewards": "2323030315587122824983653",
          "totalClaimedRewards": "2320574564123151223305153",
          "totalUnclaimedRewards": "2455751463971601678500"
        }
      },
      {
        "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e0x04031ff90daa5ce7fd90be871933b46889653f99",
        "cumulatedRewards": "223998569439360651500",
        "stakingSeason": {
          "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e",
          "seasonNumber": "2",
          "totalLocked": "384327755700000000000000",
          "totalVirtual": "0",
          "totalAirdrop": "0",
          "totalCumulatedRewards": "2323030315587122824983653",
          "totalClaimedRewards": "2320574564123151223305153",
          "totalUnclaimedRewards": "2455751463971601678500"
        }
      },
      {
        "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e0x040d4205b3b23151c5df8076c15ce830332b97fd",
        "cumulatedRewards": "1429175693662367985500",
        "stakingSeason": {
          "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e",
          "seasonNumber": "2",
          "totalLocked": "384327755700000000000000",
          "totalVirtual": "0",
          "totalAirdrop": "0",
          "totalCumulatedRewards": "2323030315587122824983653",
          "totalClaimedRewards": "2320574564123151223305153",
          "totalUnclaimedRewards": "2455751463971601678500"
        }
      },
      {
        "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e0x04136d1730202628ea1edd0b9ed1d423a09d451d",
        "cumulatedRewards": "1180386467557790000000",
        "stakingSeason": {
          "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e",
          "seasonNumber": "2",
          "totalLocked": "384327755700000000000000",
          "totalVirtual": "0",
          "totalAirdrop": "0",
          "totalCumulatedRewards": "2323030315587122824983653",
          "totalClaimedRewards": "2320574564123151223305153",
          "totalUnclaimedRewards": "2455751463971601678500"
        }
      },
      {
        "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e0x045795ff0b8c353290a900654514032e92c289b7",
        "cumulatedRewards": "2115597397101970000000",
        "stakingSeason": {
          "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e",
          "seasonNumber": "2",
          "totalLocked": "384327755700000000000000",
          "totalVirtual": "0",
          "totalAirdrop": "0",
          "totalCumulatedRewards": "2323030315587122824983653",
          "totalClaimedRewards": "2320574564123151223305153",
          "totalUnclaimedRewards": "2455751463971601678500"
        }
      },
      {
        "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e0x045d3d3bf9ef8ae7bae0e1ee2765349636d90057",
        "cumulatedRewards": "1385466046098443621000",
        "stakingSeason": {
          "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e",
          "seasonNumber": "2",
          "totalLocked": "384327755700000000000000",
          "totalVirtual": "0",
          "totalAirdrop": "0",
          "totalCumulatedRewards": "2323030315587122824983653",
          "totalClaimedRewards": "2320574564123151223305153",
          "totalUnclaimedRewards": "2455751463971601678500"
        }
      }
    ]
  }
}

</div>

### TOP STAKESEAON BY TOTAL LOCKED

Retrieves information on the top stake seasons based on the amount of total tokens locked in each season.

{
  stakeSeasons(first: 10, orderBy: totalLocked, orderDirection: desc) {
    id
    seasonNumber
    totalLocked
  }
}

### Returned

<div style="height: 300px; overflow: auto;">

{
  "data": {
    "stakeSeasons": [
      {
        "id": "0xa02af160a280957a8881879ee9239a614ab47f0d",
        "seasonNumber": "6",
        "totalLocked": "67944781585288664050207595"
      },
      {
        "id": "0x912f4d6607160256787a2ad40da098ac2afe57ac",
        "seasonNumber": "1",
        "totalLocked": "4586678909334271006549826"
      },
      {
        "id": "0xae933331ef0be122f9499512d3ed4fa3896dcf20",
        "seasonNumber": "3",
        "totalLocked": "500488214000000000000000"
      },
      {
        "id": "0x5bb7e435ada333a6714e27962e4bb6afde1cecd4",
        "seasonNumber": "4",
        "totalLocked": "448296376000000000000000"
      },
      {
        "id": "0x2cdd13ddb0346e0f620c8e5826da5d7230341c6e",
        "seasonNumber": "2",
        "totalLocked": "368595191000000000000000"
      }
    ]
  }
}

</div>