Custom Query
Returns 15 DEX trades by token on Solana, where currency mint address is not So1111…1112 or EPjFWd…Dt1v, sorted by total trades, highest first: currency name, currency mint address, currency symbol, URI, price in USD, protocol name, protocol family and 3 more fields.
What it returns
- currency name
- currency mint address
- currency symbol
- URI
- price in USD
- protocol name
- protocol family
- program address
- count
- sum of trade side amount in USD
Filters
- currency mint address is not So1111…1112 or EPjFWd…Dt1v
The query
query MyQuery($start: DateTime, $end: DateTime) {
Solana {
DEXTradeByTokens(
where: {Transaction: {Result: {Success: true}}, Block: {Time: {after: $start, before: $end}}, Trade: {Currency: {Uri: {not: ""}, MintAddress: {endsWith: "pump", notIn: ["So11111111111111111111111111111111111111112", "EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v"]}}}}
orderBy: {descendingByField: "total_trades"}
limit: {count: 15}
) {
Trade {
Currency {
Name
MintAddress
Symbol
Uri
}
start: PriceInUSD(minimum: Block_Time)
end: PriceInUSD(maximum: Block_Time)
Dex {
ProtocolName
ProtocolFamily
ProgramAddress
}
}
makers: count(distinct: Transaction_Signer)
total_trades: count
total_traded_volume: sum(of: Trade_Side_AmountInUSD)
total_buy_volume: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: buy}}}}
)
total_sell_volume: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: sell}}}}
)
total_buys: count(if: {Trade: {Side: {Type: {is: buy}}}})
total_sells: count(if: {Trade: {Side: {Type: {is: sell}}}})
}
}
}
Variables
{
"$start": "2025-02-04T20:33:34.700Z",
"$end": "2025-02-05T20:33:34.700Z",
"$count": 10
}
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