historical

Returns DEX trades by token on Solana, where currency mint address is CzLSuj…pump, side currency mint address is So1111…1112 and DEX protocol family is Raydium, sorted by block time: block time, transaction signature, market address, protocol name, protocol family, amount in USD, price in USD and 8 more fields.

By RAPHAEL CANYASSE · saved 31 October 2024 · run 1 time · Bitquery API v2

What it returns

Filters

The query

query ($token: String, $base: String, $date: String) {
  Solana {
    DEXTradeByTokens(
      orderBy: {ascendingByField: "Block_Time"}
          where: {Trade: {Currency: {MintAddress: {is: $token}}, Side: {Currency: {MintAddress: {is: $base}}}, Dex: {ProtocolFamily: {is: "Raydium"}}}, Block: {Date: {is: $date}}}
    ) {
      Block {
        Time
      }
      Transaction {
        Signature
      }
      Trade {
        Market {
          MarketAddress
        }
        Dex {
          ProtocolName
          ProtocolFamily
        }
        AmountInUSD
        PriceInUSD
        Price
        Amount
        Side {
          Type
          Currency {
            Symbol
            MintAddress
            Name
          }
          AmountInUSD
          Amount
        }
      }
    }
  }
}

Variables

{
  "base": "So11111111111111111111111111111111111111112",
  "token": "CzLSujWBLFsSjncfkh59rUFqvafWcY5tzedWJSuypump",
  "date": "2024-10-25"
}

Similar queries