Copy of Wilbur
Returns 10 balance updates and blocks on Base, where call path ends with is 10, call path ends with is at least 10 and call path ends with is above 10, sorted by block gas used: balance update address, balance update amount, amount in USD, balance update ID, balance update type, URI, block date and 41 more fields.
What it returns
- balance update address
- balance update amount
- amount in USD
- balance update ID
- balance update type
- URI
- block date
- block hash
- l 1 hash
- parent hash
- block number
- block time
- call path
- call index
- chain ID
- decimals
- delegated
- delegated to
- fungible
- has URI
- currency name
- native
- protocol name
- smart contract
- currency symbol
- log index
- log after call index
- transaction hash
- transaction index
- transaction time
- uncle index
- average of log log after call index
- contingency of log log after call index
- correlation of log log after call index
- count
- covariance of balance update amount
- cramers of block number
- kurtosis of log log after call index
- median of log log after call index
- nakamoto of log log after call index
- quantile of log log after call index
- rank correlation
- skew of log log after call index
- standard deviation of log log after call index
- sum of log log after call index
- theil index of log log after call index
- theils corrected
- unique of transaction index
Filters
- call path ends with is 10
- call path ends with is at least 10
- call path ends with is above 10
- call path ends with is at most 10
- call path ends with is below 10
- call path ends with is not 10
- call path excludes is 10
- call path excludes is at least 10
- call path excludes is above 10
- call path excludes is at most 10
- call path excludes is below 10
- call path excludes is not 10
The query
query MyQuery($BalanceUpdate: EVM_BalanceUpdate_Input_BalanceUpdate_InputType = {}) {
EVM(dataset: realtime, mempool: true, network: base, select_blocks: trunk) {
BalanceUpdates(
limit: {count: 10, offset: 10}
limitBy: {by: Transaction_Index, count: 10, offset: 10}
orderBy: {ascending: Transaction_Index, ascendingByField: "", descending: BalanceUpdate_Amount, descendingByField: ""}
where: {BalanceUpdate: $BalanceUpdate, Block: {Date: {after: "", before: "", in: "", is: "", not: "", notIn: "", since: "", till: ""}, Hash: {endsWith: "", in: "", includes: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}, L1: {Hash: {endsWith: "", in: "", includes: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}, ParentHash: {endsWith: "", in: "", includes: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}}, Number: {eq: "", ge: "", gt: "", in: "", le: "", lt: "", ne: "", notIn: ""}, ParentHash: {endsWith: "", in: "", is: "", includes: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}, Time: {after: "", before: "", in: "", is: "", not: "", notIn: "", since: "", till: ""}}, Call: {CallPath: {endsWith: {eq: 10, ge: 10, gt: 10, in: 10, le: 10, lt: 10, ne: 10, notIn: 10}, excludes: {eq: 10, ge: 10, gt: 10, le: 10, in: 10, lt: 10, ne: 10, notIn: 10}}}}
) {
BalanceUpdate {
Address(maximum: Log_Index, minimum: Log_Index)
Amount(
maximum: Log_Index
minimum: Log_Index
selectWhere: {eq: "", ge: "", le: "", lt: "", gt: "", ne: ""}
)
AmountInUSD(maximum: Log_Index, minimum: Log_Index)
Id(maximum: Log_Index, minimum: Log_Index)
Type(maximum: Log_Index, minimum: Log_Index)
URI(maximum: Log_Index, minimum: Log_Index)
}
Block {
Date(maximum: Log_Index, minimum: Log_Index)
Hash(maximum: Log_Index)
L1 {
Hash(maximum: Log_Index, minimum: Log_Index)
ParentHash(maximum: Log_Index, minimum: Log_Index)
}
Number(maximum: Log_Index, minimum: Log_Index)
ParentHash(maximum: Log_Index, minimum: Log_Index)
Time(maximum: Log_Index, minimum: Log_Index)
}
Call {
CallPath(maximum: Log_Index, minimum: Log_Index)
Index(maximum: Log_Index, minimum: Log_Index)
}
ChainId(maximum: Log_Index, minimum: Log_Index)
Currency {
Decimals(maximum: Log_Index, minimum: Log_Index)
Delegated(maximum: Log_Index, minimum: Log_Index, selectWhere: true)
DelegatedTo(
maximum: Log_Index
minimum: Log_Index
selectWhere: {endsWith: "", in: "", includes: "", is: "", not: "", like: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}
)
Fungible(maximum: Log_Index, minimum: Log_Index, selectWhere: true)
HasURI(maximum: Log_Index, minimum: Log_Index, selectWhere: true)
Name(
maximum: Log_Index
minimum: Log_Index
selectWhere: {endsWith: "", includes: "", in: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}
)
Native(maximum: Log_Index, minimum: Log_Index, selectWhere: true)
ProtocolName(
maximum: Log_Index
minimum: Log_Index
selectWhere: {endsWith: "", includes: "", in: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}
)
SmartContract(
maximum: Log_Index
minimum: Log_Index
selectWhere: {endsWith: "", in: "", includes: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}
)
Symbol(maximum: Log_Index, minimum: Log_Index)
}
Log {
Index(
maximum: Log_Index
minimum: Log_Index
selectWhere: {eq: 10, ge: 10, gt: 10, in: 10, le: 10, lt: 10, ne: 10, notIn: 10}
)
LogAfterCallIndex(
maximum: Log_Index
minimum: Log_Index
selectWhere: {eq: 10, ge: 10, gt: 10, in: 10, le: 10, lt: 10, ne: 10, notIn: 10}
)
}
Transaction {
Hash(
maximum: Log_Index
minimum: Log_Index
selectWhere: {endsWith: "", in: "", includes: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}
)
Index(minimum: Log_Index, maximum: Log_Index)
Time(
minimum: Log_Index
maximum: Log_Index
selectWhere: {after: "", before: "", in: "", is: "", not: "", notIn: "", since: "", till: ""}
)
}
Uncle {
Block {
Hash(
maximum: Log_Index
minimum: Log_Index
selectWhere: {endsWith: "", in: "", includes: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}
)
Number(maximum: Log_Index, minimum: Log_Index)
}
Index(maximum: Log_Index, minimum: Log_Index)
}
average(
of: Log_LogAfterCallIndex
selectWhere: {eq: 1.5, ge: 1.5, gt: 1.5, le: 1.5, lt: 1.5, ne: 1.5}
)
contingency(
of: Log_LogAfterCallIndex
selectWhere: {eq: 1.5, ge: 1.5, gt: 1.5, le: 1.5, lt: 1.5, ne: 1.5}
with: Log_LogAfterCallIndex
)
correlation(
of: Log_LogAfterCallIndex
selectWhere: {eq: 1.5, ge: 1.5, gt: 1.5, le: 1.5, lt: 1.5, ne: 1.5}
with: Log_LogAfterCallIndex
)
count(
distinct: Transaction_Index
selectWhere: {eq: "", ge: "", gt: "", lt: "", le: "", ne: ""}
if: {BalanceUpdate: {Address: {endsWith: "", in: "", includes: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}, Amount: {eq: "", ge: "", gt: "", le: "", lt: "", ne: ""}, AmountInUSD: {eq: "", ge: "", gt: "", le: "", lt: "", ne: ""}, Id: {eq: "", ge: "", gt: "", in: "", le: "", lt: "", ne: "", notIn: ""}, Type: {in: block_reward, is: block_reward, not: transfer, notIn: transfer}, URI: {endsWith: "", in: "", includes: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}}, Block: {Date: {after: "", before: "", in: "", is: "", not: "", notIn: "", since: "", till: ""}, Hash: {endsWith: "", in: "", includes: "", is: "", like: "", not: "", notIn: "", notIncludes: "", startsWith: "", notLike: ""}, L1: {Hash: {endsWith: "", in: "", includes: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}, ParentHash: {}}}}
)
covariance(of: BalanceUpdate_Amount, with: BalanceUpdate_Id)
cramers(of: Block_Number, with: Currency_Decimals)
kurtosis(of: Log_LogAfterCallIndex)
median(of: Log_LogAfterCallIndex)
nakamoto(of: Log_LogAfterCallIndex, selectWhere: {}, ratio: 1.5)
quantile(of: Log_LogAfterCallIndex)
rank_correlation(selectWhere: {})
skew(of: Log_LogAfterCallIndex)
standard_deviation(of: Log_LogAfterCallIndex)
sum(of: Log_LogAfterCallIndex)
theil_index(of: Log_LogAfterCallIndex)
theils_corrected
uniq(of: Transaction_Index)
}
Blocks(
limit: {count: 10, offset: 10}
limitBy: {by: Block_GasUsed, count: 10, offset: 10}
orderBy: {ascending: Block_GasUsed, ascendingByField: "", descendingByField: "", descending: Block_GasUsed}
where: {Block: {BaseFee: {eq: "", ge: "", gt: "", le: "", lt: "", ne: ""}, BaseFeeInUSD: {eq: "", ge: "", gt: "", le: "", lt: "", ne: ""}, Coinbase: {endsWith: "", in: "", includes: "", is: "", like: "", not: "", notIn: "", notIncludes: "", notLike: "", startsWith: ""}}}
)
}
}
Similar queries
- base token holder · Base · BalanceUpdates
- base real time token holder · Base · BalanceUpdates
- Top 10 holders of multiple tokens on Base · Base · BalanceUpdates
- balances of wallets test2 base · Base · BalanceUpdates
- search address v2 · Ethereum · BalanceUpdates