OHLC-of-AERO-Coin
Historical data This query already reads history - it uses the combined dataset, which needs the historical data add-on for this chain. Without the add-on it fails with 'access restricted: your plan only allows realtime'. Drop the dataset argument to fall back to the recent window. Datasets: https:
What it returns
- block time
- sum of trade amount
- trade price
- count
Filters
- currency smart contract is 0x9401…8631
- side currency smart contract is 0x8335…2913
- side type is buy
- trade price asymmetry is below 0.1
The query
# Historical data
# This query already reads history - it uses the combined dataset, which
# needs the historical data add-on for this chain.
#
# Without the add-on it fails with 'access restricted: your plan only allows
# realtime'. Drop the dataset argument to fall back to the recent window.
#
# Datasets: https://docs.bitquery.io/docs/graphql/dataset/archive/
# Retention: https://docs.bitquery.io/docs/graphql/data-coverage-retention/
#
{
EVM(network: base, dataset: combined) {
DEXTradeByTokens(
orderBy: {descendingByField: "Block_testfield"}
where: {Trade: {Currency: {SmartContract: {is: "0x940181a94A35A4569E4529A3CDfB74e38FD98631"}}, Side: {Currency: {SmartContract: {is: "0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913"}}, Type: {is: buy}}, PriceAsymmetry: {lt: 0.1}}}
limit: {count: 10}
) {
Block {
testfield: Time(interval: {in: hours, 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)
}
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