price of a token (historical)

Returns the latest 10000 DEX trades by token on Solana, where currency mint address is 8fdgdV…JyDi, side currency mint address is So1111…1112 and trade price asymmetry is below 0.1: block time, sum of trade amount, price in USD and count.

By alex · saved 1 March 2025 · run 7 times · Bitquery API v2

What it returns

Filters

The query

{
  Solana(dataset: combined) {
    DEXTradeByTokens(
      orderBy: { descendingByField: "Block_Timefield" }
      where: {
        Trade: {
          Currency: {
            MintAddress: { is: "8fdgdVkwGEdvfsJ5Qs5AMctTXXJ8mhUZcGm7RRmTJyDi" }
          }
          Side: {
            Currency: {
              MintAddress: { is: "So11111111111111111111111111111111111111112" }
            }
          }
          PriceAsymmetry: { lt: 0.1 }
        }
      }
      limit: { count: 10000 }
    ) {
      Block {
        Timefield: Time(interval: { in: minutes, count: 1 })
      }
      volume: sum(of: Trade_Amount)
      Trade {
        high: PriceInUSD(maximum: Trade_Price)
        low: PriceInUSD(minimum: Trade_Price)
        open: PriceInUSD(minimum: Block_Slot)
        close: PriceInUSD(maximum: Block_Slot)
      }
      count
    }
  }
}

Similar queries