optimised bsc query ala

Returns 10000 transfers on BNB Chain, where transfer sender is 0x1875…4fa7, transfer receiver is 0x1875…4fa7 and transfer type is not transaction: transaction hash, gas price, sender fee, block number, block time, transfer amount, sender and 4 more fields.

By Kshitij Mahajan · saved 6 March 2025 · run 1 time · Bitquery API v2

What it returns

Filters

The query

{
  EVM(network: bsc, dataset: archive) {
    sent: Transfers(
      where: {Block: {Time: {since: "2025-02-20T11:14:59Z", till: "2025-02-20T14:14:59Z"}}, Transfer: {Amount: {ne: "0"}, Success: true, Type: {not: transaction}, Sender: {is: "0x18753Fe2b2dd45b2DfBBF112e45E9d79a2984fa7"}}}
      limit: {count: 10000}
    ) {
      Transaction {
        Hash
        GasPrice
      }
      Fee {
        SenderFee
      }
      Block {
        Number
        Time
      }
      Transfer {
        Amount
        Sender
        Receiver
        Type
        Currency {
          Symbol
          SmartContract
        }
      }
    }
    recieved: Transfers(
      where: {Block: {Time: {since: "2025-02-20T11:14:59Z", till: "2025-02-20T14:14:59Z"}}, Transfer: {Amount: {ne: "0"}, Success: true, Type: {not: transaction}, Receiver: {is: "0x18753Fe2b2dd45b2DfBBF112e45E9d79a2984fa7"}}}
      limit: {count: 10000}
    ) {
      Transaction {
        Hash
        GasPrice
      }
      Fee {
        SenderFee
      }
      Block {
        Number
        Time
      }
      Transfer {
        Amount
        Sender
        Receiver
        Type
        Currency {
          Symbol
          SmartContract
        }
      }
    }
  }
}

Similar queries