GET -holders - giga - excluded - balance

Returns token holders on BNB Chain, where holder address is not 0xe036…2D53, 0x50c5…9853 or 34 more, balance amount is below 1000 and balance amount is at least 1: unique of holder address and sum of balance amount.

By Serhii Siedovolosyi · saved 19 October 2024 · run 1 time · Bitquery API v2

What it returns

Filters

The query

query GetTokenHolders($date: String!, $excludedAddresses: [String!]!, $contractAddress: String!) {
  EVM(dataset: archive, network: bsc) {
    Plankton: TokenHolders(
      date: $date
      tokenSmartContract: $contractAddress
      where: {Balance: {Amount: {lt: "1000", ge: "1"}}, Holder: {Address: {notIn: $excludedAddresses}}}
    ) {
      uniq(of: Holder_Address)
      sum(of: Balance_Amount)
    }
    Anchovy: TokenHolders(
      date: $date
      tokenSmartContract: $contractAddress
      where: {Balance: {Amount: {lt: "10000", ge: "1000"}}, Holder: {Address: {notIn: $excludedAddresses}}}
    ) {
      uniq(of: Holder_Address)
      sum(of: Balance_Amount)
    }
    Shrimp: TokenHolders(
      date: $date
      tokenSmartContract: $contractAddress
      where: {Balance: {Amount: {lt: "100000", ge: "10000"}}, Holder: {Address: {notIn: $excludedAddresses}}}
    ) {
      uniq(of: Holder_Address)
      sum(of: Balance_Amount)
    }
    Jellyfish: TokenHolders(
      date: $date
      tokenSmartContract: $contractAddress
      where: {Balance: {Amount: {lt: "500000", ge: "100000"}}, Holder: {Address: {notIn: $excludedAddresses}}}
    ) {
      uniq(of: Holder_Address)
      sum(of: Balance_Amount)
    }
    Octopus: TokenHolders(
      date: $date
      tokenSmartContract: $contractAddress
      where: {Balance: {Amount: {lt: "1000000", ge: "500000"}}, Holder: {Address: {notIn: $excludedAddresses}}}
    ) {
      uniq(of: Holder_Address)
      sum(of: Balance_Amount)
    }
    Dolphin: TokenHolders(
      date: $date
      tokenSmartContract: $contractAddress
      where: {Balance: {Amount: {lt: "5000000", ge: "1000000"}}, Holder: {Address: {notIn: $excludedAddresses}}}
    ) {
      uniq(of: Holder_Address)
      sum(of: Balance_Amount)
    }
    Shark: TokenHolders(
      date: $date
      tokenSmartContract: $contractAddress
      where: {Balance: {Amount: {lt: "10000000", ge: "5000000"}}, Holder: {Address: {notIn: $excludedAddresses}}}
    ) {
      uniq(of: Holder_Address)
      sum(of: Balance_Amount)
    }
    Whale: TokenHolders(
      date: $date
      tokenSmartContract: $contractAddress
      where: {Balance: {Amount: {lt: "100000000", ge: "10000000"}}, Holder: {Address: {notIn: $excludedAddresses}}}
    ) {
      uniq(of: Holder_Address)
      sum(of: Balance_Amount)
    }
    GigaWhale: TokenHolders(
      date: $date
      tokenSmartContract: $contractAddress
      where: {Balance: {Amount: {lt: "1000000000", ge: "100000000"}}, Holder: {Address: {notIn: $excludedAddresses}}}
    ) {
      uniq(of: Holder_Address)
      sum(of: Balance_Amount)
    }
  }
}

Variables

{
  "contractAddress": "0xf700d4c708c2be1463e355f337603183d20e0808",
  "date": "2024-10-18",
  "excludedAddresses": [
    "0xe03629571A6cC91c5c69758F310d9341a2932D53",
    "0x50c50569c9706A9a3034AFefa954CECa78859853",
    "0xf89d7b9c864f589bbF53a82105107622B35EaA40",
    "0x4982085C9e2F89F2eCb8131Eca71aFAD896e89CB",
    "0xf8209291B074dc74d39C906386f0037718A15072",
    "0xE409679a90AbA847922682798757c8be8dC54C15",
    "0x0639556F03714A74a5fEEaF5736a4A64fF70D206",
    "0x0D0707963952f2fBA59dD06f2b425ace40b492Fe",
    "0xafdfd157d9361e621e476036FEE62f688450692B",
    "0x7563758243A262E96880F178aeE7817DcF47Ab0f",
    "0x2982bB64bcd07Ac3315C32Cb2BB7e5E8a2De7d67",
    "0x1569236893dcE06AF7b10B8d072844cc15Ae2011",
    "0xB6F6D86a8f9879A9c87f643768d9efc38c1Da6E7",
    "0xdd3CB5c974601BC3974d908Ea4A86020f9999E0c",
    "0x01532E5265FF2B90925c31f93BBaa0A68224787b",
    "0x2e8F79aD740de90dC5F5A9F0D8D9661a60725e64",
    "0x4775381110Ccb393401819e9F679f15cc6293248",
    "0x6723fe532b397aC49D97921aca68698F85D6C386",
    "0x4e4BE94266681284c2Bb51e89a8074539D19E8d3",
    "0x72121d60b0e2F01c0FB7FE32cA24021b42165A40",
    "0x98F66C1b103E46f855f1Ad17C5C52286D5Fb7CDF",
    "0x1923Ed1A5861D51bD4Ff4627542AC1ec73bbCcBc",
    "0x0D0707963952f2fBA59dD06f2b425ace40b492Fe",
    "0x4982085C9e2F89F2eCb8131Eca71aFAD896e89CB",
    "0x3098A472853e2195400fF56C3F2433587eFEC64A",
    "0x18709E89BD403F470088aBDAcEbE86CC60dda12e",
    "0x2e8F79aD740de90dC5F5A9F0D8D9661a60725e64",
    "0xcC3A3Bc1d76Df321f94716E88224638C439267aa",
    "0xafdfd157d9361e621e476036FEE62f688450692B",
    "0x0639556F03714A74a5fEEaF5736a4A64fF70D206",
    "0xdd3CB5c974601BC3974d908Ea4A86020f9999E0c",
    "0xC7F9687B72Fc21251DA5e8f0192de21057F371d7",
    "0xB4c88543Bd95617Fb61F3d031B8E8E19aF33201E",
    "0xB88D09175676913d69924ACac17Ec69037f1551E",
    "0xdF5C4C1b98a4d045573aB2005D77E87dAA58c853",
    "0x039Ac6fBCEbF02B54259bC690e13540693D9eb8D"
  ]
}

Similar queries