volume_combine_db

Returns DEX trades by token on Solana, where currency mint address is 7n3h8v…pump, side currency mint address is So1111…1112 and market market address is 5VvgYf…u39X, sorted by block time: sum of trade side amount in USD, count and block time.

By Aleksey · saved 2 January 2025 · run 4 times · Bitquery API v2

What it returns

Filters

The query

query MyQuery($address: String!, $pair_address: String!, $time_24h_ago: DateTime!) {
  Solana(dataset: archive aggregates: only) {
    DEXTradeByTokens(
      orderBy: {ascendingByField: "Block_Time"}
      where: {Transaction: {Result: {Success: true}}, Trade: {Currency: {MintAddress: {is: $address}}, Side: {Currency: {MintAddress: {is: "So11111111111111111111111111111111111111112"}}}, Market: {MarketAddress: {is: $pair_address}}}, Block: {Time: {till: $time_24h_ago}}}
    ) {
      traded_volume_total: sum(of: Trade_Side_AmountInUSD)
      count
      Block {
        Time(interval: {in: hours})
      }
    }
  }
}

Variables

{
  "address": "7n3h8vKVtcVo9Nj1D2DAo758J8BiZWNMemwZkiKdpump",
  "pair_address": "5VvgYfN9jZYYGLZouK7hqeP39867uikG5H6QhKTMu39X",
  "time_24h_ago": "2025-01-02T08:03:53Z"
}

Similar queries