Pair DEX list

Returns DEX trades by token on Solana, where currency mint address is EKpQGS…zcjm, side currency mint address is JUPyiw…DvCN and block time after 2024-08-14, sorted by amount, highest first: protocol family, protocol name, price in USD, sum of trade amount, unique of trade side currency mint address and count.

By Nadia · saved 21 August 2024 · run 5 times · Bitquery API v2

What it returns

Filters

The query

query ($token: String, $base: String, $time_10min_ago: DateTime, $time_1h_ago: DateTime, $time_3h_ago: DateTime) {
  Solana(aggregates: only) {
    DEXTradeByTokens(
      orderBy: {descendingByField: "amount"}
      where: {Trade: {Currency: {MintAddress: {is: $token}}, Side: {Amount: {gt: "0"}, Currency: {MintAddress: {is: $base}}}}, Transaction: {Result: {Success: true}}, Block: {Time: {after: $time_3h_ago}}}
    ) {
      Trade {
        Dex {
          ProtocolFamily
          ProtocolName
        }
        price_last: PriceInUSD(maximum: Block_Slot)
        price_10min_ago: PriceInUSD(
          maximum: Block_Slot
          if: {Block: {Time: {before: $time_10min_ago}}}
        )
        price_1h_ago: PriceInUSD(
          maximum: Block_Slot
          if: {Block: {Time: {before: $time_1h_ago}}}
        )
        price_3h_ago: PriceInUSD(minimum: Block_Slot)
      }
      amount: sum(of: Trade_Amount)
      pairs: uniq(of: Trade_Side_Currency_MintAddress)
      trades: count
    }
  }
}

Variables

{
  "token": "EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm",
  "base": "JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN",
  "time_10min_ago": "2024-08-14T12:00:00Z",
  "time_1h_ago": "2024-08-14T11:00:00Z",
  "time_3h_ago": "2024-08-14T09:00:00Z"
}

Similar queries