get Base OHLC
Returns the latest 3 DEX trades by token on Base, where currency smart contract is 0x506B…989F and side currency smart contract is 0x4200…0006: block date, sum of trade amount, trade price, currency name, protocol name, smart contract, side currency name and 2 more fields.
What it returns
- block date
- sum of trade amount
- trade price
- currency name
- protocol name
- smart contract
- side currency name
- side smart contract
- count
Filters
- currency smart contract is 0x506B…989F
- side currency smart contract is 0x4200…0006
The query
query MyQuery {
EVM(dataset: archive, network: base) {
DEXTradeByTokens(
orderBy: {descendingByField: "Block_datefield"}
where: {Trade: {Currency: {SmartContract: {is: "0x506BEb7965FC7053059006c7ab4C62c02C2D989F"}}, Side: {Currency: {SmartContract: {is: "0x4200000000000000000000000000000000000006"}}}}}
limit: {count: 3}
) {
Block {
datefield: Date(interval: {in: days, count: 1})
}
volume: sum(of: Trade_Amount)
Trade {
high: Price(maximum: Trade_Price)
low: Price(minimum: Trade_Price)
open: Price(minimum: Block_Number)
close: Price(maximum: Block_Number)
Currency {
Name
}
Dex {
ProtocolName
SmartContract
}
Side {
Currency {
Name
SmartContract
}
}
}
count
}
}
}
Similar queries
- Coinbase stock tokens: DEX trading on Base, Sep 5 to Oct 4 2026 · Base · DEXTradeByTokens
- Coinbase stock tokens: DEX trading on Base in August 2026 · Base · DEXTradeByTokens
- optimized query to get pools data · Ethereum · DEXTradeByTokens
- AfricaCryptoChainx · Ethereum · DEXTradeByTokens
- top pools of a token · Base · DEXTradeByTokens