Get latest transactions and aggregate to get sell and buy amounts

I’m just thinking, we could use the candle data for this instead (like you proposed here), and look at the open and close for each token. This does not give the exact amounts but it does tell me whether there were more buys than sells. Although I’m not entirely sure what the exact query would have to look like, since:

  • I don’t need all tokens just those traded recently
  • that query does not always seem to return the last candle

Basically, I’m trying to use the query to find tokens that are getting more buys than sells in the last X minutes