Wwa to nie london
1 second crypto price stream across EVM, Solana, Tron schains
Returns transactions and transfers: sum of fee sender fee, sum of fee sender fee in USD, count, chain ID, block time, unique of block date, sum of transfer amount and sum of transfer amount in USD.
What it returns
- sum of fee sender fee
- sum of fee sender fee in USD
- count
- chain ID
- block time
- unique of block date
- sum of transfer amount
- sum of transfer amount in USD
The query
query ($network: evm_network, $address: String!) {
EVM(dataset: archive, network: $network) {
fee: Transactions(where: {Transaction: {From: {is: $address}}}) {
tx_fee: sum(of: Fee_SenderFee)
tx_fee_usd: sum(of: Fee_SenderFeeInUSD)
tx_count: count
}
currencies_reciiver: Transfers(where: {Transfer: {Receiver: {is: $address}}}) {
ChainId
r_currencies: count(distinct: Transfer_Currency_SmartContract)
Block {
r_from: Time(minimum: Block_Time)
r_to: Time(maximum: Block_Time)
}
r_days: uniq(of: Block_Date)
}
receiver: Transfers(
where: {Transfer: {Currency: {Native: true}, Receiver: {is: $address}}}
) {
r_amount: sum(of: Transfer_Amount)
r_amount_usd: sum(of: Transfer_AmountInUSD)
}
currencies_sender: Transfers(where: {Transfer: {Sender: {is: $address}}}) {
ChainId
s_currencies: count(distinct: Transfer_Currency_SmartContract)
Block {
s_from: Time(minimum: Block_Time)
s_to: Time(maximum: Block_Time)
}
s_days: uniq(of: Block_Date)
}
sender: Transfers(
where: {Transfer: {Currency: {Native: true}, Sender: {is: $address}}}
) {
s_amount: sum(of: Transfer_Amount)
s_amount_usd: sum(of: Transfer_AmountInUSD)
}
}
}
query ($network: evm_network, $address: String!, $limit: Int) {
EVM(network: $network, dataset: archive) {
BalanceUpdates(
orderBy: {descendingByField: "sum"}
where: {BalanceUpdate: {Address: {is: $address}}}
limit: {count: $limit}
) {
ChainId
count
Currency {
Symbol
SmartContract
}
sum(of: BalanceUpdate_Amount, selectWhere: {gt: "0.0"})
sum_usd: sum(of: BalanceUpdate_AmountInUSD, selectWhere: {gt: "0.0"})
}
}
}
query ($network: evm_network, $address: String!) {
EVM(dataset: realtime, network: $network) {
Transactions(
where: {Transaction: {From: {is: $address}}}
orderBy: {descending: Block_Date}
) {
ChainId
Block {
Date
}
sum(of: Fee_SenderFee)
count
}
}
}
Similar queries
- transactions · Ethereum · Transactions
- Solos · Ethereum · Transactions
- Get transactions by wallet · Ethereum · Transactions
- eth latest activity · Ethereum · Transfers
- sorting_two_fields · Ethereum · Transactions