Pumpfun pools SOL and token balances

Returns balance updates on Solana, where currency mint address is 111111…1111, LDbNVj…pump or 3 more and block time since 2024-06-25: token owner, account address, currency mint address, native and post balance.

By Aleksey · saved 25 June 2024 · run 5 times · Bitquery API v2

What it returns

Filters

The query

query PumpFunRecentTrades($from: DateTime, $pools: [String!], $tokens: [String!] ) {
  Solana {
    BalanceUpdates(
    
      where: { 
        Block: {
          Time: {
            since: $from
          }
        }
        
        BalanceUpdate: {
          Currency: {
            MintAddress: {
              in: $tokens
            }
          }
        }
        any: [
          {BalanceUpdate: {
            Account: {
              Address: 
              {
                in: $pools
              }
            },
            Currency: {
              Native: true
            }
          }},
          {
            BalanceUpdate: {
              Account: {
                Token: {
                  Owner: {
                    in: $pools
                  }
                }
              },
              Currency: {
                Native: false
              }
            }
          }
        ]
        
      }
    ) {
    		BalanceUpdate {
          Account {
            Token {
              Owner
            }
            Address
          }
          
          Currency {
            MintAddress
            Native
          }
          PostBalance(maximum: Block_Slot)
          
        }
      }
  }
}

Variables

{
  "from": "2024-06-25T07:00:00Z",
  "pools": [
    "73ZzSgNi27V9MdNQYyE39Vs9m1P9ZKgGPCHAJHin5gLd",
    "DwPwU1PAjTXtYNYkeR6awYMDBdSEk12npKzJWKbDHMta",
    "FJ4P2a2FqaWmqYpBw9eEfWD6cXV3F2qLPHvAA5jozscS",
    "6crUHiCoxZsQuxdMAB18VATKrg7ToyTVxt7MbLYmtugu"
  ],
  "tokens": [
    "11111111111111111111111111111111",
    "LDbNVjfowHMVzJQhQZCxQaUkoJNNsD7BU1f4wy8pump",
    "HM66sDN4GhLdmGKsQJKNr5fujcfks3g9Fm2SuABFpump",
    "HnixX5WvZ67Sdnx5cjyAmWV71GdxFZtYHWyt3d1pump",
    "HAvwR3QT9xvGVB9MWhVUHskwa8vKNPbUaxFw38apump"
  ]
}

Similar queries