Getting Last, 24h, 7d dextrade prices in one query?

GraphQL API
1

looking to get Last, 24h, 7d, prices for a contract in a single query. I’d love to not request a full week’s worth of trades to get it. I can see how to get Last and 7d in a single query (minimum, maximum) but the 24h one is tripping me up

is it possible?

here is what I have so far:

{
  ethereum(network: ethereum)
  {
        dexTrades(
          options: { desc: ["trades"], limit: 2, limitBy: { each: "sellCurrency.address", limit: 1 }, 
            offset: 0 },
            date: { since: "2021-06-01" till: "2021-06-08" }
                        sellCurrency: { in: ["0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0"] }
                        buyCurrency: { in: ["0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2"] })
    {

          trades: count

          exchange {
              fullName
          }


          sellCurrency {
              address
              symbol
          }


          buyCurrency {
              address
              symbol
          }

          ago7d_price: minimum(of: time, get: price)
          close_price: maximum(of: time, get: price)
        }
    }
}
2

Use Time Filter

{
  ethereum(network: ethereum) {
    dexTrades(
      options: {desc: ["trades"], limit: 2, limitBy: {each: "sellCurrency.address", limit: 1}, offset: 0}
      time: {since: "2021-06-01T00:00:00", till: "2021-06-02T00:00:00"}
      sellCurrency: {in: ["0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0"]}
      buyCurrency: {in: ["0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2"]}
    ) {
      trades: count
      exchange {
        fullName
      }
      sellCurrency {
        address
        symbol
      }
      buyCurrency {
        address
        symbol
      }
      ago7d_price: minimum(of: time, get: price)
      close_price: maximum(of: time, get: price)
    }
  }
}
3

this isn’t quite what i’m going after.

Imagine I need N different prices in a single query, but don’t want to return a huge set of results. For example 30d price, 7d price, 24h price, last price.

minimum and maximum can get me two of the above for a given date range, but how do I get values in between?

4

As I understand if you asking for a query that returns the price for the last 30d, 7d, 24h, and last trade price in one API call… I don’t think is possible.

Also what you mean by price in between… can you explain to me using an example.

5

Please also check this