pumpfun aggregate may example
Returns 200 DEX trades by token on Solana, where DEX protocol name is pump and block time since 2024-05-31, sorted by block date: count, unique of trade account owner, sum of trade side amount in USD and block date.
What it returns
- count
- unique of trade account owner
- sum of trade side amount in USD
- block date
Filters
- DEX protocol name is pump
- block time since 2024-05-31
The query
{
Solana(dataset: archive, aggregates: yes) {
DEXTradeByTokens(
limit: {count: 200}
orderBy: {ascending: Block_Date}
where: {Trade: {Currency: {}, Dex: {ProtocolName: {is: "pump"}}}, Transaction: {Result: {Success: true}}, Block: {Time: {since: "2024-05-31T10:15:49Z"}}}
) {
count
traders: uniq(of: Trade_Account_Owner)
buy_usd: sum(of: Trade_Side_AmountInUSD, if: {Trade: {Side: {Type: {is: buy}}}})
sell_usd: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: sell}}}}
)
Block {
Date
}
}
}
}
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