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.
Filters
- currency smart contract is 0xa0b8…eb48
- transfer sender is 0x94c8…ebea
- block time before 2022-06-16
- transfer amount is above 0
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
- Ethereum Address Latest Transfers In and Out · Ethereum · Transfers
- Tornado Cash: ETH paid into the four ETH pools, Jan 1 to Sep 27 2026 · Ethereum · Transfers