top100sol
Returns 100 DEX trades by token on Solana, where DEX protocol family is not pump and block time after 2025-02-01, sorted by USD, highest first: currency symbol, currency name, currency mint address, side currency symbol, side currency name, side currency mint address, price in USD and 5 more fields.
What it returns
- currency symbol
- currency name
- currency mint address
- side currency symbol
- side currency name
- side currency mint address
- price in USD
- unique of trade DEX program address
- sum of trade side amount
- sum of trade side amount in USD
- unique of trade account owner
- count
Filters
- DEX protocol family is not pump
- block time after 2025-02-01
The query
query ($time_ago: DateTime, $wsol: String!, $usdc: String!, $usdt: String!) {
Solana {
DEXTradeByTokens(
where: {Transaction: {Result: {Success: true}}, Block: {Time: {after: $time_ago}}, Trade: {Dex: {ProtocolFamily: {not: "pump"}}}, any: [{Trade: {Currency: {MintAddress: {notIn: [$usdc, $usdt]}}, Side: {Currency: {MintAddress: {is: $wsol}}}}}, {Trade: {Currency: {MintAddress: {not: $usdc}}, Side: {Currency: {MintAddress: {is: $usdt}}}}}, {Trade: {Side: {Currency: {MintAddress: {is: $usdc}}}}}, {Trade: {Currency: {MintAddress: {notIn: [$wsol, $usdc, $usdt]}}, Side: {Currency: {MintAddress: {notIn: [$wsol, $usdc, $usdt]}}}}}]}
orderBy: {descendingByField: "usd"}
limit: {count: 100}
) {
Trade {
Currency {
Symbol
Name
MintAddress
}
Side {
Currency {
Symbol
Name
MintAddress
}
}
price_last: PriceInUSD(maximum: Block_Slot)
price_1h_ago: PriceInUSD(minimum: Block_Slot)
}
dexes: uniq(of: Trade_Dex_ProgramAddress)
amount: sum(of: Trade_Side_Amount)
usd: sum(of: Trade_Side_AmountInUSD)
traders: uniq(of: Trade_Account_Owner)
count(selectWhere: {ge: "100"})
}
}
}
Variables
{
"time_ago": "2025-02-01T16:03:59Z",
"wsol": "So11111111111111111111111111111111111111112",
"usdc": "EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v",
"usdt": "Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB"
}
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