Trade metrics for a particular pair on Solana network

Returns 10 DEX trades on Solana, where buy currency mint address is So1111…1112 and sell currency mint address is 8KhfhN…Pt28, sorted by block time field, highest first: block time, median of trade buy price, count, sum of trade buy amount and sum of trade sell amount.

By Odin · saved 24 May 2024 · run 2 times · Bitquery API v2

What it returns

Filters

The query

query MyQuery { 
  Solana {
    DEXTrades(
      limit: {count: 10}
      orderBy: {descendingByField: "Block_Time_Field"}
      where: {Trade: {Buy: {Currency: {MintAddress: {is: "So11111111111111111111111111111111111111112"}}}, Sell: {Currency: {MintAddress: {is: "8KhfhNHsy62wbbRRSYBx7pameubiQ9guYn4KyD74Pt28"}}}}}
    ) {
      Block {
        Time_Field: Time(interval: {in: minutes, count: 5})
      }
      Price: median(of: Trade_Buy_Price)
      Unique_Buyers: count(distinct: Trade_Buy_Account_Address)
      Unique_sellers: count(distinct: Trade_Sell_Account_Address)
      total_transactions: count(distinct: Transaction_Signature)
      buy_volume: sum(of: Trade_Buy_Amount)
      sell_volume: sum(of: Trade_Sell_Amount)
    }
  }
}

Similar queries