Top Bought/Sold/Trending/Volatility Tokens on Eth
Why these multiple combined subscription results in alternating, but never both at the same query, or even allows more than 2 combined queries
What it returns
- currency name
- currency symbol
- sum of trade side amount in USD
- standard deviation of trade price in USD
- sum of trade amount in USD
- count
Filters
- block time since 2024-12-24
- block time since 2025-02-06
The subscription
subscription MyQuery {
EVM(network: eth) {
topBought: DEXTradeByTokens(
where: {Block: {Time: {since: "2024-12-24T08:20:00Z"}}}
limit: {count: 3}
orderBy: {descendingByField: "total_bought"}
) {
Trade {
Currency {
Name
Symbol
}
}
total_bought: sum(of:Trade_Side_AmountInUSD if:{Trade:{Side:{Type:{is:buy}}}})
}
topSold: DEXTradeByTokens(
where: {Block: {Time: {since: "2024-12-24T08:20:00Z"}}}
limit: {count: 3}
orderBy: {descendingByField: "total_sold"}
) {
Trade {
Currency {
Name
Symbol
}
}
total_sold: sum(of:Trade_Side_AmountInUSD if:{Trade:{Side:{Type:{is:sell}}}})
}
topVolatility: DEXTradeByTokens(
where: {Block: {Time: {since: "2024-12-24T08:20:00Z"}}}
limit: {count: 3}
orderBy: {descendingByField: "total_volatility"}
) {
Trade {
Currency {
Name
Symbol
}
}
total_volatility: standard_deviation(of:Trade_PriceInUSD)
}
topTrending: DEXTradeByTokens(
where: {Block: {Time: {since: "2025-02-06T20:00:00Z"}}}
limit: {count: 3}
orderBy: {descendingByField: "volume"}
) {
Trade {
Currency {
Symbol
Name
}
}
volume: sum(of: Trade_AmountInUSD)
traders: count(distinct: Trade_Buyer)
tradeCount: count
}
}
}
Similar queries
- Stablecoin Depeg tracking Stream for evm · Ethereum · DEXTradeByTokens
- realtime trades EVM -subscription · Ethereum · DEXTradeByTokens
- EVM chain currency details stream · Ethereum · DEXTradeByTokens
- Real time price stream for tokens on Ethereum · Ethereum · DEXTradeByTokens
- Top Sold Tokens on Eth · Ethereum · DEXTradeByTokens