volume with intervals evm
Returns DEX trades by token on Ethereum, where currency smart contract is 0xdAC1…1ec7, block time since 2024-12-14 and block time till 2024-12-14, sorted by block OHLC interval: block time, sum of trade amount in USD, price in USD and count.
What it returns
- block time
- sum of trade amount in USD
- price in USD
- count
Filters
- currency smart contract is 0xdAC1…1ec7
- block time since 2024-12-14
- block time till 2024-12-14
- trade price asymmetry is at most 0.2
The query
query MyQuery($token: String, $from_date_time: DateTime, $to_date_time: DateTime) {
EVM(network: eth, dataset: combined) {
DEXTradeByTokens(
orderBy: {ascendingByField: "Block_OHLC_interval"}
where: {Trade: {Currency: {SmartContract: {is: $token}}, PriceAsymmetry: {le: 0.2}}, Block: {Time: {since: $from_date_time, till: $to_date_time}}}
) {
Block {
OHLC_interval: Time(interval: {in: minutes, count: 10})
}
volume: sum(of: Trade_AmountInUSD)
Trade {
high: PriceInUSD(maximum: Trade_PriceInUSD)
low: PriceInUSD(minimum: Trade_PriceInUSD)
open: PriceInUSD(minimum: Block_Number)
close: PriceInUSD(maximum: Block_Number)
}
count
}
}
}
Variables
{
"token": "0xdAC17F958D2ee523a2206206994597C13D831ec7",
"min_amount": "100",
"from_date_time": "2024-12-14T12:42:35Z", "to_date_time": "2024-12-14T14:42:35Z"
}
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