qqqqqq

Returns DEX trades on Solana, where buy currency mint address is So1111…1112, DEX protocol name is pump and DEX protocol name is raydium_amm: signer, unique of trade buy currency mint address, count, sum of trade sell amount in USD, unique of trade sell currency mint address and sum of trade buy amount in USD.

By qsdsdds · saved 9 February 2025 · run 1 time · Bitquery API v2

What it returns

Filters

The query

{
  Solana {
    buy: DEXTrades(
      where: {
        Block: {
            Time: {
                since: "2025-02-09T00:00:00Z"
            }
        }
        Transaction: {
          Signer: {
            #is: "niggerd597QYedtvjQDVHZTCCGyJrwHNm2i49dkm5zS"
          }
          Result: {
            Success: true
          }
        }, 
        Trade: {
          Dex: {
            ProtocolName: {
              is: "pump"
            }
          }, 
          Buy: {
            Amount: {
              ge: "1000000"
            }
          }
          Sell: {
            Amount: {
              gt: "0"
            }, 
            Currency: {
              Native: true
            }
          }
        }
      }
    ) {
      Transaction {
        Signer
      }
      tokens: uniq(
        of: Trade_Buy_Currency_MintAddress
        selectWhere: {
          le: "100"
        }
      )
      txs: count(
        selectWhere: {
          le: "100"
        }
      )
      volume_usd: sum(
        of: Trade_Sell_AmountInUSD
        selectWhere: {
          ge: "1000"
        }
      )
    }
    sell: DEXTrades(
      where: {
        Block: {
            Time: {
                since: "2025-02-09T00:00:00Z"
            }
        }
        Transaction: {
          Signer: {
            #is: "niggerd597QYedtvjQDVHZTCCGyJrwHNm2i49dkm5zS"
          }
          Result: {Success: true}
        }, 
        Trade: {
          Dex: {
            ProtocolName: {is: "raydium_amm"}
          },
          Buy: {
            Amount: {
              gt: "0"
            }
            Currency: {
              MintAddress: {
                is: "So11111111111111111111111111111111111111112"
              }
            }
          }
          Sell: {
            PriceInUSD: {
              le: 0.8
            }
          }
        }
      }
    ) {
      Transaction {
        Signer
      }
      tokens: uniq(
        of: Trade_Sell_Currency_MintAddress
        selectWhere: {
          le: "100"
        }
      )
      txs: count(
        selectWhere: {
          le: "100"
        }
      )
      volume_usd: sum(
        of: Trade_Buy_AmountInUSD
        selectWhere: {
          ge: "10000"
        }
      )
    }
  }
}

Similar queries