query_support_ticket_3025521294

Returns 2 transfers and balance updates on Ethereum, where transfer receiver is 0x0315…c0ef, balance update address is 0x0315…c0ef and currency smart contract is 0xc02a…6cc2 or 0xDF52…fA0E, sorted by block time: transaction hash, transfer amount, smart contract, currency name, currency symbol, sum of balance update amount, balance update address and 3 more fields.

By Omkar_BQ · saved 30 July 2024 · Bitquery API v2

What it returns

Filters

The query

{
  EVM(dataset: combined, network: eth) {
    Initaial_liquidity: Transfers(
      limit: {count: 2}
      orderBy: {ascending: Block_Time}
      where: {Transfer: {Receiver: {in: "0x0315953c51a0adb4bd0b9f672f5c3ca9653ec0ef"}}}
    ) {
      Transaction {
        Hash
      }
      Transfer {
        Amount
        Currency {
          SmartContract
          Name
          Symbol
        }
      }
    }
    Current_lquidity: BalanceUpdates(
      where: {BalanceUpdate: {Address: {is: "0x0315953c51a0adb4bd0b9f672f5c3ca9653ec0ef"}}, Currency: {SmartContract: {in: ["0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2", "0xDF52961d40047d30e77990E4d23A1B01Dd28fA0E"]}}}
    ) {
      Currency {
        Name
        SmartContract
      }
      balance: sum(of: BalanceUpdate_Amount, selectWhere: {gt: "0"})
      BalanceUpdate {
        Address
      }
    }
    volume: DEXTrades(
      where: {Block: {Time: {since: "2023-12-28T10:01:55.000Z"}}, Trade: {Dex: {Pair: {SmartContract: {is: "0x0315953c51a0adb4bd0b9f672f5c3ca9653ec0ef"}}}}}
    ) {
      token1_vol: sum(of: Trade_Buy_Amount)
      token2_vol: sum(of: Trade_Sell_Amount)
    }
    transactions: DEXTrades(
      where: {Block: {Time: {since: "2023-12-28T10:01:55.000Z"}}, Trade: {Dex: {Pair: {SmartContract: {is: "0x0315953c51a0adb4bd0b9f672f5c3ca9653ec0ef"}}}}}
    ) {
      count: count
    }
  }
}

Similar queries