volume_pair_USDC/WETH
Returns DEX trades by token on Arbitrum, where currency smart contract is 0xaf88…5831, side currency smart contract is 0x82af…bab1 and DEX protocol name is uniswap_v3, sorted by volume, highest first: protocol family, protocol name, smart contract, currency symbol, side currency symbol and sum of trade amount.
What it returns
- protocol family
- protocol name
- smart contract
- currency symbol
- side currency symbol
- sum of trade amount
Filters
- currency smart contract is 0xaf88…5831
- side currency smart contract is 0x82af…bab1
- DEX protocol name is uniswap_v3
- block time since 2025-01-06
The query
query volume {
EVM(network: arbitrum, dataset: combined) {
DEXTradeByTokens(
where: {Trade: {Currency: {SmartContract: {is: "0xaf88d065e77c8cc2239327c5edb3a432268e5831"}}, Side: {Currency: {SmartContract: {is: "0x82af49447d8a07e3bd95bd0d56f35241523fbab1"}}}, Dex: {ProtocolName: {is: "uniswap_v3"}}}, Block: {Time: {since: "2025-01-06T10:36:59Z"}}}
orderBy: {descendingByField: "volume"}
) {
Trade {
Dex {
ProtocolFamily
ProtocolName
SmartContract
}
Currency {
Symbol
}
Side {
Currency {
Symbol
}
}
}
volume: sum(of: Trade_Amount)
}
}
}
Similar queries
- optimized query to get pools data · Ethereum · DEXTradeByTokens
- AfricaCryptoChainx · Ethereum · DEXTradeByTokens
- UniversalSearch EVM · Ethereum · DEXTradeByTokens
- without fragment · Ethereum · DEXTradeByTokens
- trade stats for a token pair on uniswap v4 arbitrum · Arbitrum · DEXTradeByTokens