Copy of Wilbur

Returns 10 balance updates and blocks on Base, where call path ends with is 10, call path ends with is at least 10 and call path ends with is above 10, sorted by block gas used: balance update address, balance update amount, amount in USD, balance update ID, balance update type, URI, block date and 41 more fields.

By Andrew Wilbur · saved 10 December 2024 · Bitquery API v2

What it returns

Filters

The query

query MyQuery($BalanceUpdate: EVM_BalanceUpdate_Input_BalanceUpdate_InputType = {}) {
  EVM(dataset: realtime, mempool: true, network: base, select_blocks: trunk) {
    BalanceUpdates(
      limit: {count: 10, offset: 10}
      limitBy: {by: Transaction_Index, count: 10, offset: 10}
      orderBy: {ascending: Transaction_Index, ascendingByField: "", descending: BalanceUpdate_Amount, descendingByField: ""}
      where: {BalanceUpdate: $BalanceUpdate, Block: {Date: {after: "", before: "", in: "", is: "", not: "", notIn: "", since: "", till: ""}, Hash: {endsWith: "", in: "", includes: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}, L1: {Hash: {endsWith: "", in: "", includes: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}, ParentHash: {endsWith: "", in: "", includes: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}}, Number: {eq: "", ge: "", gt: "", in: "", le: "", lt: "", ne: "", notIn: ""}, ParentHash: {endsWith: "", in: "", is: "", includes: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}, Time: {after: "", before: "", in: "", is: "", not: "", notIn: "", since: "", till: ""}}, Call: {CallPath: {endsWith: {eq: 10, ge: 10, gt: 10, in: 10, le: 10, lt: 10, ne: 10, notIn: 10}, excludes: {eq: 10, ge: 10, gt: 10, le: 10, in: 10, lt: 10, ne: 10, notIn: 10}}}}
    ) {
      BalanceUpdate {
        Address(maximum: Log_Index, minimum: Log_Index)
        Amount(
          maximum: Log_Index
          minimum: Log_Index
          selectWhere: {eq: "", ge: "", le: "", lt: "", gt: "", ne: ""}
        )
        AmountInUSD(maximum: Log_Index, minimum: Log_Index)
        Id(maximum: Log_Index, minimum: Log_Index)
        Type(maximum: Log_Index, minimum: Log_Index)
        URI(maximum: Log_Index, minimum: Log_Index)
      }
      Block {
        Date(maximum: Log_Index, minimum: Log_Index)
        Hash(maximum: Log_Index)
        L1 {
          Hash(maximum: Log_Index, minimum: Log_Index)
          ParentHash(maximum: Log_Index, minimum: Log_Index)
        }
        Number(maximum: Log_Index, minimum: Log_Index)
        ParentHash(maximum: Log_Index, minimum: Log_Index)
        Time(maximum: Log_Index, minimum: Log_Index)
      }
      Call {
        CallPath(maximum: Log_Index, minimum: Log_Index)
        Index(maximum: Log_Index, minimum: Log_Index)
      }
      ChainId(maximum: Log_Index, minimum: Log_Index)
      Currency {
        Decimals(maximum: Log_Index, minimum: Log_Index)
        Delegated(maximum: Log_Index, minimum: Log_Index, selectWhere: true)
        DelegatedTo(
          maximum: Log_Index
          minimum: Log_Index
          selectWhere: {endsWith: "", in: "", includes: "", is: "", not: "", like: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}
        )
        Fungible(maximum: Log_Index, minimum: Log_Index, selectWhere: true)
        HasURI(maximum: Log_Index, minimum: Log_Index, selectWhere: true)
        Name(
          maximum: Log_Index
          minimum: Log_Index
          selectWhere: {endsWith: "", includes: "", in: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}
        )
        Native(maximum: Log_Index, minimum: Log_Index, selectWhere: true)
        ProtocolName(
          maximum: Log_Index
          minimum: Log_Index
          selectWhere: {endsWith: "", includes: "", in: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}
        )
        SmartContract(
          maximum: Log_Index
          minimum: Log_Index
          selectWhere: {endsWith: "", in: "", includes: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}
        )
        Symbol(maximum: Log_Index, minimum: Log_Index)
      }
      Log {
        Index(
          maximum: Log_Index
          minimum: Log_Index
          selectWhere: {eq: 10, ge: 10, gt: 10, in: 10, le: 10, lt: 10, ne: 10, notIn: 10}
        )
        LogAfterCallIndex(
          maximum: Log_Index
          minimum: Log_Index
          selectWhere: {eq: 10, ge: 10, gt: 10, in: 10, le: 10, lt: 10, ne: 10, notIn: 10}
        )
      }
      Transaction {
        Hash(
          maximum: Log_Index
          minimum: Log_Index
          selectWhere: {endsWith: "", in: "", includes: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}
        )
        Index(minimum: Log_Index, maximum: Log_Index)
        Time(
          minimum: Log_Index
          maximum: Log_Index
          selectWhere: {after: "", before: "", in: "", is: "", not: "", notIn: "", since: "", till: ""}
        )
      }
      Uncle {
        Block {
          Hash(
            maximum: Log_Index
            minimum: Log_Index
            selectWhere: {endsWith: "", in: "", includes: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}
          )
          Number(maximum: Log_Index, minimum: Log_Index)
        }
        Index(maximum: Log_Index, minimum: Log_Index)
      }
      average(
        of: Log_LogAfterCallIndex
        selectWhere: {eq: 1.5, ge: 1.5, gt: 1.5, le: 1.5, lt: 1.5, ne: 1.5}
      )
      contingency(
        of: Log_LogAfterCallIndex
        selectWhere: {eq: 1.5, ge: 1.5, gt: 1.5, le: 1.5, lt: 1.5, ne: 1.5}
        with: Log_LogAfterCallIndex
      )
      correlation(
        of: Log_LogAfterCallIndex
        selectWhere: {eq: 1.5, ge: 1.5, gt: 1.5, le: 1.5, lt: 1.5, ne: 1.5}
        with: Log_LogAfterCallIndex
      )
      count(
        distinct: Transaction_Index
        selectWhere: {eq: "", ge: "", gt: "", lt: "", le: "", ne: ""}
        if: {BalanceUpdate: {Address: {endsWith: "", in: "", includes: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}, Amount: {eq: "", ge: "", gt: "", le: "", lt: "", ne: ""}, AmountInUSD: {eq: "", ge: "", gt: "", le: "", lt: "", ne: ""}, Id: {eq: "", ge: "", gt: "", in: "", le: "", lt: "", ne: "", notIn: ""}, Type: {in: block_reward, is: block_reward, not: transfer, notIn: transfer}, URI: {endsWith: "", in: "", includes: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}}, Block: {Date: {after: "", before: "", in: "", is: "", not: "", notIn: "", since: "", till: ""}, Hash: {endsWith: "", in: "", includes: "", is: "", like: "", not: "", notIn: "", notIncludes: "", startsWith: "", notLike: ""}, L1: {Hash: {endsWith: "", in: "", includes: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}, ParentHash: {}}}}
      )
      covariance(of: BalanceUpdate_Amount, with: BalanceUpdate_Id)
      cramers(of: Block_Number, with: Currency_Decimals)
      kurtosis(of: Log_LogAfterCallIndex)
      median(of: Log_LogAfterCallIndex)
      nakamoto(of: Log_LogAfterCallIndex, selectWhere: {}, ratio: 1.5)
      quantile(of: Log_LogAfterCallIndex)
      rank_correlation(selectWhere: {})
      skew(of: Log_LogAfterCallIndex)
      standard_deviation(of: Log_LogAfterCallIndex)
      sum(of: Log_LogAfterCallIndex)
      theil_index(of: Log_LogAfterCallIndex)
      theils_corrected
      uniq(of: Transaction_Index)
    }
    Blocks(
      limit: {count: 10, offset: 10}
      limitBy: {by: Block_GasUsed, count: 10, offset: 10}
      orderBy: {ascending: Block_GasUsed, ascendingByField: "", descendingByField: "", descending: Block_GasUsed}
      where: {Block: {BaseFee: {eq: "", ge: "", gt: "", le: "", lt: "", ne: ""}, BaseFeeInUSD: {eq: "", ge: "", gt: "", le: "", lt: "", ne: ""}, Coinbase: {endsWith: "", in: "", includes: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}}}
    )
  }
}

Similar queries