pumpfun_check

Returns 10 DEX trades by token on Solana, where DEX program address is 6EF8rr…wF6P and block time since 2024-08-09, sorted by total buy volume, highest first: currency mint address, currency name, currency symbol, side currency name, side currency mint address, side currency symbol, sum of trade side amount in USD and transaction signature.

By George · saved 9 August 2024 · run 14 times · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  Solana {
    DEXTradeByTokens(
      where: {Trade: {Dex: {ProgramAddress: {is: "6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P"}}}, Transaction: {Result: {Success: true}}, Block: {Time: {since: "2024-08-09T04:06:00Z"}}}
      limit: {count: 10}
      orderBy: {descendingByField: "total_buy_volume"}
    ) {
      Trade {
        Currency {
          MintAddress
          Name
          Symbol
        }
        Side {
          Currency {
            Name
            MintAddress
            Symbol
          }
        }
      }
      total_traded_volume: sum(of: Trade_Side_AmountInUSD)
      total_buy_volume: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: sell}}}}
      )
      total_sell_volume: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: buy}}}}
      )
      Transaction {
        Signature
      }
    }
  }
}

Similar queries