LargestPurchasesOnPump

Returns 2 DEX trades on Solana, where buy currency mint address is not 111111…1111, DEX protocol name is pump and block time after 2024-01-24, sorted by trades, highest first: count, sum of trade buy amount in USD and sum of trade sell amount in USD.

By Jacob · saved 26 January 2025 · Bitquery API v2

What it returns

Filters

The query

query LargestPurchasesOnPump($startTime: DateTime) {
  Solana(dataset: realtime) {
    DEXTrades(
      where: {Block: {Time: {after: $startTime}}, Trade: {Dex: {ProtocolName: {is: "pump"}}, Buy: {Currency: {MintAddress: {notIn: "11111111111111111111111111111111"}}, PriceInUSD: {gt: 0.00002}}}}
      limit: {count: 2}
      orderBy: {descendingByField: "trades"}
    ) {
      # trades: count(distinct: Block_Time, if: {Block: {Time: {after: $startTime}}})
      # Trade {
      #   Buy {
      #     Currency {
      #       MintAddress
      #     }
      #   }
      # }
      
       # token_address: Trade_Buy_Currency_MintAddress # Adres tokena
      # token_symbol: Trade_Buy_Currency_Symbol # Symbol tokena
      trades: count # Liczba transakcji
      buy_volume: sum(
        of: Trade_Buy_AmountInUSD # Łączna wartość zakupów w USD
      )
      sell_volume: sum(
        of: Trade_Sell_AmountInUSD # Łączna wartość sprzedaży w USD
      )
    }
  }
}

Variables

{
  "startTime": "2024-01-24T17:00:00Z"
}

Similar queries