buy-sell-transactions

Returns DEX trades by token on Solana, where currency mint address is DysLyg…pump, DEX protocol name is pump and block time since 2024-08-19: currency name, currency symbol, currency mint address, protocol name, protocol family, side type, sum of trade side amount in USD and count.

By Kshitij Mahajan · saved 19 August 2024 · run 5 times · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  Solana {
    DEXTradeByTokens(
      where: {Trade: {Currency: {MintAddress: {is: "DysLygS2zA45nymSvmxBtGqLPimksemMQbHAuL3dpump"}}, Dex: {ProtocolName: {is: "pump"}}}, Block: {Time: {since: "2024-08-19T04:38:00Z", till: "2024-08-19T04:51:00Z"}}, Transaction: {Result: {Success: true}}}
    ) {
      Trade {
        Currency {
          Name
          Symbol
          MintAddress
        }
        Dex {
          ProtocolName
          ProtocolFamily
        }
        Side {
          Type
        }
      }
      TradeVolume: sum(of: Trade_Side_AmountInUSD)
      TradeBuyVolume: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: buy}}}}
      )
      TradeSellVolume: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: sell}}}}
      )
      TradeBuyCount: count
      TradeSellCount: count
    }
  }
}

Similar queries