Interval_Test

Returns the latest 100 DEX trades by token on Solana, where currency mint address is TNSRxc…JAS6, side currency mint address is So1111…1112 and trade price asymmetry is below 0.1: block time, sum of trade amount, trade price and count.

By Popqwe · saved 11 March 2025 · run 6 times · Bitquery API v2

What it returns

Filters

The query

{
  Solana(dataset: archive) {
    DEXTradeByTokens(
      orderBy: { descendingByField: "Block_Timefield" }
      where: {
        Trade: {
          Currency: {
            MintAddress: { is: "TNSRxcUxoT9xBG3de7PiJyTDYu7kskLqcpddxnEJAS6" }
          }
          Side: {
            Currency: {
              MintAddress: { is: "So11111111111111111111111111111111111111112" }
            }
          }
          PriceAsymmetry: { lt: 0.1 }
        }
      }
      limit: { count: 100 }
    ) {
      Block {
        Timefield: Time(interval: { in: seconds, count: 1 })
      }
      volume: sum(of: Trade_Amount)
      Trade {
        high: Price(maximum: Trade_Price)
        low: Price(minimum: Trade_Price)
        open: Price(minimum: Block_Slot)
        close: Price(maximum: Block_Slot)
      }
      count
    }
  }
}

Variables

{
  "token": "6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN",
  "time_ago": "2025-03-08T01:19:03Z",
  "interval": 1,
  "dataset": "realtime"
}

Similar queries