address_stats_v2
Returns transfers and transactions, where call from is 0x9522…Afe5, balance update address is 0x9522…Afe5 and block date since 2020-01-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, unique of transaction hash and 6 more fields.
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
- sender fee
- count
- sum of balance update amount
- currency name
- currency symbol
- smart contract
Filters
- call from is 0x9522…Afe5
- balance update address is 0x9522…Afe5
- block date since 2020-01-01
- block date till 2025-01-01
The query
query MyQuery {
EVM {
Transfers(
where: {Block: {Date: {since: "2020-01-01", till: "2025-01-01"}}, any: [{Transfer: {Sender: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}, {Transfer: {Receiver: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}]}
) {
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: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}, Currency: {SmartContract: {is: ""}}}}
)
sent_amount: sum(
of: Transfer_Amount
if: {Transfer: {Sender: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}, Currency: {SmartContract: {is: ""}}}}
)
receive_from_count: uniq(
of: Transfer_Sender
if: {Transfer: {Receiver: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}
)
send_to_count: uniq(
of: Transfer_Receiver
if: {Transfer: {Sender: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}
)
receive_from_currencies: uniq(
of: Transfer_Currency_SmartContract
if: {Transfer: {Receiver: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}
)
send_to_currencies: uniq(
of: Transfer_Currency_SmartContract
if: {Transfer: {Sender: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}
)
days_with_receive: uniq(
of: Block_Date
if: {Transfer: {Receiver: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}
)
days_with_sent: uniq(
of: Block_Date
if: {Transfer: {Sender: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}
)
days_with_transfers: uniq(of: Block_Date)
send_txn_count: uniq(
of: Transaction_Hash
if: {Transfer: {Sender: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}
)
receive_txn_count: uniq(
of: Transaction_Hash
if: {Transfer: {Receiver: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}
)
}
Transactions(
where: {any: [{Transaction: {To: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}, {Transaction: {From: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}]}
) {
gasValue: Fee {
SenderFee
}
Block {
first_transaction_at: Time(minimum: Block_Time)
last_transaction_at: Time(maximum: Block_Time)
}
days_with_transactions: uniq(of: Block_Date)
}
Calls(where: {Call: {From: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}}) {
call_txn_count: count
Block {
Time(minimum: Block_Date)
}
}
BalanceUpdates(
where: {BalanceUpdate: {Address: {is: "0x95222290DD7278Aa3Ddd389Cc1E1d165CC4BAfe5"}}, Currency: {SmartContract: {is: ""}}}
) {
balance: sum(of: BalanceUpdate_Amount)
Currency {
Name
Symbol
SmartContract
}
}
}
}
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