chart
Returns the latest 20 DEX trades by token, where DEX owner address is 0x3312…FDfD and trade price is above 0: block time, sum of trade amount and price in USD.
What it returns
- block time
- sum of trade amount
- price in USD
Filters
- DEX owner address is 0x3312…FDfD
- trade price is above 0
The query
query ($network: evm_network, $baseCurrency: String, $quoteCurrency: String, $from: DateTime, $till: DateTime) {
EVM(dataset: combined, network: $network) {
DEXTradeByTokens(
limit: {count: 20}
orderBy: {descendingByField: "Block_Time"}
where: {Trade: {Currency: {SmartContract: {is: $baseCurrency}}, Side: {Currency: {SmartContract: {is: $quoteCurrency}}}, Price: {gt: 0}, Dex: {OwnerAddress: {is: "0x33128a8fC17869897dcE68Ed026d694621f6FDfD"}}}, Block: {Time: {since: $from, till: $till}}}
) {
Block {
Time(interval: {in: minutes, count: 10})
}
volume: sum(of: Trade_Amount)
Trade {
close: PriceInUSD(maximum: Block_Number)
}
}
}
}
Variables
{
"network": "base",
"baseCurrency": "0x0b3e328455c4059eeb9e3f84b5543f74e24e7e1b",
"quoteCurrency": "0x4200000000000000000000000000000000000006",
"from": "2025-02-01T05:03:08.228Z",
"till": "2025-02-02T05:03:08.228Z",
}
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