Event statistic by date
Returns the latest 10 events on Arbitrum, where signature signature hash is 8c5be1…b925, block date since 2024-01-03 and block date till 2024-01-10: block date, chain ID, count, unique of call from, unique of call to, unique of transaction from, unique of transaction to and 4 more fields.
What it returns
- block date
- chain ID
- count
- unique of call from
- unique of call to
- unique of transaction from
- unique of transaction to
- unique of log smart contract
- sum of transaction value
- sum of transaction value in USD
- average of transaction value
Filters
- signature signature hash is 8c5be1…b925
- block date since 2024-01-03
- block date till 2024-01-10
The query
query ($network: evm_network, $limit: Int, $method: String, $from: String, $till: String) {
EVM(dataset: combined, network: $network) {
Events(
where: {Log: {Signature: {SignatureHash: {is: $method}}}, Block: {Date: {since: $from, till: $till}}}
limit: {count: $limit}
orderBy: {descending: Block_Date}
) {
Block {
Date
}
ChainId
count
call_from: uniq(of: Call_From)
call_to: uniq(of: Call_To)
transaction_from: uniq(of: Transaction_From)
transaction_to: uniq(of: Transaction_To)
smart_contract: uniq(of: Log_SmartContract)
daily_total_value: sum(of: Transaction_Value)
daily_total_value_usd: sum(of: Transaction_ValueInUSD)
daily__avg_value: average(of: Transaction_Value)
}
}
}
Variables
{
"limit": 10,
"network": "arbitrum",
"from": "2024-01-03",
"till": "2024-01-10",
"method": "8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b925"
}
Similar queries
- Solana InstructionBalanceUpdates · Arbitrum · Transfers
- Account Value Raw Output · Arbitrum · Events
- GMX Increase Position Event · Arbitrum · Events
- Event 0xaf88d065e77c8cC2239327C5EDb3A432268e5831 · Arbitrum · Events
- approve · Arbitrum · Events