elliot oHLC sample

Returns 1000 DEX trades by token on Solana, where currency mint address is EKpQGS…zcjm, side currency mint address is So1111…1112, EPjFWd…Dt1v or 3 more and block time after 2024-10-04, sorted by block timefield: block time, quantile of trade price in USD, average of trade price in USD and sum of trade side amount.

By Divyasshree · saved 4 October 2024 · Bitquery API v2

What it returns

Filters

The query

query ($token: String, $time_ago: DateTime) {
  Solana {
    DEXTradeByTokens(
      orderBy: {ascendingByField: "Block_timefield"}
      where: {Trade: {Currency: {MintAddress: {is: $token}}, Side: {Currency: {MintAddress: {in: ["", "So11111111111111111111111111111111111111112", "EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v", "Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB", "JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN", "EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm"]}}}}, Block: {Time: {after: $time_ago}}}
      limit: {count: 1000}
    ) {
      Block {
        timefield: Time(interval: {count: 5, in: minutes})
      }
      min: quantile(of: Trade_PriceInUSD, level: 0.05)
      max: quantile(of: Trade_PriceInUSD, level: 0.95)
      close: average(of: Trade_PriceInUSD)
      open: average(of: Trade_PriceInUSD)
      volume: sum(of: Trade_Side_Amount)
    }
  }
}

Variables

{
  "token": "EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm",
  "time_ago": "2024-10-04T00:18:22Z"
}

Similar queries