Ethereum_v2_startsWith_No_Variable
Returns 5 DEX trades by token, where currency name starts with Wrapped Ether, sorted by block time: smart contract, currency name, currency symbol, price in USD and unique of trade currency smart contract.
What it returns
- smart contract
- currency name
- currency symbol
- price in USD
- unique of trade currency smart contract
Filters
- currency name starts with Wrapped Ether
The query
query ($network: evm_network) {
EVM(network: $network, dataset: realtime) {
DEXTradeByTokens(
where: {Trade: {Currency: {Name: {startsWith: "Wrapped Ether"}}}}
limit: {count: 5}
orderBy: {ascending: Block_Time}
limitBy: {by: Trade_Currency_SmartContract, count: 1}
) {
Trade {
Dex {
SmartContract
}
Currency {
Name
Symbol
SmartContract
}
PriceInUSD
}
uniq(of: Trade_Currency_SmartContract)
}
}
}
Similar queries
- CRV hourly OHLC on Curve - Ethereum · Ethereum · DEXTradeByTokens
- Top Metric liquidity pools by 24h volume on Ethereum · Ethereum · DEXTradeByTokens
- ATH of eth token · Ethereum · DEXTradeByTokens
- historical price and historical volume · Ethereum · DEXTradeByTokens
- topTraders EVM · Ethereum · DEXTradeByTokens