First 10 trades of a pool

Returns 10 DEX trades on Solana, where market market address is 3xdFc8…XDeA, block time since 2024-08-08 and block time till 2024-08-08, sorted by block time: buy amount, buy amount in USD, buy currency name, buy currency mint address, buy price, buy price in USD, buy account address and 14 more fields.

By Akshat · saved 8 August 2024 · run 5 times · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  Solana {
    DEXTrades(
      where: {Trade: {Market: {MarketAddress: {is: "3xdFc8hjKG9rUutSWawgzJkCx6MmiTJpbfuGR3DrXDeA"}}}, Transaction: {Result: {Success: true}}, Block: {Time: {since: "2024-08-08T13:15:00Z", till: "2024-08-08T13:24:00Z"}}}
      limit: {count: 10}
      orderBy: {ascending: Block_Time}
    ) {
      Trade {
        Buy {
          Amount
          AmountInUSD
          Currency {
            Name
            MintAddress
          }
          Price
          PriceInUSD
          Account {
            Address
            Token {
              Owner
            }
          }
        }
        Dex {
          ProtocolName
          ProtocolFamily
          ProgramAddress
        }
        Sell {
          Amount
          AmountInUSD
          Currency {
            Name
            MintAddress
          }
          Price
          PriceInUSD
          Account {
            Address
            Token {
              Owner
            }
          }
        }
        Market {
          MarketAddress
        }
      }
      Transaction {
        Signature
      }
    }
  }
}

Similar queries