Token pairs limit by 1
Returns 100 DEX trades by token on Solana, where block time after 2024-08-20, 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 4 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
- count
Filters
- block time after 2024-08-20
The query
query($time_10min_ago: DateTime, $time_1h_ago: DateTime, $time_3h_ago: DateTime) {
Solana(aggregates: only) {
DEXTradeByTokens(
where: {Transaction: {Result: {Success: true}}
Block: {
Time: {
after: $time_3h_ago
}
}
}
orderBy: {descendingByField: "usd"}
limit: {count: 100}
limitBy: {by: [Trade_Side_Currency_MintAddress, Trade_Currency_MintAddress] count: 1}
) {
Trade {
Currency {
Symbol
Name
MintAddress
}
Side {
Currency {
Symbol
Name
MintAddress
}
}
price_last: PriceInUSD(maximum: Block_Slot)
price_10min_ago: PriceInUSD(maximum: Block_Slot if: {Block: {Time: {before: $time_10min_ago}}})
price_1h_ago: PriceInUSD(maximum: Block_Slot if: {Block: {Time: {before: $time_1h_ago}}})
price_3h_ago: PriceInUSD(minimum: Block_Slot)
}
dexes: uniq(of: Trade_Dex_ProgramAddress)
amount: sum(of: Trade_Side_Amount)
usd: sum(of: Trade_Side_AmountInUSD )
count(selectWhere: {ge: "100"} )
}
}
}
Variables
{"time_10min_ago": "2024-08-20T12:00:00Z",
"time_1h_ago": "2024-08-20T11:00:00Z",
"time_3h_ago": "2024-08-20T09:00:00Z"
}
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