Trades of wallets with balance Updates in that trades
Trades made by the wallets in `addressList`, with the balance updates from those same transactions joined on. Uses `DEXTradeByTokens` rather than `Solana.DEXTrades`: DEXTrades keeps only about 12 hours on Solana and has no archive, so the previous version returned no rows whenever the wallet had not traded in the last half day. DEXTradeByTokens keeps about 7 days and supports `archive` for older windows.
What it returns
- block time
- trade amount
- amount in USD
- currency name
- currency symbol
- currency mint address
- decimals
- side amount
- side amount in USD
- side currency name
- side currency symbol
- side currency mint address
- side decimals
- transaction signature
- signer
- pre balance
- post balance
- account address
- token owner
The query
query MyQuery($addressList: [String!]) {
Solana {
DEXTradeByTokens(
limit: { count: 10 }
orderBy: { descending: Block_Time }
where: {
Transaction: { Result: { Success: true } }
any: [
{ Trade: { Account: { Address: { in: $addressList } } } }
{ Trade: { Account: { Token: { Owner: { in: $addressList } } } } }
{ Transaction: { Signer: { in: $addressList } } }
]
}
) {
Block { Time }
Trade {
Amount
AmountInUSD
Currency { Name Symbol MintAddress Decimals }
Side {
Amount
AmountInUSD
Currency { Name Symbol MintAddress Decimals }
}
}
Transaction { Signature Signer }
joinBalanceUpdates(join: left, Transaction_Signature: Transaction_Signature) {
Block { Time }
BalanceUpdate {
PreBalance
PostBalance
Account { Address Token { Owner } }
}
}
}
}
}
Variables
{
"addressList": [
"GHigB15jr7wZ8GitjD4Hf5naqyUJfMbKa1n1PmSiBhUc"
]
}
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