Arbitrum V2 Problem

Returns 10000 transfers on Arbitrum, where transfer sender is 0xAeF9…23fb, transfer receiver is 0xAeF9…23fb and transfer amount is above 0, sorted by block time: transaction hash, transfer amount, fungible, currency symbol, smart contract, native, sender and 2 more fields.

By David · saved 6 November 2024 · Bitquery API v2

What it returns

Filters

The query

query (
  $network: evm_network!
  $address: String!
  $limit: Int!
  $offset: Int!
  $from: DateTime
) {
  EVM(network: $network, dataset: archive) {
    outs: Transfers(
      where: {
        Transfer: { Sender: { is: $address }, Amount: { gt: "0" } }
        TransactionStatus: { Success: true }
        Block: { Time: { since: $from } }
      }
      orderBy: { ascending: Block_Time }
      limit: { count: $limit, offset: $offset }
    ) {
      Transaction {
        Hash
      }
      Transfer {
        Amount
        Currency {
          Fungible
          Symbol
          SmartContract
          Native
        }
        wallet: Sender
        address: Receiver
      }
      Block {
        Time
      }
    }
    ins: Transfers(
      where: {
        Transfer: { Receiver: { is: $address }, Amount: { gt: "0" } }
        TransactionStatus: { Success: true }
        Block: { Time: { since: $from } }
      }
      orderBy: { ascending: Block_Time }
      limit: { count: $limit, offset: $offset }
    ) {
      Transaction {
        Hash
      }
      Transfer {
        Amount
        Currency {
          Fungible
          Symbol
          SmartContract
          Native
        }
        address: Sender
        wallet: Receiver
      }
      Block {
        Time
      }
    }
  }
}

Variables

{
  "network": "arbitrum",
  "address": "0xAeF9C053c346c4FFB663d77A18460b3b521623fb",
  "limit": 10000,
  "offset": 0
}

Similar queries