IAMMIZZY reference 1min,7,50

Returns DEX trades by token on Solana, where currency mint address is HoyGFc…pump, side currency mint address is So1111…1112 and block time since 2024-12-18: currency name, currency mint address, currency symbol, price in USD, protocol name, protocol family, program address and 6 more fields.

By Divyasshree · saved 17 January 2025 · Bitquery API v2

What it returns

Filters

The query

query MyQuery($token: String!, $side_token: String!, $time_5min_ago: DateTime!, $time_7min_ago: DateTime!, $time_50min_ago: DateTime!) {
  Solana(dataset: combined) {
    DEXTradeByTokens(
      where: {Transaction: {Result: {Success: true}}, Trade: {Currency: {MintAddress: {is: $token}}, Side: {Currency: {MintAddress: {is: $side_token}}}}, Block: {Time: {since: $time_7min_ago}}}
    ) {
      Trade {
        Currency {
          Name
          MintAddress
          Symbol
        }
        start: PriceInUSD(minimum: Block_Time)
        min5: PriceInUSD(
          minimum: Block_Time
          if: {Block: {Time: {till: $time_5min_ago}}}
        )
        min50: PriceInUSD(
          minimum: Block_Time
          if: {Block: {Time: {till: $time_50min_ago}}}
        )
        end: PriceInUSD(maximum: Block_Time)
        Dex {
          ProtocolName
          ProtocolFamily
          ProgramAddress
        }
        Market {
          MarketAddress
        }
        Side {
          Currency {
            Symbol
            Name
            MintAddress
          }
        }
      }
      trades_5min: count(if: {Block: {Time: {till: $time_5min_ago}}})
      trades_50min: count(if: {Block: {Time: {till: $time_50min_ago}}})
      traded_volume_5min: sum(
        of: Trade_Side_Amount
        if: {Block: {Time: {till: $time_5min_ago}}}
      )
      buy_volume_7min: sum(
        of: Trade_Side_Amount
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {till: $time_7min_ago}}}
      )
      buy_volume_5min: sum(
        of: Trade_Side_Amount
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {till: $time_5min_ago}}}
      )
      buy_volume_50min: sum(
        of: Trade_Side_Amount
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {till: $time_50min_ago}}}
      )
      sell_volume_7min: sum(
        of: Trade_Side_Amount
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {till: $time_7min_ago}}}
      )
      sell_volume_5min: sum(
        of: Trade_Side_Amount
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {till: $time_5min_ago}}}
      )
      sell_volume_50min: sum(
        of: Trade_Side_Amount
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {till: $time_50min_ago}}}
      )
      buys_7min: count(
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {till: $time_7min_ago}}}
      )
      buys_5min: count(
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {till: $time_5min_ago}}}
      )
      buys_50min: count(
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {till: $time_50min_ago}}}
      )
      sells_7min: count(
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {till: $time_7min_ago}}}
      )
      sells_5min: count(
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {till: $time_5min_ago}}}
      )
      sells_50min: count(
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {till: $time_50min_ago}}}
      )
    }
  }
}

Variables

{
  "token": "HoyGFcpL4UETLVFoHMtr2hmbmv2qHCXu984qu56epump",
  "side_token": "So11111111111111111111111111111111111111112",
 "time_5min_ago":"2024-12-18T11:16:53Z",
  "time_7min_ago": "2024-12-18T11:21:53Z",
  "time_50min_ago": "2024-12-18T12:14:53Z"
}

Similar queries