qqqqqq
Returns DEX trades on Solana, where buy currency mint address is So1111…1112, DEX protocol name is pump and DEX protocol name is raydium_amm: signer, unique of trade buy currency mint address, count, sum of trade sell amount in USD, unique of trade sell currency mint address and sum of trade buy amount in USD.
What it returns
- signer
- unique of trade buy currency mint address
- count
- sum of trade sell amount in USD
- unique of trade sell currency mint address
- sum of trade buy amount in USD
Filters
- buy currency mint address is So1111…1112
- DEX protocol name is pump
- DEX protocol name is raydium_amm
- block time since 2025-02-09
- buy amount is at least 1000000
- sell amount is above 0
- buy amount is above 0
- sell price in USD is at most 0.8
The query
{
Solana {
buy: DEXTrades(
where: {
Block: {
Time: {
since: "2025-02-09T00:00:00Z"
}
}
Transaction: {
Signer: {
#is: "niggerd597QYedtvjQDVHZTCCGyJrwHNm2i49dkm5zS"
}
Result: {
Success: true
}
},
Trade: {
Dex: {
ProtocolName: {
is: "pump"
}
},
Buy: {
Amount: {
ge: "1000000"
}
}
Sell: {
Amount: {
gt: "0"
},
Currency: {
Native: true
}
}
}
}
) {
Transaction {
Signer
}
tokens: uniq(
of: Trade_Buy_Currency_MintAddress
selectWhere: {
le: "100"
}
)
txs: count(
selectWhere: {
le: "100"
}
)
volume_usd: sum(
of: Trade_Sell_AmountInUSD
selectWhere: {
ge: "1000"
}
)
}
sell: DEXTrades(
where: {
Block: {
Time: {
since: "2025-02-09T00:00:00Z"
}
}
Transaction: {
Signer: {
#is: "niggerd597QYedtvjQDVHZTCCGyJrwHNm2i49dkm5zS"
}
Result: {Success: true}
},
Trade: {
Dex: {
ProtocolName: {is: "raydium_amm"}
},
Buy: {
Amount: {
gt: "0"
}
Currency: {
MintAddress: {
is: "So11111111111111111111111111111111111111112"
}
}
}
Sell: {
PriceInUSD: {
le: 0.8
}
}
}
}
) {
Transaction {
Signer
}
tokens: uniq(
of: Trade_Sell_Currency_MintAddress
selectWhere: {
le: "100"
}
)
txs: count(
selectWhere: {
le: "100"
}
)
volume_usd: sum(
of: Trade_Buy_AmountInUSD
selectWhere: {
ge: "10000"
}
)
}
}
}
Similar queries
- PumpSwap boost buy-and-burn trades · Solana · DEXTrades
- PumpSwap trades count by instruction method · Solana · DEXTrades
- FOMO App: One Wallet's Trades (Solana) · Solana · DEXTrades
- FOMO App: Latest Trades (Solana) · Solana · DEXTrades
- Solana dextrades for a token · Solana · DEXTrades