uniswap_pool_volfilter
Returns 10 DEX trades on Ethereum, where block date is 2024-03-22, sorted by token1 vol: count, sum of trade buy amount in USD, sum of trade sell amount in USD, pair name and smart contract.
What it returns
- count
- sum of trade buy amount in USD
- sum of trade sell amount in USD
- pair name
- smart contract
Filters
- block date is 2024-03-22
The query
query MyQuery {
EVM(dataset: archive, network: eth) {
DEXTrades(
orderBy: {ascendingByField: "token1_vol"}
limit: {count: 10}
where: {Block: {Date: {is: "2024-03-22"}}}
) {
Buyers: count(distinct: Trade_Buy_Buyer)
Sellers: count(distinct: Trade_Buy_Seller)
token1_vol: sum(of: Trade_Buy_AmountInUSD, selectWhere: {ge: "10000", le: "10000000"})
token2_vol: sum(of: Trade_Sell_AmountInUSD, selectWhere: {ge: "10000", le: "10000000"})
Trade {
Dex {
Pair {
Name
SmartContract
}
}
}
}
}
}
Similar queries
- Latest Curve DEX swaps on Ethereum · Ethereum · DEXTrades
- Top Curve liquidity pools by 24h volume on Ethereum · Ethereum · DEXTrades
- STRN_TOKEN_MULTIPLE_DECIMALS_DEX_TRADES · Ethereum · DEXTrades
- USDT DECIMAL SHOWING 0 · Ethereum · DEXTrades
- Trades - 0xEE61159E8A72A08371c52D62c19Efd0C7914f917 · Ethereum · DEXTrades