volume with intervals tron
Returns DEX trades by token on Tron, where currency smart contract is TR7NHq…Lj6t, 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 TR7NHq…Lj6t
- 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) {
Tron(dataset: archive) {
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": "TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t",
"min_amount": "100",
"from_date_time": "2024-12-14T12:42:35Z", "to_date_time": "2024-12-14T14:42:35Z"
}
Similar queries
- AfricaCryptoChainx · Ethereum · DEXTradeByTokens
- TLeVfrdym8RoJreJ23dAGyfJDygRtiWKBZ · Tron · DEXTradeByTokens
- UniversalSearch EVM · Ethereum · DEXTradeByTokens
- K2DhBqHBXEjBMwXm · Tron · DEXTradeByTokens
- Historical tron token trades beyond 30 days · Tron · DEXTradeByTokens