Copy of solqhere

Returns 25000 transfers on Solana, where block slot is above 0: currency name, currency symbol, currency mint address, receiver address, receiver token owner, sender address, sender token owner and 2 more fields.

By gaurav · saved 28 November 2024 · Bitquery API v2

What it returns

Filters

The query

query ($block: String, $currencies: [String!], $holders: [String!], $count: Int, $offset: Int) {
  Solana(network: solana, dataset: realtime) {
    a: Transfers(
      where: {Transfer: {Currency: {MintAddress: {in: $currencies}}, Sender: {Address: {in: $holders}}}, Block: {Slot: {gt: $block}}, Transaction: {Result: {Success: true}}}
      limit: {count: $count, offset: $offset}
    ) {
      Transfer {
        Currency {
          Name
          Symbol
          MintAddress
        }
        Receiver {
          Address
          Token {
            Owner
          }
        }
        Sender {
          Address
          Token {
            Owner
          }
        }
      }
      uniq(of: Transfer_Receiver_Address)
      sum(of: Transfer_Amount)
    }
    b: Transfers(
      where: {Transfer: {Currency: {MintAddress: {in: $currencies}}, Receiver: {Address: {in: $holders}}}, Block: {Slot: {gt: $block}}, Transaction: {Result: {Success: true}}}
      limit: {count: $count, offset: $offset}
    ) {
      Transfer {
        Currency {
          Name
          Symbol
          MintAddress
        }
        Receiver {
          Address
          Token {
            Owner
          }
        }
        Sender {
          Address
          Token {
            Owner
          }
        }
      }
      uniq(of: Transfer_Receiver_Address)
      sum(of: Transfer_Amount)
    }
    c: Transfers(
      where: {Transfer: {Currency: {MintAddress: {in: $currencies}}, Sender: {Token: {Owner: {in: $holders}}}}, Block: {Slot: {gt: $block}}, Transaction: {Result: {Success: true}}}
      limit: {count: $count, offset: $offset}
    ) {
      Transfer {
        Currency {
          Name
          Symbol
          MintAddress
        }
        Receiver {
          Address
          Token {
            Owner
          }
        }
        Sender {
          Address
          Token {
            Owner
          }
        }
      }
      uniq(of: Transfer_Receiver_Address)
      sum(of: Transfer_Amount)
    }
    d: Transfers(
      where: {Transfer: {Currency: {MintAddress: {in: $currencies}}, Receiver: {Token: {Owner: {in: $holders}}}}, Block: {Slot: {gt: $block}}, Transaction: {Result: {Success: true}}}
      limit: {count: $count, offset: $offset}
    ) {
      Transfer {
        Currency {
          Name
          Symbol
          MintAddress
        }
        Receiver {
          Address
          Token {
            Owner
          }
        }
        Sender {
          Address
          Token {
            Owner
          }
        }
      }
      uniq(of: Transfer_Receiver_Address)
      sum(of: Transfer_Amount)
    }
  }
}

Variables

{
  "block": 0,
  "currencies": [
    ""
  ],
  "holders": [
    ""
  ],
  "count": 25000,
  "offset": 0
}

Similar queries