justinrhill2023@gmail.com

Returns DEX trades and balance updates on Ethereum: array intersect, contingency of block difficulty, average of block difficulty, correlation of block difficulty, count, cramers of block difficulty, covariance of block difficulty and 29 more fields.

By Justin hill · saved 19 October 2024 · Bitquery API v2

What it returns

The query

query MyQuery {
  EVM(mempool: false, dataset: archive, network: eth, select_blocks: tree) {
    DEXTrades {
      array_intersect(side1: Call_Error, side2: Call_Error, intersectWith: "5000000")
      contingency(of: Block_Difficulty, with: Block_Difficulty)
      average(of: Block_Difficulty)
      correlation(of: Block_Difficulty)
      count(distinct: Block_Time)
      cramers(of: Block_Difficulty, with: Block_Difficulty)
      covariance(of: Block_Difficulty)
      cramers_bias_corrected(of: Block_Difficulty, with: Block_Difficulty)
      dispersion(of: Block_Difficulty)
      entropy(of: Block_Difficulty)
      gini(of: Block_Difficulty)
      kurtosis(of: Block_Difficulty)
      median(of: Block_Difficulty)
      nakamoto(of: Block_Difficulty, ratio: 1.5)
      quantile(of: Block_Difficulty, level: 1.5, method: exact)
      rank_correlation(
        of: Block_Difficulty
        if: {Trade: {Sell: {AmountInUSD: {eq: "5000", ge: "50000", gt: "", lt: "", le: "4000000", ne: "4000000"}, Currency: {Fungible: false, Name: {endsWith: "", in: "5000000", includes: ""}, HasURI: false}}, Success: false}}
      )
      skew(of: Block_Difficulty)
      standard_deviation(if: {})
      sum(
        of: Block_Difficulty
        if: {Receipt: {ContractAddress: {endsWith: "500000", startsWith: "5000000"}}, Trade: {Sell: {}}}
      )
    }
    BalanceUpdates {
      Block {
        Date(
          minimum: BalanceUpdate_AmountInUSD
          maximum: BalanceUpdate_AmountInUSD
          selectWhere: {after: "", in: "", before: "", is: "", not: "", notIn: "", since: "", till: ""}
        )
        Hash(
          maximum: BalanceUpdate_AmountInUSD
          minimum: BalanceUpdate_AmountInUSD
          selectWhere: {endsWith: "", in: "", is: "", includes: "", like: "", not: "", notIncludes: "", notLike: "", notIn: "", startsWith: ""}
        )
        Number(
          maximum: BalanceUpdate_AmountInUSD
          minimum: BalanceUpdate_AmountInUSD
          selectWhere: {eq: "", ge: "", gt: "", in: "", le: "", lt: "", notIn: "5000000", ne: ""}
        )
        ParentHash(
          maximum: BalanceUpdate_AmountInUSD
          minimum: BalanceUpdate_AmountInUSD
        )
        Time(maximum: BalanceUpdate_AmountInUSD, minimum: BalanceUpdate_AmountInUSD)
      }
      ChainId(maximum: BalanceUpdate_AmountInUSD, minimum: BalanceUpdate_AmountInUSD)
      Call {
        CallPath(
          maximum: BalanceUpdate_AmountInUSD
          minimum: BalanceUpdate_AmountInUSD
          selectWhere: {endsWith: {eq: "", ge: "Dvfv", gt: 500000000, in: 500000000, le: 500000000, lt: 500000000, ne: 500000000, notIn: 10}}
        )
      }
      array_intersect(
        side1: Uncle_Block_Hash
        side2: Uncle_Block_Hash
        intersectWith: "5000000"
      )
      average(of: BalanceUpdate_Id)
      contingency(of: BalanceUpdate_Id, with: BalanceUpdate_Id)
      correlation(of: BalanceUpdate_Id, with: BalanceUpdate_Id)
      count(distinct: Currency_SmartContract)
      cramers(of: BalanceUpdate_Id, with: BalanceUpdate_Id)
      covariance(of: BalanceUpdate_Id, with: BalanceUpdate_Id)
      cramers_bias_corrected(of: BalanceUpdate_Id, with: BalanceUpdate_Id)
      dispersion(of: BalanceUpdate_Id)
      entropy(of: BalanceUpdate_Id)
      gini(of: BalanceUpdate_Id)
      kurtosis(of: BalanceUpdate_Id)
    }
  }
}

Similar queries