lionx sample updated 2

Returns DEX trades by token on Solana, where side currency mint address is So1111…1112, currency mint address is Df6yfr…pump and block time after 2024-12-05, sorted by block timefield: block time, price in USD, sum of trade side amount in USD and count.

By Divyasshree · saved 5 December 2024 · Bitquery API v2

What it returns

Filters

The query

query ($token: String, $base: String, $dataset: dataset_arg_enum, $time_ago: DateTime, $interval: Int) {
  Solana(dataset: $dataset) {
    DEXTradeByTokens(
      orderBy: {ascendingByField: "Block_timefield"}
      where: {Trade: {Side: {Amount: {gt: "0"}, Currency: {MintAddress: {is: $token}}}, Currency: {MintAddress: {is: $base}}, 
        PriceAsymmetry: {le: 0.09}}, Block: {Time: {after: $time_ago}}}
    ) {
      Block {
        timefield: Time(interval: {count: $interval, in: minutes})
      }
      Trade {
        open: PriceInUSD(minimum: Block_Slot)
        min: PriceInUSD(minimum: Trade_PriceInUSD)
        max: PriceInUSD(maximum: Trade_PriceInUSD)
        close: PriceInUSD(maximum: Block_Slot)
      }
      volume: sum(of: Trade_Side_AmountInUSD)
      count
    }
  }
}

Variables

{
  "base": "Df6yfrKC8kZE3KNkrHERKzAetSxbrWeniQfyJY4Jpump",
  "token": "So11111111111111111111111111111111111111112",
  "interval": 1,
  "dataset": "combined",
  "time_ago": "2024-12-05T09:25:03.276Z",
  "time_before": "2024-12-05T09:38:00Z"
}

Similar queries