Anomaly PriceInUSD

Returns the latest 1000000 DEX trades by token on Solana, where currency mint address is 2qEHjD…pump, side currency mint address is So1111…1112 and trade price in USD is above 100: block time, sum of trade side amount in USD, protocol family, protocol name, price in USD and count.

By Aleksey · saved 27 December 2024 · run 6 times · Bitquery API v2

What it returns

Filters

The query

{
  Solana(dataset: archive) {
    DEXTradeByTokens(
      orderBy: {descendingByField: "Block_Timefield"}
      where: {Trade: {
        PriceInUSD: {
          gt: 100
        }
        
        Currency: {MintAddress: {is: "2qEHjDLDLbuBgRYvsxhc5D6uDWAivNFZGan56P1tpump"}}, Side: {Currency: {MintAddress: {is: "So11111111111111111111111111111111111111112"}}}}}
      limit: {count: 1000000}
    ) {
      Block {
        Timefield: Time(interval: {in: minutes, count: 15})
      }
      volume: sum(of: Trade_Side_AmountInUSD)
      Trade {
        
        Dex {
          ProtocolFamily
          ProtocolName
        }
        
        high: PriceInUSD(maximum: Trade_Price)
        low: PriceInUSD(minimum: Trade_Price)
        open: PriceInUSD(minimum: Block_Slot)
        close: PriceInUSD(maximum: Block_Slot)
      }
      count
    }
  }
}

Similar queries