Token Trade Pairs bu Protocol
Returns 10 DEX trades on Ethereum, where DEX protocol name is uniswap_v2, block date since 2024-01-03 and block date till 2024-01-10, sorted by count, highest first: block date, chain ID, unique of block date, count, median of trade buy price, median of trade buy price in USD, sum of trade buy amount and 11 more fields.
What it returns
- block date
- chain ID
- unique of block date
- count
- median of trade buy price
- median of trade buy price in USD
- sum of trade buy amount
- sum of trade buy amount in USD
- sum of trade sell amount
- sum of trade sell amount in USD
- median of trade sell price
- median of trade sell price in USD
- buy currency symbol
- buy smart contract
- buy currency name
- sell currency symbol
- sell smart contract
- sell currency name
Filters
- DEX protocol name is uniswap_v2
- block date since 2024-01-03
- block date till 2024-01-10
The query
query ($network: evm_network, $limit: Int!, $offset: Int!, $from: String, $till: String, $protocol: String) {
EVM(dataset: combined, network: $network) {
DEXTrades(
limit: {count: $limit, offset: $offset}
where: {Block: {Date: {since: $from, till: $till}}, Trade: {Dex: {ProtocolName: {is: $protocol}}, Success: true}}
orderBy: {descendingByField: "count"}
) {
Block {
Date(minimum: Block_Date)
}
ChainId
uniq(of: Block_Date)
count
buy_price: median(of: Trade_Buy_Price)
buy_price_usd: median(of: Trade_Buy_PriceInUSD)
buy_amount: sum(of: Trade_Buy_Amount)
buy_amount_usd: sum(of: Trade_Buy_AmountInUSD)
sell_amount: sum(of: Trade_Sell_Amount)
sell_amount_usd: sum(of: Trade_Sell_AmountInUSD)
sell_price: median(of: Trade_Sell_Price)
sell_price_usd: median(of: Trade_Sell_PriceInUSD)
Trade {
Buy {
Currency {
Symbol
SmartContract
Name
}
}
Sell {
Currency {
Symbol
SmartContract
Name
}
}
}
}
}
}
Variables
{
"network": "eth",
"limit": 10,
"offset": 0,
"from": "2024-01-03",
"till": "2024-01-10",
"protocol": "uniswap_v2"
}
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