v2 stats- slow
Returns transactions and calls, where call from is 0xe25F…04b4, balance update address is 0xe25F…04b4 and currency smart contract is 0x: block time, unique of block date, count, sum of balance update amount, currency name, currency symbol and smart contract.
What it returns
- block time
- unique of block date
- count
- sum of balance update amount
- currency name
- currency symbol
- smart contract
Filters
- call from is 0xe25F…04b4
- balance update address is 0xe25F…04b4
- currency smart contract is 0x
The query
query MyQuery($sender: String, $receiver: String,$currency: String) {
EVM(dataset: combined) {
Transactions(
where: {any: [{Transaction: {To: {is: $receiver}}}, {Transaction: {From: {is: $sender}}}]}
) {
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: $sender}}}) {
call_txn_count: count
Block {
Time(minimum: Block_Date)
}
}
BalanceUpdates(
where: {BalanceUpdate: {Address: {is: $sender}}, Currency: {SmartContract: {is: $currency}}}
) {
balance: sum(of: BalanceUpdate_Amount)
Currency {
Name
Symbol
SmartContract
}
}
}
}
Variables
{
"sender":"0xe25F68282AFB652A9573D9C5c730f7C7c59c04b4",
"receiver": "0xe25F68282AFB652A9573D9C5c730f7C7c59c04b4",
"since":"2021-08-01T00:00:00Z",
"till": "2022-05-01T00:00:00Z",
"currency": "0x"
}
Similar queries
- Wwa to nie london · Ethereum · Transactions
- transactions · Ethereum · Transactions
- Solos · Ethereum · Transactions
- Get transactions by wallet · Ethereum · Transactions
- eth latest activity · Ethereum · Transfers