kekec holders

Returns one token holder on Ethereum, where holder address is not 0x and balance amount is above 0: last date, count, sum of balance amount, gini of balance amount, nakamoto of balance amount, currency name, currency symbol and chain ID.

By Coins · saved 23 May 2024 · run 7 times · Bitquery API v2

What it returns

Filters

The query

query ($network: evm_network, $from: String!, $date_middle: String!, $till: String!, $token: String!) {
  EVM(network: $network, dataset: archive) {
    date1: TokenHolders(
      tokenSmartContract: $token
      date: $from
      where: {Balance: {Amount: {gt: "0"}}, Holder: {Address: {not: "0x"}}}
    ) {
      BalanceUpdate {
        LastDate(maximum: BalanceUpdate_LastDate)
      }
      count
      supply: sum(of: Balance_Amount)
      gini(of: Balance_Amount)
      nakamoto(of: Balance_Amount)
      Currency {
        Name: Name(maximum: BalanceUpdate_LastDate)
        Symbol: Symbol(maximum: BalanceUpdate_LastDate)
      }
    }
    date2: TokenHolders(
      tokenSmartContract: $token
      date: $date_middle
      where: {Balance: {Amount: {gt: "0"}}, Holder: {Address: {not: "0x"}}}
    ) {
      BalanceUpdate {
        LastDate(maximum: BalanceUpdate_LastDate)
      }
      count
      supply: sum(of: Balance_Amount)
      gini(of: Balance_Amount)
      nakamoto(of: Balance_Amount)
      Currency {
        Name: Name(maximum: BalanceUpdate_LastDate)
        Symbol: Symbol(maximum: BalanceUpdate_LastDate)
      }
    }
    date3: TokenHolders(
      tokenSmartContract: $token
      date: $till
      where: {Balance: {Amount: {gt: "0"}}, Holder: {Address: {not: "0x"}}}
    ) {
      BalanceUpdate {
        LastDate(maximum: BalanceUpdate_LastDate)
      }
      count
      supply: sum(of: Balance_Amount)
      gini(of: Balance_Amount)
      nakamoto(of: Balance_Amount)
      Currency {
        Name: Name(maximum: BalanceUpdate_LastDate)
        Symbol: Symbol(maximum: BalanceUpdate_LastDate)
      }
    }
    Blocks(limit: {count: 1}) {
      ChainId
    }
  }
}

Variables

{
  "network": "eth",
  "from": "2023-10-27",
  "date_middle": "2024-02-08",
  "till": "2024-05-23",
  "token": "0x8C7AC134ED985367EADC6F727d79E8295E11435c",
  "till_now": "2024-05-23",
  "dateFormat": "%Y-%m"
}

Similar queries