v2-equivalant-ohlc-and-volume-inUSD
Returns DEX trades by token on Ethereum, where currency smart contract is 0xb23d…28CF, side currency smart contract is 0xC02a…6Cc2 and DEX protocol family is Uniswap: currency symbol, smart contract, price in USD, side currency symbol, side smart contract, count, sum of trade amount in USD and block time.
What it returns
- currency symbol
- smart contract
- price in USD
- side currency symbol
- side smart contract
- count
- sum of trade amount in USD
- block time
Filters
- currency smart contract is 0xb23d…28CF
- side currency smart contract is 0xC02a…6Cc2
- DEX protocol family is Uniswap
- block time since 2024-09-26
- trade price asymmetry is below 1
The query
query MyQuery {
EVM(network: eth) {
DEXTradeByTokens(
where: {Trade: {Currency: {SmartContract: {is: "0xb23d80f5FefcDDaa212212F028021B41DEd428CF"}}, Side: {Currency: {SmartContract: {is: "0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2"}}}, PriceAsymmetry: {lt: 1}, Dex: {ProtocolFamily: {is: "Uniswap"}}}, Block: {Time: {since: "2024-09-26T10:00:00Z"}}}
) {
Trade {
Currency {
Symbol
SmartContract
}
open: PriceInUSD(minimum: Block_Number)
close: PriceInUSD(maximum: Block_Number)
high: PriceInUSD(maximum: Trade_PriceInUSD)
low: PriceInUSD(minimum: Trade_PriceInUSD)
Side {
Currency {
Symbol
SmartContract
}
}
}
trades: count
volume: sum(of: Trade_AmountInUSD)
Block {
Time(interval: {count: 30, in: minutes})
}
}
}
}
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