v2 address stats- Slow
Returns transfers, where block time since 2021-08-01: block time, sum of transfer amount, unique of transfer sender, unique of transfer receiver, unique of transfer currency smart contract, unique of block date and unique of transaction hash.
What it returns
- block time
- sum of transfer amount
- unique of transfer sender
- unique of transfer receiver
- unique of transfer currency smart contract
- unique of block date
- unique of transaction hash
Filters
- block time since 2021-08-01
The query
query MyQuery($sender: String, $receiver: String, $since: DateTime, $currency: String) {
EVM(dataset: combined) {
Transfers(
where: {Block: {Time: {since: $since}}, any: [{Transfer: {Sender: {is: $sender}}}, {Transfer: {Receiver: {is: $receiver}}}]}
) {
Block {
first_transfer_at: Time(minimum: Block_Time)
last_transfer_at: Time(maximum: Block_Time)
}
receive_amount: sum(
of: Transfer_Amount
if: {Transfer: {Receiver: {is: $receiver}, Currency: {SmartContract: {is: $currency}}}}
)
sent_amount: sum(
of: Transfer_Amount
if: {Transfer: {Sender: {is: $sender}, Currency: {SmartContract: {is: $currency}}}}
)
receive_from_count: uniq(
of: Transfer_Sender
if: {Transfer: {Receiver: {is: $receiver}}}
)
send_to_count: uniq(
of: Transfer_Receiver
if: {Transfer: {Sender: {is: $sender}}}
)
receive_from_currencies: uniq(
of: Transfer_Currency_SmartContract
if: {Transfer: {Receiver: {is: $receiver}}}
)
send_to_currencies: uniq(
of: Transfer_Currency_SmartContract
if: {Transfer: {Sender: {is: $sender}}}
)
days_with_receive: uniq(
of: Block_Date
if: {Transfer: {Receiver: {is: $receiver}}}
)
days_with_sent: uniq(of: Block_Date, if: {Transfer: {Sender: {is: $sender}}})
days_with_transfers: uniq(of: Block_Date)
send_txn_count: uniq(
of: Transaction_Hash
if: {Transfer: {Sender: {is: $sender}}}
)
receive_txn_count: uniq(
of: Transaction_Hash
if: {Transfer: {Receiver: {is: $receiver}}}
)
}
}
}
Variables
{
"sender":"0xe25F68282AFB652A9573D9C5c730f7C7c59c04b4",
"receiver": "0xe25F68282AFB652A9573D9C5c730f7C7c59c04b4",
"since":"2021-08-01T00:00:00Z",
"currency": "0x"
}
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