gt in select where - doesn't work
Returns the latest DEX trades by token on Solana, where currency mint address is FPK9eS…pump, DEX program address is 6EF8rr…wF6P and block time since 2024-11-12: trade amount, amount in USD, currency name, currency symbol, currency mint address, price in USD, side currency name and 8 more fields.
What it returns
- trade amount
- amount in USD
- currency name
- currency symbol
- currency mint address
- price in USD
- side currency name
- side amount in USD
- side amount
- side account address
- side token owner
- account address
- token owner
- block time
- transaction signature
Filters
- currency mint address is FPK9eS…pump
- DEX program address is 6EF8rr…wF6P
- block time since 2024-11-12
- block time till 2024-11-12
The query
query MyQuery {
Solana {
DEXTradeByTokens(
orderBy: {descending: Block_Time}
where: {Trade: {Currency: {MintAddress: {is: "FPK9eSsSAx7MhjrxTgYG3E7N97sUQB2UVAzKgghCpump"}}, Dex: {ProgramAddress: {is: "6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P"}}}, Block: {Time: {since: "2024-11-12T11:40:00Z", till: "2024-11-12T11:41:00Z"}}, Transaction: {Result: {Success: true}}}
) {
Trade {
Amount
AmountInUSD
Currency {
Name
Symbol
MintAddress
}
PriceInUSD
Side {
Currency {
Name
}
AmountInUSD(selectWhere:{gt:"10"})
Amount
Account {
Address
Token {
Owner
}
}
}
Account {
Address
Token {
Owner
}
}
}
Block {
Time
}
Transaction {
Signature
}
}
}
}
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