Testing OLAP DateTime

Returns transfers on Ethereum, where currency smart contract is 0xa0b8…eb48, transfer sender is 0x94c8…ebea and block time before 2022-06-16.

By lukas · saved 6 February 2025 · run 1 time · Bitquery API v2

Filters

The query

query TokenMovesOutV2($network: evm_network!, $senders: [String!], $AmountSelector: EVM_Amount_With_Decimals, $token: String!, $timestamp: OLAP_DateTime!, $options: EVM_Transfer_LimitBy!, $orderOptions: EVM_Transfer_Ordering!) {
  EVM(dataset: combined, network: $network) {
    Transfers(
      where: {Transfer: {Currency: {SmartContract: {is: $token}}, Amount: $AmountSelector, Sender: {in: $senders}}, Block: {Time: $timestamp}}
      limitBy: $options
      orderBy: [$orderOptions]
    ) {
      ...tokenMove
    }
  }
}

fragment tokenMove on EVM_Transfer_Cube {
  Block {
    Number
    Time
  }
  Transaction {
    Hash
  }
}

Variables

{
  "AmountSelector": {
    "gt": "0"
  },
  "options": {
    "count": 5
  },
  "orderOptions": {
    "descending": "Block_Time"
  },
  "timestamp": {
    "before": "2022-06-16T07:25:31Z"
  },
  "token": "0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48",
  "network": "eth",
  "senders": [
    "0x94c8249a0cf419e5dd16526fda745c38f3a0ebea"
  ]
}

Similar queries