Query missing data
Returns DEX trades and instructions on Solana, where program method is buy or sell, program name is pump and block height is at least 293862535: method, program name, buy amount, buy account address, buy currency name, buy currency symbol, buy currency mint address and 36 more fields.
What it returns
- method
- program name
- buy amount
- buy account address
- buy currency name
- buy currency symbol
- buy currency mint address
- buy decimals
- buy fungible
- buy URI
- buy price in USD
- sell amount
- sell account address
- sell currency name
- sell currency symbol
- sell currency mint address
- sell decimals
- sell fungible
- sell URI
- sell price in USD
- transaction signature
- success
- transaction index
- block height
- block time
- instruction index
- accounts address
- is writable
- token mint
- token owner
- program ID
- arguments name
- arguments type
- json
- float
- bool
- hex
- big integer
- value address
- string
- integer
- program address
- error message
Filters
- program method is buy or sell
- program name is pump
- block height is at least 293862535
- block height is at most 293862635
The query
query SolanaStreamQuery($blockHeightMin: String!, $blockHeightMax: String!) {
Solana {
DEXTrades(
where: {Instruction: {Program: {Method: {in: ["buy", "sell"]}, Name: {is: "pump"}}}, Transaction: {Result: {Success: true}}, Block: {Height: {ge: $blockHeightMin, le: $blockHeightMax}}}
) {
Instruction {
Program {
Method
Name
}
}
Trade {
Buy {
Amount
Account {
Address
}
Currency {
Name
Symbol
MintAddress
Decimals
Fungible
Uri
}
PriceInUSD
}
Sell {
Amount
Account {
Address
}
Currency {
Name
Symbol
MintAddress
Decimals
Fungible
Uri
}
PriceInUSD
}
}
Transaction {
Signature
Result {
Success
}
Index
}
Block {
Height
Time
}
}
Instructions(
where: {Block: {Height: {ge: $blockHeightMin, le: $blockHeightMax}}, any: [{Instruction: {Program: {Method: {is: "create"}, Name: {is: "pump"}}}, Transaction: {Result: {Success: true}}}, {Instruction: {Program: {Method: {is: "initialize2"}, Name: {is: "raydium_amm"}, Address: {is: "675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8"}}}, Transaction: {Result: {Success: true}}}]}
) {
Block {
Height
Time
}
Instruction {
Index
Accounts {
Address
IsWritable
Token {
Mint
Owner
ProgramId
}
}
Program {
Arguments {
Name
Type
Value {
... on Solana_ABI_Json_Value_Arg {
json
}
... on Solana_ABI_Float_Value_Arg {
float
}
... on Solana_ABI_Boolean_Value_Arg {
bool
}
... on Solana_ABI_Bytes_Value_Arg {
hex
}
... on Solana_ABI_BigInt_Value_Arg {
bigInteger
}
... on Solana_ABI_Address_Value_Arg {
address
}
... on Solana_ABI_String_Value_Arg {
string
}
... on Solana_ABI_Integer_Value_Arg {
integer
}
}
}
Method
Name
Address
}
}
Transaction {
Signature
Result {
Success
ErrorMessage
}
Index
}
}
}
}
Variables
{
"blockHeightMin": "293862535",
"blockHeightMax": "293862635"
}
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