GetTradesFromTblDEXTrades
Returns one DEX trade on Solana, where sell currency mint address is AzrZKU…pump or So1111…1112 and buy currency mint address is AzrZKU…pump or So1111…1112, sorted by block slot, highest first: slot, block time, buy account address, buy account owner, buy token owner, buy amount, buy amount in USD and 17 more fields.
What it returns
- slot
- block time
- buy account address
- buy account owner
- buy token owner
- buy amount
- buy amount in USD
- buy currency mint address
- buy price
- buy price in USD
- program address
- protocol family
- protocol name
- market address
- sell account address
- sell account owner
- sell token owner
- sell amount
- sell amount in USD
- sell currency mint address
- sell price
- sell price in USD
- transaction signature
- signer
Filters
- sell currency mint address is AzrZKU…pump or So1111…1112
- buy currency mint address is AzrZKU…pump or So1111…1112
The query
query GetTradesFromTblDEXTrades($token: String) {
Solana(dataset: realtime) {
DEXTrades(
where: {Trade: {Sell: {Currency: {MintAddress: {in: ["AzrZKUBy6psfR3peBkW4PW6gDr823TEPcygSDM2npump", "So11111111111111111111111111111111111111112"]}}}, Buy: {Currency: {MintAddress: {in: ["AzrZKUBy6psfR3peBkW4PW6gDr823TEPcygSDM2npump", "So11111111111111111111111111111111111111112"]}}}}, Transaction: {Result: {Success: true}}}
limit: {count: 1}
orderBy: {descending: Block_Slot}
) {
Block {
Slot
Time
}
Trade {
Buy {
Account {
Address
Owner
Token {
Owner
}
}
Amount
AmountInUSD
Currency {
MintAddress
}
Price
PriceInUSD
}
Dex {
ProgramAddress
ProtocolFamily
ProtocolName
}
Market {
MarketAddress
}
Sell {
Account {
Address
Owner
Token {
Owner
}
}
Amount
AmountInUSD
Currency {
MintAddress
}
Price
PriceInUSD
}
}
Transaction {
Signature
Signer
}
}
}
}
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