test points OHLC limit 100

Returns the latest 100 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 2 times · 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}}}
      limit: {count: 100}
    ) {
      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