Pumpfun coins by count

Returns 10 DEX trades by token on Solana, where DEX protocol name is pump, sorted by total USD, highest first: currency symbol, currency name, currency mint address, sum of trade side amount, sum of trade side amount in USD and count.

By Aleksey · saved 21 June 2024 · run 9 times · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  Solana {
    DEXTradeByTokens(
      limit: {
        count: 10
      }
      orderBy: {
        descendingByField: "total_usd"
      }
      where: { 
        
        Trade: {
          Side: {Currency: {
            Native: true
          }}
          Dex: {ProtocolName: {is: "pump"}}}, 
        Transaction: {Result: {Success: true}}}
    ) {
      
      Trade {
        Currency {
          Symbol
          Name
          MintAddress
        }
      }
      
      sol_buy: sum(of: Trade_Side_Amount if: {Trade: {Side: {Type: {is: buy}}}})
      sol_sold: sum(of: Trade_Side_Amount if: {Trade: {Side: {Type: {is: sell}}}})
      total_usd: sum(of: Trade_Side_AmountInUSD)
      trades: count
    }
  }
}

Similar queries