volume with intervals evm
Returns DEX trades by token on Ethereum, where currency smart contract is 0xdAC1…1ec7, block time after 2024-12-14 and block time before 2024-12-14, sorted by block OHLC interval: block time, sum of trade amount in USD and median of trade price in USD.
What it returns
- block time
- sum of trade amount in USD
- median of trade price in USD
Filters
- currency smart contract is 0xdAC1…1ec7
- block time after 2024-12-14
- block time before 2024-12-14
- trade amount in USD is above 100
The query
query MyQuery($token: String, $from_date_time: DateTime, $to_date_time: DateTime, $min_amount: String) {
EVM(dataset: combined, network: eth) {
aggregatedVolume: DEXTradeByTokens(
where: {Trade: {Currency: {SmartContract: {is: $token}}, AmountInUSD: {gt: $min_amount}}, Block: {Time: {after: $from_date_time, before: $to_date_time}}}
orderBy: {ascendingByField: "Block_OHLC_interval"}
) {
Block {
OHLC_interval: Time(interval: {in: minutes, count: 10})
}
totalVolumeInUSD: sum(of: Trade_AmountInUSD)
price_median: median(of: Trade_PriceInUSD)
}
}
}
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