Trade pair OHLC

Returns DEX trades by token on Solana, where side currency mint address is JUPyiw…DvCN, currency mint address is EKpQGS…zcjm and trade amount is above 0, sorted by block time: block time, price in USD and sum of trade amount in USD.

By Aleksey · saved 14 August 2024 · run 13 times · Bitquery API v2

What it returns

Filters

The query

query($token: String, $base: String) {
  Solana(aggregates: no) {
    DEXTradeByTokens(
      orderBy: {ascendingByField: "Block_Time"}
      where: {
        Trade: {
          Amount: {gt: "0"},
          Side: {
            Amount: {gt: "0"},
            Currency: {
              MintAddress: {
              is: $base
            }
            }
          }
          Currency: {
            MintAddress: {
              is: $token
            }
          }
        }
        Transaction: {Result: {Success: true}}
      }
    	
    ) {
      
      Block {
        Time(interval: {count: 5, in: minutes})
      }
      
      Trade {        
        open: PriceInUSD(minimum: Block_Slot)
        close: PriceInUSD(maximum: Block_Slot)
        max: PriceInUSD(maximum: Trade_PriceInUSD)
        min: PriceInUSD(minimum: Trade_PriceInUSD)
      }

      volume: sum(of: Trade_AmountInUSD)
    }
  }
}

Variables

{
  "token": "EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm",
  "base": "JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN"
}

Similar queries