test points OHLC

Returns the latest DEX trades by token on Solana, where currency mint address is HaP8r3…7Ut1, side currency mint address is So1111…1112 and block time after 2022-03-09: block time, sum of trade amount, trade price and count.

By Divyasshree · saved 14 January 2025 · run 1 time · Bitquery API v2

What it returns

Filters

The query

query CandlesticksQuery($baseTokenMintAddress: String!, $quoteTokenMintAddress: String!, $fromTimefield: DateTime!, $toTimefield: DateTime!, $timeIntervalIn: OLAP_DateTimeIntervalUnits!, $timeIntervalCount: Int!) {
  Solana(dataset: combined) {
    DEXTradeByTokens(
      orderBy: {descendingByField: "Block_Timefield"}
      where: {Trade: {Currency: {MintAddress: {is: $baseTokenMintAddress}}, Side: {Currency: {MintAddress: {is: $quoteTokenMintAddress}}}}, Transaction: {Result: {Success: true}}, Block: {Time: {after: $fromTimefield, before: $toTimefield}}}
    ) {
      Block {
        Timefield: Time(interval: {in: $timeIntervalIn, count: $timeIntervalCount})
      }
      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

{
  "baseTokenMintAddress": "HaP8r3ksG76PhQLTqR8FYBeNiQpejcFbQmiHbg787Ut1",
  "quoteTokenMintAddress": "So11111111111111111111111111111111111111112",
  "fromTimefield":"2022-03-09T00:00:00Z",
  "toTimefield":"2025-01-15T00:00:00Z",
  "timeIntervalIn": "hours",
  "timeIntervalCount":1
  
}

Similar queries