latest Aerodrome Finance: CL100-WETH/VVV Pool Gauge withdraw transactions

Historical data This query uses the realtime dataset (the default), which holds only a recent window - hours to days depending on the cube. For older data add a dataset to the top-level element: EVM(network: base, dataset: combined) archive full history combined archive + realtime in one result A

By Akshat · saved 6 November 2025 · Bitquery API v2

What it returns

Filters

The query

# Historical data
#   This query uses the realtime dataset (the default), which holds only a
#   recent window - hours to days depending on the cube.
#
#   For older data add a dataset to the top-level element:
#
#     EVM(network: base, dataset: combined)
#
#     archive   full history
#     combined  archive + realtime in one result
#
#   Archive and combined need the historical data add-on:
#   https://bitquery.io/pricing
#
# Datasets:  https://docs.bitquery.io/docs/graphql/dataset/archive/
# Retention: https://docs.bitquery.io/docs/graphql/data-coverage-retention/
#

query MyQuery {
  EVM(network: base) {
    Events(
      limit: {count: 10}
      orderBy: {descending: Block_Time}
      where: {Call: {From: {is: "0x5d05ef25a5f933271e1f0fdc02dc3eab6a4ea687"}}, Log: {Signature:{Name:{is:"Withdraw"}}}, TransactionStatus: {Success: true}}
    ) {
      Block {
        Time
        Number
      }
      Transaction {
        Hash
      }
      Arguments {
        Index
        Name
        Path {
          Index
          Name
          Type
        }
        Type
        Value {
          ... on EVM_ABI_Integer_Value_Arg {
            integer
          }
          ... on EVM_ABI_String_Value_Arg {
            string
          }
          ... on EVM_ABI_Address_Value_Arg {
            address
          }
          ... on EVM_ABI_BigInt_Value_Arg {
            bigInteger
          }
          ... on EVM_ABI_Bytes_Value_Arg {
            hex
          }
          ... on EVM_ABI_Boolean_Value_Arg {
            bool
          }
        }
      }
      Call {
        From
        To
      }
      Log {
        Signature {
          Name
          Signature
        }
        SmartContract
      }
    }
  }
}

Similar queries