Trades of all pumpfun tokens

Returns 100 DEX trades by token on Solana, where DEX protocol name is pump and block time since 2024-07-17, sorted by trade last price maximum, highest first: market address, currency symbol, currency name, currency mint address, trade price, count, unique of trade account address and sum of trade side amount in USD.

By Aleksey · saved 17 July 2024 · run 38 times · Bitquery API v2

What it returns

Filters

The query

query PumpFunRecentTrades($from: DateTime) {
                  Solana {
                    DEXTradeByTokens(
                      limit: {
                        count: 100
                      }
                      orderBy: {
                        descendingByField: "Trade_lastPrice_maximum"
                      }
                      where: { 
                        Block: {
                          Time: {
                            since: $from
                          }
                        }
                        Trade: {
                          Currency: {
                            Native: false
                          }
                          Dex: {ProtocolName: {is: "pump"}}}, 
                        Transaction: {Result: {Success: true}}}
                    ) {
                      Trade {
                        Market {
                          MarketAddress
                        }
                        Currency {
                          Symbol
                          Name
                          MintAddress
                        }
                        lastPrice: Price(maximum: Block_Slot)
                        prePrice: Price(minimum: Block_Slot)
                        
                      }
                      trades: count
                      traders: uniq(of: Trade_Account_Address)
                      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}} }})
                    }
                  }
                }

Variables

{
  "from": "2024-07-17T06:00:00Z"
}

Similar queries