gt in where- doesnt work for ohlc
Returns the latest 300 DEX trades by token on Solana, where currency mint address is FPK9eS…pump, DEX program address is 6EF8rr…wF6P and side amount in USD is above 10: block time, sum of trade amount, price in USD and count.
What it returns
- block time
- sum of trade amount
- price in USD
- count
Filters
- currency mint address is FPK9eS…pump
- DEX program address is 6EF8rr…wF6P
- side amount in USD is above 10
The query
{
Solana {
DEXTradeByTokens(
limit: {count: 300}
orderBy: {descendingByField: "Block_Timefield"}
where: {Trade: {Currency: {MintAddress: {is: "FPK9eSsSAx7MhjrxTgYG3E7N97sUQB2UVAzKgghCpump"}}, Dex: {ProgramAddress: {is: "6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P"}}, Side: {AmountInUSD: {gt: "10"}}}, Transaction: {Result: {Success: true}}}
) {
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
- ANSEM daily traders, June 16 to 26, 2026 · Solana · DEXTradeByTokens
- ANSEM swaps per hour, June 27, 2026 · Solana · DEXTradeByTokens
- FOMO App: Top Tokens Bought, Last Hour (Solana) · Solana · DEXTradeByTokens
- FOMO App: Most Active Wallets, Last Hour (Solana) · Solana · DEXTradeByTokens
- Buys, Sells, BuyVolume, SellVolume, Makers, TotalTradedVolume, PriceinUSD for solana token pair · Solana · DEXTradeByTokens