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.
What it returns
- currency name
- currency symbol
- currency mint address
- receiver address
- receiver token owner
- sender address
- sender token owner
- unique of transfer receiver address
- sum of transfer amount
Filters
- block slot is above 0
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
- SOL Transfers · Solana · Transfers
- Pumpfun tokens created historically on specific date · Solana · Transfers
- Inflows and Outflows calculation - Solana · Solana · Transfers
- FOMO App: Fees Paid to the Fee Account, Last Hour (Solana) · Solana · Transfers
- SOL Transfers error Active billing · Solana · Transfers