all_pairs_filtering
Returns 1000 DEX trades on Ethereum and BNB Chain, where quote currency is 0xbb4c…095c, 0x55d3…7955 or 1 more, exchange address is 0xca14…0c73, 0x0bfb…1865 or 1 more and time since 2024-05-28, sorted by trade amount, highest first: base currency symbol, base currency name, decimals, base currency address, quote currency name, quote currency address, minimum of block and 6 more fields.
What it returns
- base currency symbol
- base currency name
- decimals
- base currency address
- quote currency name
- quote currency address
- minimum of block
- maximum of block
- expression
- count
- trade amount
- quote price
- quote amount
Filters
- quote currency is 0xbb4c…095c, 0x55d3…7955 or 1 more
- exchange address is 0xca14…0c73, 0x0bfb…1865 or 1 more
- time since 2024-05-28
- time till 2024-05-29
- trade amount USD is above 1.5
- trade amount USD is below 10000
The query
query ($network: EthereumNetwork!, $limit: Int, $from: ISO8601DateTime, $till: ISO8601DateTime, $quoteCurrencies: [String!], $exchangeAddresses: [String!]) {
ethereum(network: $network) {
dexTrades(
quoteCurrency: {in: $quoteCurrencies}
time: {since: $from, till: $till}
options: {limit: $limit, desc: "tradeAmount", limitBy: {each: "baseCurrency.address, quoteCurrency.address", limit: 1}}
exchangeAddress: {in: $exchangeAddresses}
tradeAmountUsd: {gt: 1.5, lt: 10000}
) {
baseCurrency {
symbol
name
decimals
address
}
quoteCurrency {
name
address
}
open_price: minimum(of: block, get: quote_price)
close_price: maximum(of: block, get: quote_price)
open_price_time: minimum(of: block, get: time)
close_price_time: maximum(of: block, get: time)
diff: expression(get: "close_price - open_price")
div: expression(get: "diff / open_price")
final: expression(get: "div * 100")
count
tradeAmount(in: USD)
quotePrice
quoteAmount
volume: quoteAmount(in: USD)
}
}
}
Variables
{
"network": "bsc",
"limit": 1000,
"from": "2024-05-28",
"till": "2024-05-29",
"quoteCurrencies": ["0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c", "0x55d398326f99059ff775485246999027b3197955", "0xe9e7cea3dedca5984780bafc599bd69add087d56"],
"exchangeAddresses": ["0xca143ce32fe78f1f7019d7d551a6402fc5350c73", "0x0bfbcf9fa4f9c56b0f40a671ad40e0805a091865", "0xdb1d10011ad0ff90774d0c6bb92e5c5c8b4461f7"]
}
Similar queries
- Latest DODO DEX swaps on BSC · BNB Chain · DEXTrades
- Top DODO liquidity pools by 24h volume on BSC · BNB Chain · DEXTrades
- trades · Ethereum · DEXTrades
- metric_v1_bsc · BNB Chain · DEXTrades
- bsc_tessera · BNB Chain · DEXTrades