opsin OHLC
Returns 100 DEX trades by token on Ethereum, where currency smart contract is 0x1945…3F6B, side currency smart contract is 0xc02a…6cc2 and side type is buy, sorted by block testfield, highest first: block time, sum of trade amount, price in USD and count.
What it returns
- block time
- sum of trade amount
- price in USD
- count
Filters
- currency smart contract is 0x1945…3F6B
- side currency smart contract is 0xc02a…6cc2
- side type is buy
- block time till 2024-12-09
The query
{
EVM(network: eth, dataset: archive) {
DEXTradeByTokens(
orderBy: {descendingByField: "Block_testfield"}
where: {Trade: {Currency: {SmartContract: {is: "0x1945E804B8A25b98ab140e58295404d768cA3F6B"}}, Side: {Currency: {SmartContract: {is: "0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2"}}, Type: {is: buy}}}, Block: {Time: {till: "2024-12-09T23:59:59Z"}}}
limit: {count: 100}
) {
Block {
testfield: Time(interval: {in: minutes, count: 1})
}
volume: sum(of: Trade_Amount)
Trade {
high: PriceInUSD(maximum: Trade_PriceInUSD)
low: PriceInUSD(minimum: Trade_PriceInUSD)
open: PriceInUSD(minimum: Block_Number)
close: PriceInUSD(maximum: Block_Number)
}
count
}
}
}
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