alpha4
Returns 1000 DEX trades by token on Solana, where currency mint address is 6URpLQ…aen2 and block time after 2024-01-01, sorted by side bought USD, highest first: account owner, decimals, sum of trade amount, sum of trade side amount, sum of trade side amount in USD and count.
What it returns
- account owner
- decimals
- sum of trade amount
- sum of trade side amount
- sum of trade side amount in USD
- count
Filters
- currency mint address is 6URpLQ…aen2
- block time after 2024-01-01
The query
query TopTraders($token: String, $time_ago: DateTime) {
Solana(dataset: combined) {
DEXTradeByTokens(
orderBy: {descendingByField: "sideBoughtUsd"}
limit: {count: 1000}
where: {
Trade: {
Currency: {MintAddress: {is: $token}}
},
Transaction: {Result: {Success: true}},
Block: {Time: {after: $time_ago}}
}
) {
AccountOwner: Trade {
Account {
Owner
}
}
Trade {
Currency {
Decimals
}
}
bought: sum(
of: Trade_Amount
if: {Trade: {Side: {Type: {is: buy}}}}
)
sold: sum(
of: Trade_Amount
if: {Trade: {Side: {Type: {is: sell}}}}
)
sideBought: sum(
of: Trade_Side_Amount
if: {Trade: {Side: {Type: {is: buy}}}}
)
sideBoughtUsd: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: buy}}}}
)
sideSold: sum(
of: Trade_Side_Amount
if: {Trade: {Side: {Type: {is: sell}}}}
)
sideSoldUsd: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: sell}}}}
)
buyCount: count(if: {Trade: {Side: {Type: {is: buy}}}})
sellCount: count(if: {Trade: {Side: {Type: {is: sell}}}})
}
}
}
Variables
{
"token": "6URpLQmJStfS8hCk2uiDstCJJYqNnGyUcYFLT786aen2",
"time_ago": "2024-01-01T10:59:24Z"
}
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