trade_stat

Returns DEX trades by token on Solana, where currency mint address is 9yBr75…pump or CNx1Lr…pump and side currency mint address is So1111…1112: count, unique of trade account address, sum of trade side amount, sum of trade side amount in USD, trade price, currency symbol, currency name and 4 more fields.

By kingery · saved 15 January 2025 · run 2 times · Bitquery API v2

What it returns

Filters

The query

query ($baseTokenAddresses: [String!], $time_5min_ago: DateTime, $time_15min_ago: DateTime, $time_30min_ago: DateTime, $time_1h_ago: DateTime, $time_4h_ago: DateTime, $time_24h_ago: DateTime) {
  Solana(dataset: realtime) {
    DEXTradeByTokens(
      where: {Transaction: {Result: {Success: true}}, Trade: {Currency: {MintAddress: {in: $baseTokenAddresses}}, Side: {Currency: {MintAddress: {is: "So11111111111111111111111111111111111111112"}}}}, Block: {Time: {after: $time_24h_ago}}}
    ) {
      buys_m5: count(
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_5min_ago}}, Transaction: {Result: {Success: true}}}
      )
      sells_m5: count(
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_5min_ago}}, Transaction: {Result: {Success: true}}}
      )
      buyers_m5: uniq(
        of: Trade_Account_Address
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_5min_ago}}, Transaction: {Result: {Success: true}}}
      )
      sellers_m5: uniq(
        of: Trade_Account_Address
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_5min_ago}}, Transaction: {Result: {Success: true}}}
      )
      buy_volume_m5: sum(
        of: Trade_Side_Amount
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_5min_ago}}, Transaction: {Result: {Success: true}}}
      )
      sell_volume_m5: sum(
        of: Trade_Side_Amount
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_5min_ago}}, Transaction: {Result: {Success: true}}}
      )
      buy_volume_in_usd_m5: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_5min_ago}}, Transaction: {Result: {Success: true}}}
      )
      sell_volume_in_usd_m5: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_5min_ago}}, Transaction: {Result: {Success: true}}}
      )
      buys_m15: count(
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_15min_ago}}, Transaction: {Result: {Success: true}}}
      )
      sells_m15: count(
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_15min_ago}}, Transaction: {Result: {Success: true}}}
      )
      buyers_m15: uniq(
        of: Trade_Account_Address
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_15min_ago}}, Transaction: {Result: {Success: true}}}
      )
      sellers_m15: uniq(
        of: Trade_Account_Address
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_15min_ago}}, Transaction: {Result: {Success: true}}}
      )
      buy_volume_m15: sum(
        of: Trade_Side_Amount
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_15min_ago}}, Transaction: {Result: {Success: true}}}
      )
      sell_volume_m15: sum(
        of: Trade_Side_Amount
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_15min_ago}}, Transaction: {Result: {Success: true}}}
      )
      buy_volume_in_usd_m15: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_15min_ago}}, Transaction: {Result: {Success: true}}}
      )
      sell_volume_in_usd_m15: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_15min_ago}}, Transaction: {Result: {Success: true}}}
      )
      buys_m30: count(
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_30min_ago}}, Transaction: {Result: {Success: true}}}
      )
      sells_m30: count(
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_30min_ago}}, Transaction: {Result: {Success: true}}}
      )
      buyers_m30: uniq(
        of: Trade_Account_Address
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_30min_ago}}, Transaction: {Result: {Success: true}}}
      )
      sellers_m30: uniq(
        of: Trade_Account_Address
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_30min_ago}}, Transaction: {Result: {Success: true}}}
      )
      buy_volume_m30: sum(
        of: Trade_Side_Amount
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_30min_ago}}, Transaction: {Result: {Success: true}}}
      )
      sell_volume_m30: sum(
        of: Trade_Side_Amount
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_30min_ago}}, Transaction: {Result: {Success: true}}}
      )
      buy_volume_in_usd_m30: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_30min_ago}}, Transaction: {Result: {Success: true}}}
      )
      sell_volume_in_usd_m30: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_30min_ago}}, Transaction: {Result: {Success: true}}}
      )
      buys_h1: count(
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_1h_ago}}, Transaction: {Result: {Success: true}}}
      )
      sells_h1: count(
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_1h_ago}}, Transaction: {Result: {Success: true}}}
      )
      buyers_h1: uniq(
        of: Trade_Account_Address
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_1h_ago}}, Transaction: {Result: {Success: true}}}
      )
      sellers_h1: uniq(
        of: Trade_Account_Address
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_1h_ago}}, Transaction: {Result: {Success: true}}}
      )
      buy_volume_h1: sum(
        of: Trade_Side_Amount
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_1h_ago}}, Transaction: {Result: {Success: true}}}
      )
      sell_volume_h1: sum(
        of: Trade_Side_Amount
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_1h_ago}}, Transaction: {Result: {Success: true}}}
      )
      buy_volume_in_usd_h1: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_1h_ago}}, Transaction: {Result: {Success: true}}}
      )
      sell_volume_in_usd_h1: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_1h_ago}}, Transaction: {Result: {Success: true}}}
      )
      buys_h4: count(
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_4h_ago}}, Transaction: {Result: {Success: true}}}
      )
      sells_h4: count(
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_4h_ago}}, Transaction: {Result: {Success: true}}}
      )
      buyers_h4: uniq(
        of: Trade_Account_Address
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_4h_ago}}, Transaction: {Result: {Success: true}}}
      )
      sellers_h4: uniq(
        of: Trade_Account_Address
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_4h_ago}}, Transaction: {Result: {Success: true}}}
      )
      buy_volume_h4: sum(
        of: Trade_Side_Amount
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_4h_ago}}, Transaction: {Result: {Success: true}}}
      )
      sell_volume_h4: sum(
        of: Trade_Side_Amount
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_4h_ago}}, Transaction: {Result: {Success: true}}}
      )
      buy_volume_in_usd_h4: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_4h_ago}}, Transaction: {Result: {Success: true}}}
      )
      sell_volume_in_usd_h4: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_4h_ago}}, Transaction: {Result: {Success: true}}}
      )
      buys_h24: count(
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_24h_ago}}, Transaction: {Result: {Success: true}}}
      )
      sells_h24: count(
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_24h_ago}}, Transaction: {Result: {Success: true}}}
      )
      buyers_h24: uniq(
        of: Trade_Account_Address
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_24h_ago}}, Transaction: {Result: {Success: true}}}
      )
      sellers_h24: uniq(
        of: Trade_Account_Address
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_24h_ago}}, Transaction: {Result: {Success: true}}}
      )
      buy_volume_h24: sum(
        of: Trade_Side_Amount
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_24h_ago}}, Transaction: {Result: {Success: true}}}
      )
      sell_volume_h24: sum(
        of: Trade_Side_Amount
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_24h_ago}}, Transaction: {Result: {Success: true}}}
      )
      buy_volume_in_usd_h24: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_24h_ago}}, Transaction: {Result: {Success: true}}}
      )
      sell_volume_in_usd_h24: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_24h_ago}}, Transaction: {Result: {Success: true}}}
      )
      sell_volume_in_usd_h24: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_24h_ago}}, Transaction: {Result: {Success: true}}}
      )
      Trade {
        open_h24: Price(minimum: Block_Slot, if: {Block: {Time: {after: $time_24h_ago}}})
        close_h24: Price(maximum: Block_Slot, if: {Block: {Time: {after: $time_24h_ago}}})
        open_h4: Price(minimum: Block_Slot, if: {Block: {Time: {after: $time_4h_ago}}})
        close_h4: Price(maximum: Block_Slot, if: {Block: {Time: {after: $time_4h_ago}}})
        Currency {
          Symbol
          Name
          MintAddress
        }
        Side {
          Currency {
            Symbol
            Name
            MintAddress
          }
        }
      }
    }
  }
}

Variables

{
  "$time_5min_ago": "2025-01-13T07:43:10Z",
  "$time_15min_ago": "2025-01-13T07:33:10Z",
  "$time_30min_ago": "2025-01-13T07:18:10Z",
  "$time_1h_ago": "2025-01-13T06:48:10Z",
  "$time_4h_ago": "2025-01-13T03:48:10Z",
  "$time_24h_ago": "2025-01-12T07:43:10Z",
  "baseTokenAddresses": ["9yBr75m6TBZzQqHeh1ztfv454pmqAiAvHUHdpPQcpump", "CNx1LrMuYCQx6hdfUDdWUE537sgkMj9kYb355cHZpump"]
}

Similar queries