save_

Returns the latest DEX trades by token on Solana, where currency mint address is not 111111…1111, currency mint address is Cvfiq4…pump and DEX protocol name is pump: block time, account owner, side type, side amount, side amount in USD, side account owner, price in USD and 12 more fields.

By Omkar_BQ · saved 15 October 2024 · run 4 times · Bitquery API v2

What it returns

Filters

The query

query PumpTradesByTokens {
  Solana(dataset: realtime, network: solana) {
    DEXTradeByTokens(
      where: {Trade: {Dex: {ProtocolName: {is: "pump"}}, Currency: {MintAddress: {not: "11111111111111111111111111111111", is: "Cvfiq4ECLgsi8k4JPt48b5LGzwu3iQJiSJT1knpNpump"}}}, Transaction: {Result: {Success: true}}, Block: {Time: {since: "2024-10-15T15:38:35Z", till: "2024-10-15T15:45:17Z"}}}
      orderBy: {descending: Block_Time, descendingByField: "Transaction_Index"}
    ) {
      Block {
        Time
      }
      Trade {
        Account {
          Owner
        }
        Side {
          Type
          Amount
          AmountInUSD
          Account {
            Owner
          }
        }
        PriceInUSD
        Price
        Market {
          MarketAddress
        }
        Currency {
          Uri
          Symbol
          Name
          MintAddress
        }
        Amount
        AmountInUSD
      }
      Transaction {
        Signature
        Fee
        Index
        FeeInUSD
      }
    }
  }
}

Similar queries