spike but no results

Returns 50 DEX trades by token on Solana, where DEX protocol family is raydium_amm, block time since 2025-02-01 and block time till 2025-02-01, sorted by volume spike, highest first: currency name, currency symbol, currency mint address and sum of trade side amount in USD.

By Zaff · saved 1 February 2025 · run 12 times · Bitquery API v2

What it returns

Filters

The query

query TokenVolumeSpike($spike_start: DateTime!, $spike_end: DateTime!, $period_start: DateTime!) {
  Solana {
    DEXTradeByTokens(
      where: {
        Block: {Time: {since: $period_start, till: $spike_end}},
        Trade: {Dex: {ProtocolFamily: {is: "raydium_amm"}}}
      }
      orderBy: {descendingByField: "volume_spike"}
      limit: {count: 50}
    ) {
      Trade {
        Currency {
          Name
          Symbol
          MintAddress
        }
      }
      volume_spike: sum(
        of: Trade_Side_AmountInUSD
        if: {Block: {Time: {since: $spike_start, till: $spike_end}}}
      )
      volume_previous: sum(
        of: Trade_Side_AmountInUSD
        if: {Block: {Time: {since: $period_start, till: $spike_start}}}
      )
    }
  }
}

Variables

{
  "spike_start": "2025-02-01T13:55:00Z",
  "spike_end": "2025-02-01T14:00:00Z",
  "period_start": "2025-02-01T11:55:00Z"
}

Similar queries